2

I have an Excel document and I want to retrieve this data using this API (JSON)

https://api.coingecko.com/api/v3/simple/price?ids=bitcoin&vs_currencies=USD

toolbar

From these buttons from the toolbar, I think I have to use "From Web". But when I click on it, this window appears

window

Then I paste the link from the API in there and it downloads the JSON file - then it redirects back to the default page of that window. So I think this is not the proper way to do it.

How can I import data from that API in Excel?

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.