How do I get the full table with data per coins with the API?


I just installed the API in google sheets like this:


That works (although not all the time, often in gives me #N/A for a reason I do not get).

But this gives me only the ticker names in column A and the prices in column B.
I like to see the 1 day (1d) change, the 24h percentage change, the market cap, ranking, etc.
I tried things like adding interval=1d, but it does not work.

Can anyone show me how to do this by adjusting my API URL?

Many thanks.


Google Sheet’s support for ImportData has been declining, and we’ve seen more issues with it. Unfortunately I’m not a google sheets pro so I can’t help you much here. If you have issues with the data or API itself let me know.