This can be done by right clicking a column and selecting move.Ĩ.) You can also replace values.

Take this opportunity to move the columns around as you see fir. Selected them as desired.ħ.) The data will then be broken out. These are the columns that are listed in the records. To break these out of the list we will need to select 'To Table'.Ħ.) the second part of the data break out is to Select the break out arrows, and select the columns you'd like to be included. lets go ahead and click the list.Ĥ.) You will now see all the records that were in that list that make sup the audit log. Browse and open the recently downloaded Json Fileģ.) Here we can see that there are 156 entries. The file will then download on your device.Ģ.) Open up excel and select Data > Get Data > From File > From JSON. These instruction can be found here: Setting up SaaS Audit Logsġ.) Once you have run the API to capture the data it will then allow you to download this data in the form of a json File: Click Download.

The Excel file is created immediately at the chosen location, no need to ‘run’ anything.First and foremost you will need to have enabled SaaS audit logging and created an API token that will authorize the audit log Json data.

A green output item is added and selected.

Select Excel file (*.xlsx) or Excel file (*.xls) as the file type.

Ensuring the pink input item is selected, click the To File button in the Left pane (scroll to the bottom of the Left pane).

You can set the Format drop-down in the Right pane to Long or Wide, depending on whether you want the tables to have more rows or more columns.

Notice in the Right pane that the JSON data has has been automatically ‘flattened’ into a table, suitable for output to an Excel.

Drag the JSON file you wish to convert onto Easy Data Transform.

Make sure the Auto Run button is pressed in. There is a fully functional free trial and you don’t have to give us your email or sign up to anything.

Install Easy Data Transform on your PC or Mac, if you haven’t done so already.

But you can easily convert JSON to Excel with Easy Data Transform:

They are very different in structure (JSON is text structured as a tree and Excel is proprietary data structured as one or more tables). JSON and Excel are both extensively used for storing and exchanging data.

Convert json to excel