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



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


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?


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.