You may want to rename the table before doing this. Click the icon with two arrows pointing away from one another to expand the table.

Once you have the list as a table, you need to specify which columns you want excel to make use of as well as have the opportunity to specify how any inner lists (array fields) may be dealt with. Click “To Table” to convert the list to a table. One you have found the list you are looking for, the list needs to be converted to a table for Excel to use. Click through the record to see what’s inside Once you find the list, go ahead and click it to open it. Click through any single records until you find a list.

This should fetch the file and bring you into the query editor. To do this, instead of clicking “From JSON”, click “From Web” and enter the URL. If you are using a web API, you may choose instead to import the data directly from the web.

This should bring you into the query editor. Find the file on your disk and click Import. When clicking “From JSON”, you will be presented with a file browser. When I click on the file name in the Queries section it does the data download of 1.5 GB all over again with the same two upper rows showing in a second spreadsheet.Step 1: Open The Data in the Query Editor Once the Query Editor has loaded data, I've click Convert > Into Table, then Close & Load.Īll that shows in my Excel spreadsheet are two upper rows in two columns -Īnd at the right in a 'Queries & Connections' section - Queries - '20210705_1.json' This starts 'Connecting' which takes ages and then a Get & Transform (Power Query) which brings 1.5 GB. I've used Excel - Data - Gt Data - From File - From JSON, which open Import Data window where I select previously downloaded file '20210705_1.json'. I'm trying to import legitimately from web large data file in JSON format. JSON file that I would like to import into Excel. Please, Please, Please help me with a way to get the Get Data process to actually work properly.

Exceltojson