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.
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.