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?

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:

1. Open your Excel spreadsheet containing SMILES.
2. Select the SMILES column.
3. 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.
4. 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.