Trouble loading JSON to Excel

[James Palmer]

I have a JSON file that I would like to import into Excel

I have Office 365

I am using the following:

​Use Excel's Get & Transform (Power Query) experience to connect to a JSON file.

Click the Data tab, then Get Data > From File > From JSON.

Browse to your JSON file location, select it, and click Open.

Once the Query Editor has loaded your data, click Convert > Into Table, then Close & Load.

I only receive two rows in my excel spreadsheet but there is quite a bit of data.

Help appreciated.

-JP

[#2]

Use Excel's Get & Transform (Power Query) experience to connect to a JSON file.

Click the Data tab, then Get Data > From File > From JSON.

Browse to your JSON file location, select it, and click Open.

Once the Query Editor has loaded your data, click Convert > Into Table, then Close & Load. I think XML Converter can do it easily for you as well https://www.coolutils.com/TotalXMLConverter

[#3]

@johndre 

Your answer only repeats the process that's shown on Microsoft for the process, which is what the first questioner shows he has done but then has link to pay a $59.90 licence for another XML converter.

What is needed in someone with greater knowledge Microsoft Tech to give an answer to allow the Microsoft process to work correctly.

I also have the same problem getting just data column headings, after clicking on the Query after conversion and downloading 1.5 GB of records but nothing showing again.  I've done this twice and still no success.

Someone on Microsoft Tech please help with a real answer ? ? ?

[#4]

Depending on the json object, you may need to step into it to get to the records and then convert your table from the records in the json string.
The two rows you are returning now, is the data what you expect to see or possibly table names?