Getting API into Excel

[larry rubin]

I'm not a developer so please don't get too technical. I've been trying to get the results from an API for a crypto website into Excel, but not all in one cell. It displays on the web like a table which is what I want. I've tried the external query feature but there's only one websites results that seem to work for me and of course one that I can't use. The one I want to use only returns data, in quotes with commas but there are no headers or names that other apps use. I'm having a hard time believing that there's not a relatively easy way to get the data into Excel in columns. Am I missing something? Any help greatly appreciated.

[#2]

Can you share what you have?

[#3]

Sure thanks for responding.   Here's a 'snip' showing the data and site.   I think my question was poorly worded, but I just want to get data like this into excel.  It's supposed to be a JSON api, but I have not been able to get the external query feature to work with this or similar data.   Not sure what else to try.  Thanks in advance.

Larry

[#4]

Not very hard to do with PowerQuery, see attached.

[#5]

@larry rubin hope it's not too late. There is excel inbuilt function called WEBSERVICE() to get api data into excel. Hope it helps other who are in need.