Forum Discussion
Trouble loading JSON to Excel
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 th...
I was having the same issue and i was able to fix this by highlighting the [Record] column in the power query editor and selecting the "expand" option under the "Structured Column" tab:
Hope this helps others in the future too!