> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.screeb.app/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Import Survey & Responses from CSV

You are just starting on Screeb, but want to migrate your surveys, users and responses from your previous Survey tool ? We got you covered!

With the Survey Import Feature, you can import surveys from almost any data source with a CSV file.

# How to do ?

### ${color}[#5b7083](Step 0 - Get your CSV file)

First thing to do is preparing your CSV file for the import.

Screeb will interpret the CSV columns as **Survey data**, and each row as **Survey responses** with the values for each column.

[![](https://storage.crisp.chat/users/helpdesk/website/-/6/2/b/3/62b392188f473000/2b96bc30-3743-48b2-a1cf-a28c16_1paqogv.png)](https://downloads.intercomcdn.com/i/o/f9ft79uz/1634071238/0721bae34e317bd08b7544d8b523/image.png?expires=1767194100&signature=8e579642baf3980da349a40d57d45dac1ec57ab12d37bb4da016c33f5fc8da93&req=dSYkEsl5nINcUfMW1HO4zSHuq0lXO5YPlQpEaKXjyfkbiGWcsoF%2BCmwtGRQv%0AwjbrgTgjtT2yuKdW4rM%3D%0A)

You CSV file must have at least these columns:

* A column representing the **user Identity** (can be a unique id, an email, etc..).

* Empty cell for this column will result in a non imported response.
* At least one column representing a **Question**

* Supported question types are: NPS, CES, CSAT, NES, Open Input, Range, Scoring, Single Choice and Multiple Choice.

Others columns can be used as user properties that will be assigned to imported responses.

---

### ${color}[#5b7083](Step 1 - Import the CSV File)

From your Workspace lateral menu, go to the Survey list page.

[![](https://storage.crisp.chat/users/helpdesk/website/-/5/f/f/4/5ff4f94e76d61000/ab0fbe4a-98d0-4f30-8808-e1a5ca_9d121j.png)](https://downloads.intercomcdn.com/i/o/f9ft79uz/1634045874/5625e29d1625ffbf64fae356fff6/image.png?expires=1767194100&signature=2db371b906f42c756140aa0d1fc8323ee27cbe80f4277a7a02916d8e09369628&req=dSYkEsl6mIlYXfMW1HO4zdLRppQBPnavKu%2Bt0WO%2FxJmD8bgGZht6H9CmiTnL%0AJOWe85mn5FZzLVIrkL0%3D%0A)

At the top right side of the Survey List page, you will fin the **Import Survey** button.

[![](https://storage.crisp.chat/users/helpdesk/website/-/4/e/6/1/4e61d7c5daccf400/9e8a2330-6696-4c99-a18c-a8b10b_1wsolnz.png)](https://downloads.intercomcdn.com/i/o/f9ft79uz/1634048153/46020fdd819ef7b1ef7b64e12123/image.png?expires=1767194100&signature=5285b00fd661ed35411533bd2c56b0f6643df60a2492af9490842ec3687d96fd&req=dSYkEsl6lYBaWvMW1HO4zeRD6eCwACXipcBM0%2FQhpc0sSFuXAAHr9NadNnEP%0AIlozAKIWo9cAV5Hjmsw%3D%0A)

A modal will open, asking you to choose the source of the import. Choose "**CSV Import**"

[![](https://storage.crisp.chat/users/helpdesk/website/-/5/e/3/1/5e31ed2b776b0800/bb1b31e5-800b-46b7-95de-efecd2_bup3vh.png)](https://downloads.intercomcdn.com/i/o/f9ft79uz/1634050519/bff4e3fb4d0b02773bae9e265b4f/image.png?expires=1767194100&signature=9dc2d06201c5d69e9280ca74da8e68b61ff7a8efd648a0222bdc2da909325fd3&req=dSYkEsl7nYReUPMW1HO4zVvEkwA1O8%2Bv7UgCqEGt2v000UDksbuU1AqpTWT5%0ALaQhUwfUwsos0ggWees%3D%0A)

You are now on the CSV Import page, from where you can start the import process.

Load the CSV file using the Import Button.

[![](https://storage.crisp.chat/users/helpdesk/website/-/2/1/f/e/21fec72cc9c80200/7d252914-69bf-481c-ac26-e457e7_qugp0b.png)](https://downloads.intercomcdn.com/i/o/f9ft79uz/1632872782/f00a181b26b0ada7d9a9f095ee6a/image.png?expires=1767194100&signature=fb2ec8c7e088e0f1e3876fabe5def06ca861949b6e66ad59ad99b60d0a286ee9&req=dSYkFMF5n4ZXW%2FMW1HO4zbfktRWla4bKdWJFZSnnxzkNurPKIk70aoCgq9LN%0A6gdZDjhuHw2XeYiAmh8%3D%0A)

Once the file is imported, this step will be validated, and the next one will be unlocked.

---

### ${color}[#5b7083](Step 2 - Map the CSV columns to Screeb data types)

Screeb will extract the column name from your CSV file and try to guess the data type based on the values in the first few rows.

Screeb data types can be categorised in 3 section:

* **Identity**: There is only one data type called **User ID** in this category. This type is mandatory
* **Survey Questions**: The columns representing survey responses must be mapped to one of the corresponding Question type available.

* Supported question types are: NPS, CES, CSAT, NES, Open Input, Range, Scoring, Single Choice and Multiple Choice.
* **User Properties**: Any other column that you want to import can be mapped as user properties to add context for each responses imported.

* A user Property must be of a primary type: String, Number, Boolean or Date.

To validate this step, you need to map:

* Exactly one **User ID** column
* At Least one **Survey Question** Column

[![](https://storage.crisp.chat/users/helpdesk/website/-/4/4/3/6/4436814f33ccb800/2d00380d-fb3a-415b-8c1f-3013f7_1fmjcyy.png)](https://downloads.intercomcdn.com/i/o/f9ft79uz/1633982198/87a8cb65276899d9281070977b02/image.png?expires=1767194100&signature=2c6a7bd6ff11a9e31d9c22a79e9e3238d36e5abb3b4104f650ec36ca6150cb9a&req=dSYkFcB2n4BWUfMW1HO4zSDX%2FNYgT1MWGF1ZGg5%2F01XBDzhRTqAeP%2FTEV3Wf%0AeIM9S8UD1KD%2FeC5Tc4Y%3D%0A)

---

### ${color}[#5b7083](Step 3 - Map Questions order)

Now that your CSV file data have been mapped to Screeb data types, it is now time to setup the survey scenario.

💡The Survey Scenario is representing the order of questions to display to users.

You will find a list containing all the columns mapped as question. You can arrange their order to match what you want, from top to bottom.

[![](https://storage.crisp.chat/users/helpdesk/website/-/b/7/f/a/b7fa2a677e3a2000/af79cca2-caae-4ec6-b58a-828640_354tq1.png)](https://downloads.intercomcdn.com/i/o/f9ft79uz/1633987770/4c4f82bddc99f26b6f3508f07b9f/image.png?expires=1767194100&signature=df719c2cfb7c871b5fbfcfa2a9cdc0b99b6b74bf191532c7b4ecb0e2b59df794&req=dSYkFcB2moZYWfMW1HO4zXcH3rkReOoVZFLap58XwBjqqMUmCAsX5gz8WPrh%0AYGjTS%2BG%2FGIqKBl%2BKUSI%3D%0A)

---

### ${color}[#5b7083](Step 4 - Import Survey & Responses)

You are almost done!

Last thing to do is choosing a name for your survey. A name as already been suggested based on the CSV file name, but you are free to change it.

Additionally, you can choose to disable the response import, in case you just want to import the Survey.

[![](https://downloads.intercomcdn.com/i/o/f9ft79uz/1633990856/218f177858abaa7aa9f6f87af099/image.png?expires=1767194100&signature=8ac8097ff1909c060614037312a04bb378177279181d4cd5b1354e3c46aa7fee&req=dSYkFcB3nYlaX%2FMW1HO4zcHNN7Nhe%2BQ9zGsYy0s76IAZAMCGH1sn3VTItGNT%0AFSW%2FhDygnFS4yjTaWg4%3D%0A)](https://downloads.intercomcdn.com/i/o/f9ft79uz/1633990856/218f177858abaa7aa9f6f87af099/image.png?expires=1767194100&signature=8ac8097ff1909c060614037312a04bb378177279181d4cd5b1354e3c46aa7fee&req=dSYkFcB3nYlaX%2FMW1HO4zcHNN7Nhe%2BQ9zGsYy0s76IAZAMCGH1sn3VTItGNT%0AFSW%2FhDygnFS4yjTaWg4%3D%0A)

Once done, press the **Import Survey & Responses** button.

A modal will open, indicating the status of progress of the import.

👉 The import can take some time depending the amount of response you have to import. We import responses per batch of 1000.

As an example: 1000 responses take approximately 30 seconds to be imported.

[![](https://downloads.intercomcdn.com/i/o/f9ft79uz/1633994337/02212243894bcd33bb193cc3e5f8/image.png?expires=1767194100&signature=8dc389be02191fa791e9567acc10d79f9df40c28fb566b021acb50eda5184306&req=dSYkFcB3mYJcXvMW1HO4zfZ6OTykPteqj9OnbMpJSwNHKZPhU34TahwdxvrT%0AOGEJrzSmVvTCIXpkeZg%3D%0A)](https://downloads.intercomcdn.com/i/o/f9ft79uz/1633994337/02212243894bcd33bb193cc3e5f8/image.png?expires=1767194100&signature=8dc389be02191fa791e9567acc10d79f9df40c28fb566b021acb50eda5184306&req=dSYkFcB3mYJcXvMW1HO4zfZ6OTykPteqj9OnbMpJSwNHKZPhU34TahwdxvrT%0AOGEJrzSmVvTCIXpkeZg%3D%0A)

When the import is complete, the **Done** button in the modal should show up. Click on it to close the modal and end the process.

⚠️ Do not refresh the page or close tab during the import process.

This will cause a complete stop and reset of the import configuration.

As a result, the survey will be created and imported responses will be visible, but remaining responses will not be taken into account.

Creating a new import with the same parameter will result in the creation of a new survey with new responses.