Kontakte importieren

To import your existing contacts into entrello, go to:

https://entrello.app/contacts

and select the Import Contacts button.

Here you’ll see a modal window that summarizes again what the imported CSV file has to look like.

To import contacts into the contact database, you need a CSV file with:

Semicolon (;) as a separator
Fields in the correct order
Values ideally in quotation marks (" ")
Unknown fields can be left empty

1. Required field order

The CSV file must have exactly the following column order. The first row is treated as a header row and is not imported:

"E-Mail"; "Newsletter"; "Telefon"; "Vorname"; "Nachname"; "Anrede"; "Firmenname"; "USt-IdNr."; "Land"; "Stadt"; "Straße"; "Postleitzahl"; "Labels"

Field explanation

Email	Required field
Newsletter	GDPR consent available (user is responsible). empty: no consent `X` … consent given
Phone	Optional
First name	Optional
Last name	Optional
Salutation	e.g. Mr / Ms
Company name	Optional
VAT ID no.	Optional
Country	Optional
City	Optional
Street	Optional
Postal code	Optional
Labels	For grouping contacts

2. Important notes

Separator: Semicolon (;)

The file must be semicolon-separated (not comma!).

Use quotation marks

It is strongly recommended to put all values in quotation marks (" ").

Example:

"max@example.com"; "X"; "0123456789"; "Max"; "Mustermann"; "Herr"; ""; ""; "DE"; "Berlin"; "Musterstraße 1"; "10115"; "Presse"

Why?
If, for example, there is a semicolon in the name or in notes, the quotation marks prevent incorrect field separation.

Unknown fields

Fields you don't need can simply be left empty:

""; "X"; ""; "Max"; "Mustermann"; ""; ""; ""; ""; ""; ""; ""; "VIP"

3. Create CSV file

A) In Microsoft Excel

Create a new spreadsheet
Create columns in exactly the order defined above
Enter data
File → Save as
Choose file type:
CSV (comma-separated values)
If possible, make sure to use semicolon separation (depending on regional settings, this might be automatic)

Tip: Before saving, make sure there are no extra columns.

B) In LibreOffice Calc

Create new table
Set up columns correctly
File → Save as
File type: Text CSV (.csv)
When exporting:
- Character set: UTF-8
- Field delimiter: ;
- Text delimiter: "

Confirm export.

C) In Google Sheets

Create table
Set up columns correctly
File → Download → Comma-separated values (.csv)

Google exports with commas by default.
If semicolons are needed:

Open the CSV locally in a text editor
Replace commas with semicolons
(only if there are no commas in the data)

Alternatively:

Open the file in Excel or LibreOffice
Export it there correctly as a semicolon CSV file

4. Use labels

The Labels field is used to group contacts.

Examples:

Press
VIP
Concert
Accreditation
Partner

This allows you later to specifically send:

Newsletters to specific groups
Invitations
Accreditations

to them.

5. GDPR notice

For the field Newsletter a valid GDPR consent must exist.
The responsibility for this lies with the importing user.

Example of a complete CSV row

"Email"; "Newsletter"; "Phone"; "First name"; "Last name"; "Salutation"; "Company name"; "VAT ID No."; "Country"; "City"; "Street"; "Postal code"; "Labels"
"max@example.com"; "Yes"; "0123456789"; "Max"; "Mustermann"; "Mr"; "Muster GmbH"; "DE123456789"; "DE"; "Berlin"; "Musterstraße 1"; "10115";

If you have problems with the import, please check:

Correct field order
Semicolon as separator
No additional columns
UTF-8 encoding
Values in quotation marks

Help center