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.
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
Connect to app.crisp.chat
Go to the Contacts tab
On the upper right corner, click on import contact profiles.
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.
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)
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:
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?
❌ user.name
You need to avoid spaces and special chars, except _ and -
Then Create your custom key and assign the custom key.
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.
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
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 app.crisp.chat
Go to the Contacts tab
On the upper right corner, click on 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:
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?
❌ user.name
You need to avoid spaces and special chars, except _ and -
Then Create your custom key and assign the custom 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
Thank you!