Spreadsheet
Molecule2PubChemLCSS
Molecule2PubChemLCSS by Jordi Cuadros This Google spreadsheet will allow anyone to connect a list of up to 1,000 chemical names to safety chemical information available in PubChem LCSS. To obtain the spreadsheet you click the content link, which directs you to Google Docs and allows you to make your own copy of the sheet. It […]
InChILayersExplorer – A Spreadsheet to teach and learn the structure of an InChI
This post consist of a simple spreadsheet that takes that splits an InChI in its layers to facilitate its conceptualisation and its teaching. It considers the six layers currently detailed in the InChI TechnicalFAQ, https://staging.inchi-trust.info/technical-faq-2/#4.3. The spreadsheet also facilitates looking up an InChI by entering the molecule name or its SMILES representation.
Batch Chemical IDs Conversion in Spreadsheets
Common tools for conversions, including some spreadsheet-based options included in this site, are hard to use for hundred or thousands of compounds we may want to use in cheminformatics projects. This resource includes a diferent approach to the conversion. By using the PubChem Power User Gateway it allows converting hundreds of chemical identifiers on a […]
Identifier conversion on an Excel spreadsheet
This resource is a simple spreadsheet in Excel that provides a handy interconversion between different chemical identifiers, namely name, InChI, InChIKey and SMILES. It uses some web services to do translations, i.e. PubChem PUG REST and NCI/CADD Chemical Identifier Resolver. This workbook does not uses macros but makes use of the WEBSERVICE function added to […]
IUPAC Name2PubChem
This submission shows you how to create a smart spreadsheet with Google Sheets that links an IUPAC name to a chemical’s PubChem landing page. You may click here to get a copy of this sheet. This particular sheet uses the Centre for Molecular Informatics OPSIN (Open Parser for Systematic IUPAC nomenclature) web service to convert the name […]