MacOS – Excel API data query – populates into a single column

macosms officeoffice-365settings

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.

Coin market cap data into a single column

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

Process flow:

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

Thanks for the help,
Chris

Best Answer

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.

Related Question