Skip to content
Kibi Connect
Manual Kibi Connect

How do I import contacts and companies via CSV?

Updated Reading time: 2 min

On this page

You can import many contacts and companies into the CRM at once, such as an address list from another software or your trade fair contacts. If something goes wrong, you can undo the entire import with a single click.

Preparing the CSV file#

The first line of the file contains the column names, and each subsequent line contains a contact or a company. Semicolons and commas can be used as separators, and umlauts from Excel are transferred correctly. You can write the column names in German or English:

Column

Content

Type

Company or Contact. Without this column, a line without a person's name but with a company name is created as a company.

Name

For companies, the company name; for contacts, the full name

First name, Last name

Name of the contact

Company

Company to which a contact belongs. If it does not exist yet, it will be created.

Job title

Position of the contact, e.g., Purchasing

Email, Phone, Mobile, Website

Contact details

Street, ZIP code, City, Country

Address

Tags

Multiple tags separated by commas

Visibility

Only me for private entries, otherwise everyone can see the entry

Notes

Free text

Import CSV file#

Click on CRM in the navigation on the left.

Click on More actions (⋯) at the top right next to New and select Import CSV.

Menu next to „New“ with the entries „Import CSV“, „Export address list“ and „Contacts as vCards“

Under CSV file, select your file and click on Import.

The window shows how many entries were imported and how many were skipped. Under Recent imports, the import is listed with the file name, time, and who performed it.

Result „Import completed: 5 imported, 2 skipped (duplicates)“ with the buttons „View“ and „Undo“ and the list „Recent imports“

Info

Duplicates are skipped: a contact with an email address or a first and last name that already exists, and a company that already exists with the same name at the same location. For an existing company, the import only fills in fields that are still empty there.

View Imported Entries#

In the results, click on View or, under Recent Imports, click on the import.

The list now shows only the contacts and companies from this file. At the top, the filter Import appears with the file name.

CRM list with the filter „Import: contacts-trade-fair.csv“, three contacts and two companies

Using the Import filter, you can select a different import or use All Entries to return to the full list. Reset Filters clears all filters.

Undo import#

Click on More actions (⋯) at the top right next to New and select Import CSV.

Under Recent imports, click on Undo for the desired import. Right after an import, you will also find the button in the result.

Confirm with Move to trash.

Confirmation prompt "Undo import?": 5 entries from "contacts-trade-fair.csv" will be moved to the trash

All entries from the file are now in the trash, and the import is marked as Undone under Recent imports.

List "Recent imports" with the import "contacts-trade-fair.csv" in the status "Undone"

Info

From the Trash under the CRM list, you can restore individual entries. Large imports are undone in the background; you can see the status under Recent imports. Entries that you are not allowed to delete will remain. Fields that the import added to existing companies will also remain.