5. How to Search PubChem for Chemical Information (Part 1) | DivCHED CCCE: Cheminformatics OLCC

retrieved in the XML format, using the eInfo functionality in E-Utilities (which will be covered in Module 7):

to open these xml files in Google sheets use:
=importxml(A1,"//Field/FullName")
where in A1 you place the link below

Item URL: 
https://hypothes.is/a/bL6tXgjwEeeCoZuYCcaJ7g