Bulk import customer's list and Helpmonks users record

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 (*),
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

Note: Columns should be written in lowercase!

Updating records

A record gets updated when the email address matches. 



Help us improve our documentation. Did this article help?
Last updated on Nov. 19th
Still need help?Contact us
 
What can we do for you?
Found an issue or need an answer? Let us know here. We'll be happy to reply.