Getting API into Excel
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.