I am using MacOS Excel, and I am trying to create a webquery by creating a text file and saving it to the queries folder. I am able to get the data but I am having issues formatting it. Is there any documentation somewhere what the syntax for formatting the output of the query is? Currently it downloads everything into the same cell in the form of:
It looks like you work with JSON file. For Windows Excel there is the connector for json, not sure if it exists for Mac. On the other hand there are quite many resources to convert directly like this one https://json-csv.com/.
Try to google, perhaps add-in to convert on Excel for Mac exists.