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 is using CSV as data import option.
1. Retrieve your data
As Crisp is using CSV to import your data, you need to gather your data in a CSV file.
No matters 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 is not having 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 required. You can't import a list with only emails.
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) must follow the ISO 8601 format (e.g. 2020-08-14T14:09:10-02:00)
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 take a coffee then
We recommend doing a first import of 1-2 contacts first, as a test. This is to make sure that all your data is mapped as you want to, 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 exist), 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 is using CSV as data import option.
1. Retrieve your data
As Crisp is using CSV to import your data, you need to gather your data in a CSV file.
No matters 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 is not having 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 required. You can't import a list with only emails.
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) must follow the ISO 8601 format (e.g. 2020-08-14T14:09:10-02:00)
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 take a coffee then
We recommend doing a first import of 1-2 contacts first, as a test. This is to make sure that all your data is mapped as you want to, 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 exist), 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: 15 / 12 / 2021