XLS (Excel) Exports

XLS (Excel) Exports

Survey results can be exported as an XLS spreadsheet and can be opened in Excel. View example exports >> 

To export your survey results in excel:

  1. Go to the Analyze Results tab.
  2. Locate the Export section on the left sidebar.
  3. Choose from the following export types:
    • Question Summaries with Charts
    • Question as Single Column
    • Respondent as Single Row
  4. Exported files are ready to be downloaded from the Data Exported window.

Spreadsheet Organization

A set of answers from a given respondent is included in each row in the spreadsheet, allowing you to do your own analysis per question.

Column ItemDescription
Respondent IDThe unique number assigned to each survey respondent.
Collector NameName of the collector you used in the survey.
Start DateDate and time when the respondent accessed the survey.
End DateDate and time when the respondent submitted or last modified the survey.
Time SpentThe difference between the Started and Last Modified times.
IP AddressThe IP address of the respondent will be available is you turned on IP Address tracking.
Completeness StatusView responses based on their completeness status, partial, completed and etc.
Email AddressAvailable if you used the Email Invitation Collector.
First NameAvailable if you added this to the contact and used the Email Invitation Collector.
Last NameAvailable if you added this to the contact and used the Email Invitation Collector.
Question 1The first question of your survey. Blank cells are answer options the respondent didn’t select or questions the respondent didn’t answer or skipped due to logic in your survey design.