Forum Discussion
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 whi...
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
Not very hard to do with PowerQuery, see attached.