I had a general doubt. If I want to extract some data, say the information regarding a particular chemical using API of material projects(a site that has open-source info on, say elements) available on the internet, and compile the information on an excel sheet, what would be the simplest way to do so? Can someone guide..it would be great, thanks!

  • $\begingroup$ I think Excel has the option to directly import data from the web. Under the Data ribbon, you should be able to see Get Data > From Other Sources > From Web. There you can directly input the API url and even further transform the data if necessary. $\endgroup$
    – Oxbowerce
    Jun 17, 2021 at 13:21


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.