5.2  Importing Spreadsheets using copy/paste

It is possible to import tabular data directly from spreadsheets and databases. This can either be done using copy / paste (highlight the table in the spreadsheet, copy it to the clipboard (using CTRL-C or Command-C on Mac), then paste it into a folder of Catalyzer (right-click>Import>Clipboard on a folder in the catalog tree). You can also import data files in CSV format, a standard interchange format for spreadsheets (right-click>Import>File on a folder in the catalog tree, and pick a .csv file) - see the next page for more details.

Catalyzer assumes the first row of the table holds the field names and subsequent rows each hold a single data entry, for example:

Example of Spreadsheet Data Format

Copying data from Excel

Pasting clipboard data into Catalyzer

The data pasted into Catalyzer (click the Table View button at the bottom right to get this view)

An individual record viewed in Catalyzer. Note that the field names correspond to the column headers in the spreadsheet.

Switching to Class view to rename the Imported Entry class as Person.

To export data back to a spreadsheet, use the Copy button in the "Browse view" or the "Search results"