You can generate an SDF file from a excel worksheet using ChemDraw for Excel and following these steps:
- Open the file in MS Excel that has ChemDraw for Excel installed
- Go to the ChemOffice ribbon tab
- Click 'Convert Worksheet' and click ‘OK’
- Add a first column called 'Structure'
- Select each empty row and used 'Molecule' > 'Add' to draw the chemical structure
- Once the structures are added, select 'Import/Export' > 'Export Table'
- In the Save As… dialog window type a file name and select 'SDF File (*.sdf, *sd)'
Comments
0 comments
Article is closed for comments.