When creating a new chemical catalog using ChemBioFinder, users usually have some data in chemical format (SDFile) and some data in Excel spreadsheets. This video demonstrates how to merge two such files, using Alfa Aesar’s chemical catalog. Alfa Aesar originally kept their chemical structures in an SDFile, indexed by an “Item Number” code. That code matched up with their price list in Excel. Our steps include:
- Importing an SDFile into a new ChemBioFinder database.
- Linking by exactly matching the column name in Excel vs. the SDFile.
- Converting an Excel spreadsheet to a TXT file for import.
- Merge the Excel price data into ChemBioFinder.
- Observing “tabs” in ChemBioFinder for each data source, and moving fields between tabs.
- Exporting the merged data to a new SDFile with both chemical structures and price data.