Articles on: My Contacts

How to import my user data?

If you want to use existing data from your own database or import data from a previous provider, Crisp offers import options for your contacts

Crisp uses CSV as a data import option.

1. Retrieve your data

As Crisp uses CSV to import your data, you need to gather your data in a CSV file.

No matter how the data is formatted. Crisp will allow you to map the data to the Crisp format

2. Go to the Crisp Contacts Tab

Connect to
Go to the Contacts tab
On the upper right corner, click on import contact profiles.

Click import contact profiles

3. Upload the CSV and Map the Data

If your CSV doesn't have a header (the first row with variables names such as email, name, IP, company), check the option "Skip header"

Also, please ensure your CSV separator is correct. By default, Crisp is using a comma.

Required data and data formats:

Email is required
First name and Last name (or Full name) are strongly recommended. While you can import a list with only emails, this means your contacts names will be extracted from the email addresses.
Segments must be separated by a pipe (|), a comma (,) or a space () separator.
Country must be a country code, not a country name (e.g. US for United States).
City must be the full city name.
Dates (Creation date and Last Active date) can be either a string in ISO 8601 format (e.g. 2020-08-14T14:09:10-02:00), or a UNIX timestamp (seconds or milliseconds) (e.g. 1694070416 or 1694070416000)

4. Add custom data

Crisp provides predefined attributes like the Email, Username, Segments, Company information, etc.

It's also possible to use your own data in Crisp, such as a user ID, or internal variables.

By default, Crisp auto-detects the columns that correspond to custom data. If a column is named data.my_key, then it will be automatically added as a custom data named my_key.

In addition to the auto-detection, you can also manually map custom data.
First, click on that button:
Click create a custom data key

Then you need to fill your custom data key. Here are some valid examples:

✅ user_id
✅ lifetime_value
✅ ltv
✅ AppVersionCode

Here are some invalid examples

❌ Company Name
❌ $ltv
❌ is_subscribed?

You need to avoid spaces and special chars, except _ and -

Then Create your custom key and assign the custom key.

Finally, assign your custom data key

5. Proceed

Your data import might take time. If you are importing hundreds of profiles, it should be live in a few seconds.

If you are importing 20,000+ profiles, it might take a few minutes. Just make a coffee then

We recommend doing an initial import of 1-2 contacts first, as a test. This is to make sure that all your data is mapped how you expect, and that you didn't forget to map a column.

Importing existing contacts

If you import a profile a second time (i.e. a profile with the same email address already exists), it will behave as such:
existing custom data with new values will be updated (to explicitly delete an existing custom data, leave its value empty)
new custom data will be added to existing ones
new segments will be added to existing ones (it's not possible to explicitly delete segments)
employment information will be merged
company information will be merged
any other information (nickname, avatar, etc.) will be overwritten

Updated on: 07/09/2023

Was this article helpful?

Share your feedback


Thank you!