Home arrow Database Manager arrow Importing Spectra from Microsoft Excel
Importing Spectra from Microsoft Excel

Mass spectra in table format or spectral trees stored in Excel can be imported to Database Manager via the Clipboard. Spectral tables can be organized horizontally or vertically. In order to correctly interpret m/z values and abundance you should follow one of these conventions:

  1. If the spectral table is vertical, the first column must be the m/z value and the second must be abundance.

  2. If the spectra are oriented vertically and the first column is abundance and the second column is the m/z value, you should caption the first row of the first column “Abundance” and the first row of the second column “m/z”.

  3. If the spectral table is oriented horizontally, the first row must be the m/z value and the second row must be abundance.

  4. If your spectra are oriented horizontally and your first row is abundance and the second row is the m/z value, you should caption the first column of the first row “Abundance” and the first column of the second row “m/z”.

  5. More than one spectrum can be imported at a time. In this case your first column or row, depending on the orientation, must be the m/z values and all the other columns (or rows) must be abundance.

To import spectra from Excel to Mass Frontier:

  1. Make sure your table actually contains mass spectra.

  2. Select the table you want to export to Mass Frontier.

  3. Click the Copy button in Excel or if your document is embedded, click the Copy button on the Excel toolbar.

  4. Click the Paste button in the Database Manager window.

Mass Frontier supports standard tables with separated numbers, so spectra can also be imported from other programs.