Import records from a CSV file
Many lists in Kompass can create and update records in bulk from a file. Every one of them uses the same Import dialog: you choose a file, Kompass checks it and tells you what it will do, and nothing is saved until you choose Import.
This article explains the dialog. For the columns a particular list accepts, use the dialog's Download template and Columns buttons, or see the reference articles linked at the end.
Where to find it
Open the list, choose Actions, then Import (on a few lists it names the records, such as Import Expenses). Lists with line items have a second entry for them: Import Allocations on Bills, Bill Payments, Purchase Orders, Payments and Sales Orders, and Import Expense Allocations on Expenses. Time Off has Import Allowance as well. Configuration lists that can be imported have an Import button above the list.
Import is available on Organizations, Contacts, Projects, the Diary, Invoices, Payments, Sales Orders, Expenses, Bills, Bill Payments, Purchase Orders, Suppliers, Equipment, Time Off, Users and the Configuration lists. You only see it on a list if you have that list's import permission. See Permissions reference.

Prepare the file
Kompass imports a .csv file (or a .json file holding a list of rows) of up to 5 MB, one record per row. Column names must match exactly.
- Download template downloads a CSV file with the header row the list accepts. Fill it in, or delete the columns you do not need.
- Columns lists every column with its type and a short description. Required marks a column a new record must fill in. Finds the record marks a column Kompass can use to find the existing record a row updates. Where a column only takes certain values, they are listed.
An export of the same list is a good starting point: export, change the rows, and import the file again.

How rows and cells are read
- Update or create. A row with an
idupdates that record. A row without one is matched on the list's own key, such as a name or an email address, and updates the record it matches. A row that matches nothing creates a new record. Each list's reference article says which columns it matches on. - An
idnever creates a record. If no record has that ID, the row is a problem. To copy records to another Kompass site, leave theidcolumn empty. Configuration lists are the exception: they match a row by name first and use theidonly to rename a value, as Configuration: client and expense lists explains. - A column left out keeps the stored value. To change only a few fields, include
idand just those columns. - A blank cell clears the value on an existing record. A blank yes/no cell means no, and an amount that cannot be empty becomes zero. If the field cannot be empty, the row is a problem instead. On a new record, a blank cell in such a field leaves it at its default.
- Either an ID or a name. Where a list takes the same thing as an ID or a name (for example
client_idorclient_name), fill in one and leave the other blank.
Check the file
Choose a file with Choose a file. Kompass checks it straight away and shows how many records it will create, update and leave unchanged (and delete, on the few lists that allow a delete column). Nothing is saved yet.
A row that matches a record and changes none of its values is counted as unchanged and is not saved again.

If the counts are what you expect, choose Import. Kompass imports the file, closes the dialog, shows the counts in a message and reloads the list. Import stays disabled until a check passes and the file would change something.
When the file has problems
If any row has a problem, nothing is saved: an import is all or nothing. The dialog lists each problem with its row number (the first row after the header is row 1), the column and the reason. Correct the file and choose it again to run a new check.

Some problems concern the whole file rather than a row, for example a column the list does not recognize or a file that is too large. They are shown as a single message instead of a list of rows.
Some lists can only run one import at a time. If someone else is importing the same kind of record, the dialog says so; wait for their import to finish, then choose the file again.