Excel API data query - populates into a single column I am trying to populate some data from an API call. 
(Below is the process to get the same example)

Everything works fine until I hit the last button: all the data goes into the first column and does not seem to understand the separator.



Mind that my Language &amp; Settings are for "United Kingdom" which should recognise comma as separator.

Process flow:


create text file with "https://api.coinmarketcap.com/v1/ticker/"
change the .txt file into .iqy
Open Excel, go to Data tab
Get External Data then Run Saved Query
Open the .iqy file
Select new sheet and you're good to go.


Thanks for the help,
Chris
It appears you are attempting to import data in JSON format which is not supported by Excel.

Doing a cursory search, I was able to find an Excel plug-in that converts JSON to XLS (Free).

I have not used this myself, so YMMV.