Import External Data Into New Survey

Can I import External Data?

Go To:

  • Login »  Surveys »  Integration Tools »  Import Data

1. Screenshot

Survey Software Help Image

Do I need to create the survey for importing data?

No. When you import data, a new survey is created automatically. All questions and answers are also created as per the imported file format.

Can I edit the survey once I have imported data?

Yes. You can edit the survey, change the text for questions and answers. However, we recommend that you don't make any structural changes. If you make structural changes the data may get affected.

I have imported data. I need to upload more responses/data to the same survey.

Every time you import data a new survey is created and the data is imported in the new survey. Data cannot be imported in to an existing survey even if the survey was created importing data in the same format. Please maintain the data file that you used to import data offline. To add more responses please add data to the same file and import the data again. A new survey will be created that will have the entire data.

What should be the data format?

Data can be imported from an excel (.xls) file format. First eight columns are reserved for system variables. Actual survey questions start from the 9th column (I) onwards.

First Column (A): External Reference Variable column (Optional)

Second Column (B): Weight column (Optional)

Third Column (C): Email Address (Optional)

Fourth Column (D): Custom Variable 1 (Optional)

Fifth Column (E): Custom Variable 2 (Optional)

Sixth Column (F): Custom Variable 3 (Optional)

Seventh Column (G): Custom Variable 4 (Optional)

Eigth Column (H): Custom Variable 5 (Optional)

Ninth Column (I): Question Type | Text (Required) - Actual Questions start from the ninth column onwards.

2. Screenshot

Survey Software Help Image

Data for responses should start from the 3rd row in the Excel file.

Question type / data tags.

When uploading data our survey engine needs to recognize the question/data type. For this purpose the file should be in a particular format and question types need to be tagged with definite codes.

Multiple Choice (Single Select)

${UNICHOICE} Question Text

3. Screenshot

Survey Software Help Image

Multiple Choice (Multiple Select)

${MULTICHOICE} Question Text

4. Screenshot

Survey Software Help Image

Open Ended Text

${TEXT} Question Text

5. Screenshot

Survey Software Help Image

Matrix Table - Multi Point Scales

${MATRIX_UNICHOICE} Question Text

6. Screenshot

Survey Software Help Image

Matrix Table - Check Box / Multi-Select

${MATRIX_MULTICHOICE} Question Text

7. Screenshot

Survey Software Help Image

Ready to start listening to your customers? FREE TRIAL