Home arrow Database Manager arrow Exporting Data to Microsoft Excel
Exporting Data to Microsoft Excel

You can export four types of data from Database Manager to Microsoft Excel: text tables, graphics, mass spectra in numerical table format and spectral trees. Because all these types can be accessed at the same time, you must specify the type of data you want to move to Excel.

To export additional information associated with a record:

  1. Choose the Info tab (Info tab data must be visible).

  2. Click the small Copy Selected Tab button in the top right corner of the Info tab control.

  3. Paste the data by clicking the Paste button in Excel.

To export mass spectrum or mass differences graphics:

  1. Choose the Mass Spectrum or Mass Differences tab (Mass Spectrum or Mass Differences tab spectrum must be visible).

  2. Click the small Copy Selected Tab button in the top right corner of the Mass Spectrum tab control.

  3. Paste the graphic by clicking the Paste button in Excel.

To export a mass spectrum in numerical table format:

  1. Choose the Data tab (an m/z and abundance table must be visible).

  2. Click the small Copy Selected Tab button in the top right corner of the Data tab control.

  3. Paste the table by clicking the Paste button in Excel.

To export records data in the spreadsheet:

  1. Select one or more records in the spreadsheet.

  2. Click Copy Selected Rows button right to Spreadsheet tab control.

  3. Paste the data into Excel by clicking the Paste button.