The Spreadsheet is organized on a row basis. Each record is represented by a single row. The columns contain supplementary record information. In the spreadsheet you can move columns by dragging the appropriate column header to a new position. If you want to move a row, use the cut and paste functions as dragging rows is not supported.

When you open a Database Manager window, the spreadsheet will be empty. You can add records to it by conducting a search, opening spectra or references, or by pasting records or standalone spectra. For an active record the associated spectrum or tree, and structure (optional), appear in the upper half of the window. The hand cursor in the first column indicates which record is active. You can select more then one record, but the row with the hand icon is always the active one.

A Database Manager window can contain 999 records, but you can open as many Database Manager windows as your system allows you to.

Records data from the spreadsheet can be exported to Microsoft Excel in text format.

Sometimes you may need to simultaneously preview all structures, rather than record information in spreadsheet. To display a grid of structures, select the Structure tab next to the Spreadsheet tab. In this window the structures are clearly organized in small cells. If structures need to be enlarged, you can freely resize any structure cell by dragging the edges of the column or row headers.

Note: In the Structure view option you can only select a single record (structure).