Importing an Excel, Calc or CSV file

Spreadsheet programs (such as Microsoft Excel® or OpenOffice.org Calc®) store structured information, often displayed as a table:

Example of a table before an import

The first line (column header) generally contains a brief description of the kind of data that is represented in that column. Every line in the table contains a new record. Simple text files can also contain data structured in this way. Such data can easily be imported into Citavi.

The first time you import a text file with tabular data, you configure how reference types in the file will be mapped to reference types in Citavi. For example, if in your table you have the description "web page," you can tell Citavi to enter this data as an Internet Document (see step 7 below).

  1. On the File menu, click Import.
  2. Select File containing tabular data and click Next.
  3. Select the format of the file you are importing and click Next. (If you already created an import filter it is displayed here).
  4. Click Browse to select the file to import, and then click Next. If the spreadsheet or database file contains more than one worksheet or table, select the one that contains the references you want to import and click Next.
  5. If your file only contains one reference type (for example, journal articles) and for that reason doesn't contain a column with the reference type, select Not available on the Column/Field menu.
    If the file contains a column with the reference type, select the column/field that contains it on the Column/Field menu. Then for each reference type in Citavi, type the name of that reference type as it appears in the file. For example, if your file calls journal articles "article", then type article next to Journal article.
  6. Select the reference type you want to define the field mappings for and click Next.
  7. Assign the fields in the source file to the corresponding Citavi fields for the selected reference type.
    Please note: for the import to work, at least one column needs to be assigned to the Citavi Title field.
  8. After you are done with one reference type, you will see the message Do you want to define the field mappings for another reference type? If there are more document types in the source file that you want to define, select Yes. Then click Next.
    To save the custom filter you have created for future imports using the same field structure, select Save as and type a name.
  9. Click Next to begin the import.

Import Hints

Importing files

You might want to import images as covers for books or PDF files as attachments. To do so, create a column for covers or attachments. Enter the path to the files, for example C:\Users\john.doe\Documents\PDFs\Steinert_A systematic review of fac dev initiatives.pdf. If you import an Excel file into a cloud project the images and attachments will be imported into the cloud project. If you import the Excel file into a local project, Citavi will only save the path to the attachments. You can then copy or move the PDFs to the Citavi Attachments file.

Importing location information

If you want to import multiple locations for a reference at once, you need to add multiple colmns to your Excel file. The columns need to be in the following order:

Location 1, Call number 1, Notes 1, Location 2, Call number 2, Notes 2, ...

During the import Citavi will add this information to the most recently created location. If the most recently created location already had a field to be imported (if it already had a location) then Citavi will create a new location. So, all of the fields for a location should be imported first before the next location is imported.

Importing categories

You can create a column for categories in your table to create a category system in Citavi. However, it's not possible to add a hierarchical structure. After the import you will need to use the arrow keys to put the categories into the right place.

If one reference has multiple categories, make sure to separate the categories with a semicolon with no spaces before importing:

Reference 1 | History

Reference 2 | Economics

Reference 3 | History;Economics

This rule does not apply to keywords.

Importing labels

In Citavi you can use a blue or red label to mark a reference. If you already use a similar designation in your Excel file, create one column for the blue label and one for the red label. Enter the value not empty or empty.

Special case: importing contributions in edited books

Excel files containing edited books and contributions in edited books have to be amended with two additional columns before they can be imported correctly.

Your Excel spreadsheet may look like this:

importing_database_spreadsheet_and_csv_files-2

Start the assistant to import a file containing tabular data (see above). This will let you assign which fields in the source file are associated with the document type Book, Edited. Now select the column containing the previously defined, sequential numbering and link it to the Citavi field labeled Import ID. Remember to also assign the other fields in the source file to the corresponding Citavi fields for the selected reference type:

importing_database_spreadsheet_and_csv_files-3

Likewise, proceed in the same manner when determining which cells are associated with the document type Contribution. Select the column containing the ID or ISBN and link it to the Citavi field labeled In (Import ID). This allows Citavi to identify the parent reference for each contribution:

importing_database_spreadsheet_and_csv_files-4