Forum Discussion
Using GetData on JSON file only gives two columns without data
Hello, I'm using Excel 2016. I tried to use the Data ribbon to Get Data\From File\From JSON and imported a file that looks like this: { "categories": [ { "name": "Cheap & Cool Gadgets"...
Hi, have you tried to analysed your json? you can use this tool to do that. https://jsonformatter.org
Jimmi, Power Query is enough for me