contents   previous   next

5.3  Importing Spreadsheets in CSV Format

If you save spreadsheets in "CSV Format", you can import them into Catalyzer. This is an alternative to the Copy/Paste method described in the previous section.


Saving a spreadsheet in CSV format. All spreadsheet applications have an option to save data in the standard CSV format (it will appear in the Save or Export menu on the spreadsheet application). Note that Catalyzer does not yet have a plug-in that can read the native file formats of spreadsheets (like .xls for Excel). If your spreadsheet application prompts you to choose a character to use for the quotation marks and field separator, choose quote marks and commas respectively.

  1. Save a spreadsheet table in CSV format.

    Saving a spreadsheet in CSV format. Most spreadsheet applications include an option to save as CSV.


  2. Start Catalyzer and create a new Catalog (File > New Catalog):
  3. Right-click (CTRL-click on Mac) on the root folder (called untitled at the start) and select Import > File... from the pop-up menu to import all the data in the file, as shown in the following screen:

    Importing File



    You can import CSV files anywhere in an existing catalog, so you can import multiple spreadsheets into a single catalog.

    The following screen is displayed when you select Import > File:

    Import File Dialog


  4. Type the address of the file or click Browse to browse to the file you want to import, select it and click Open.

    The .csv file has been imported into your catalog.

  5. Select your catalog in the tree view; a new record is there for each line of the spreadsheet, for example:

    Each row of the CSV file becomes a record.



    You can also import other catalogs in this way, as well as other file formats - Import>File and browse to a catalog (with extension .axz or .axc). If you try to import a file that Catalyzer does not recognize, it imports the header information only.