About Importing Responses
You can use the Import Responses setting in the Responses page of your survey to combine responses from two identical surveys, re-upload edited data, or bring in your own data into a survey. You can view your imported responses in your Reports.
Responses are imported using CSV files.
Prepare Your Survey
Before importing, you’ll first need a survey to import your data to. The survey’s format and the CSV file format must match exactly. You can easily achieve this by using one of the following options:
- Use the survey you downloaded the responses from.
- Create a copy of the survey you downloaded the responses from.
- Use a survey identical to the one that collected the responses you are importing.
Prepare Your File
The best and easiest way to prepare your CSV file is to download your survey's response data to CSV format and fill it out with the responses you want to import.
Your CSV file should be UTF-8 encoded.
You are not able to import email addresses to the email system variable. However, you create create your own background variable and match it to that.
The way your format your data depends on the question or variable type you're importing the data into. Read more about how to format every question and variable type below.
- The data to be uploaded into Multiple or Image Choice questions with single selection need to be formatted as follows:
- There should be one column for the question.
- Each respondent's row must include the label number of the response option they selected. For example, the number "1" means that the respondent selected the first response option in the question.
- If the question allows a text entry for the final option, you need to add an extra column for the open answers.
The number in the file represents the response option label number and not the value.
- The data to be uploaded into Multiple or Image Choice questions with multiple selection need to be formatted as follows:
- Each response option needs to have its own column.
- Each column and row must have a value of 0 or 1, where “1” signifies that the response option was selected by the respondent.
- If the question allows a text entry for the final option, you need to add an extra column for the open answers.
- The data to be uploaded into Rating Scale questions with needs to be formatted as follows:
- There should be one column for the question.
- Each respondent's row must include the selected scale number. For example, if the question has a 1-5 scale, the number "2" means that the respondent selected 2 in the 5-point scale.
- If the question allows for open answers, you need to add an extra column for them.
The number in the file represents the response option label number and not the value.
- The data to be uploaded into Open Answers questions needs to be formatted as follows:
- There should be one column for the question.
- Each respondent's row can include the submitted text answers.
Open Answer questions are limited to 4000 characters.
- The data to be uploaded into Matrix Multiple Choice questions needs to be formatted as follows:
- Each sub-question needs to have its own column.
- Each column and row must include the label number of the response option they selected. For example, the number "1" means that the respondent selected the first response option in the question.
The number in the file represents the response option label number and not the value.
- The data to be uploaded into Matrix Rating Scale questions needs to be formatted as follows:
- Each sub-question needs to have its own column.
- Each column and row must include the value of the selected scale number. For example, if the question has a 1-5 scale, the number "2" means that the respondent selected 2 in the 5-point scale.
- The data to be uploaded into Input Field questions or Text background variables need to be formatted as follows:
- There should be one column for the question/variable.
- Each column and row must include the response. The format of the response depends on the question's validation: text, numeric, email or custom values.
- The data to be uploaded into Net Promoter Score® or Recommendation Score questions need to be formatted as follows:
- There should be one column for the question.
- Each column and row must include the value of the selected scale number. For example, if the question has a 1-5 scale, the number "2" means that the respondent selected 2 in the 5-point scale.
- If the question allows for open answers, you need to add an extra column for them.
- The data to be uploaded into Selection List variables needs to be formatted as follows:
- There should be one column for the variable.
- Each column and row must include the selection list response option in text format.
The text data must match the Selection List response options exactly or else the response won't be imported.
- The data to be uploaded into Date background variables needs to be formatted as follows:
- There should be one column for the variable.
- Each column and row must include the date input.
- The format for date variables is MM-DD-YYYY.
Image & File Upload, Ranking, and Point Distribution questions are not supported.
Import Responses
Once your survey and CSV file are ready, you can import responses. You have to:
- Go to your survey and select responses on the side menu. If the menu is closed, click on the menu icon (
) to open it first.
- Click on respondents to open the dropdown menu and select imported responses.
- Click on the import responses icon (
).
- Upload your UTF-8 encoded CSV file.
- Map the fields in the CSV file to the survey questions and variables.
If there is a field that you don't want to upload or import, you can skip it.
- Once you're done mapping, click next.
- Review the number of responses ready to be imported and click done to finish the import.
- To view the individual response, all you have to do is click on it.
Imported responses are not included in the same list as collected responses.