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

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:

"[email protected]"; "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

1. Create a new spreadsheet

2. Create columns in exactly the order defined above

3. Enter data

4. File → Save as

5. Choose file type:
   CSV (comma-separated values)

6. 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

1. Create new table

2. Set up columns correctly

3. File → Save as

4. File type: Text CSV (.csv)

5. When exporting:

   • Character set: UTF-8

   • Field delimiter: ;

   • Text delimiter: "

Confirm export.

C) In Google Sheets

1. Create table

2. Set up columns correctly

3. 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"
"[email protected]"; "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