Product: ChemOffice Desktop
How can I use my Microsoft Excel spreadsheet containing SMILES to be converted to ChemDraw structures when using the ChemDraw for Excel add-in/ChemOffice addin?
You can convert SMILES to structure using the steps mentioned below. You should have ChemDraw Professional or ChemOffice+ Cloud subscription to do so. Steps are below:
- Open your Excel spreadsheet containing SMILES.
- Select the SMILES column.
- Convert the Excel spreadsheet to ChemOffice worksheet. For that, Go to ChemOffice20 - Convert Worksheet. You will get a window to “Select worksheet(s) to process”. Select the “Sheet Name” checkbox and click ‘OK’ to convert.
- When converted, go to ChemOffice20 – Convert – SMILES to Molecule.
Result: That will retrieve the structure for that SMILES in that cell on top of SMILES string in the Excel cell.