You can import users, both internal users and customers, with a CSV file. The CSV file should have comma-separated values, and the column names should be in the first row.

To import user records successfully, your CSV should have the following columns. Columns must be in lowercase:

email = Email address
first_name = First name
last_name = Last name
company_id = The ID of a company 
labels = The exact name of the label (*)
labels_id = The ID of the label (*),

address,

zip,

city,

country

(*) : You can also use a “:” separated list to add labels, e.g., Marketing:Trial:Demo

Please note that the labels’ names are case-sensitive! You do not need to provide a “labels” and a “labels_id” value if you only have one. However, you must always create an empty value in your CSV file (this is automatically done in Excel).

Starting December 12th, 2023, you can update custom field values through CSV import. Use the "variable name" assigned to each custom field to update your custom fields. When importing your CSV file, you should use this variable name as a column header. During the CSV import process, the system will either update the value of an existing custom field or add a new value if the field does not yet exist for a particular contact.

Starting November 19th, 2024, you can import the address, zip, city, and country fields with a CSV import.

---

To import user records successfully, your CSV should have the following columns (header):

email = Email address
first_name = First name
last_name = Last name
password = Password (at least 6 characters) (Passwords will be encrypted!)
active = true for active, false for inactive

A record gets updated when the email address matches.