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.
Import of customer records
Note: There is no need to import users, as email addresses are automatically stored on every email sent to your mailbox
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 (*),
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).
Custom Fields
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.
New address fields
Starting November 19th, 2024, you can import the address, zip, city, and country fields with a CSV import.
Import of Helpmonks users
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
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
Note: Columns should be written in lowercase!
Updating records
A record gets updated when the email address matches.
Last updated on Nov. 19th
Still need help?Contact us