XLS (Excel) Exports

Question Summaries
Individual Responses

Exports

Paid feature

You can export your survey results as an XLS spreadsheet and open your survey results in Excel. See example exports »

To export your survey results:

Go to the Analyze results section of your survey.
Select Export from the top toolbar, and select New export.
Select an export type: Question summaries or Individual responses.
Choose XLS, select your export options, then select Export.
When your download is ready, a brief notification to Download appears to export the file to your computer. You can also find your files for 14 days by selecting Export at the top of the page and choosing Previous exports.

Question summaries

Question summaries exports organize survey results by question. Depending on the question type, the XLS export includes presentation-ready tables with:

The text of the question and answer options
The response count, percentage per answer choice if it was a drop down or multiple choice question, and a corresponding chart
The number of respondents who answered and the number who skipped the question

Make sure to select Open-ended responses when exporting to see answers from Comment boxes, Textboxes, or questions where Other was an answer option or comment field.

Individual responses

Individual responses exports organize survey results in a spreadsheet where each row contains the answers from a given respondent. The question type determines how the data is reported in the spreadsheet.

Standard vs. Condensed vs. Expanded Columns

This setting only affects questions with a single answer choice allowed.

When exporting responses, choose the column format that best fits your data analysis needs:

Standard Columns: A highly compatible, easy-to-use structure with 1 header row, standard values for the responses, and no filters.
Condensed Columns: An easy-to-use structure with more options to customize your export. By default, spreadsheet columns are condensed. This means that instead of listing each answer option in separate columns, only the answer the respondent chose is listed in the cell—all responses are listed in one column.
Expanded Columns: If you choose to expand columns, every possible answer choice for a given question is listed in its own column. If a respondent chose a particular answer option, it's written in the cell under the appropriate column. If a respondent did not choose a particular answer option, the cell under that column is blank.

Actual Answer Text vs. Numerical Value

By default, if a respondent chose a particular answer option, your actual answer text is used in the cell.

You can choose to have your answer choices converted to numerical values.

The values assigned to your answer choices correspond to the order in which they appear in your survey design. 1 is assigned to the first answer choice in the list, 2 is assigned to the second answer choice in the list, and so on.
If you added Other as an answer choice, it's assigned 0.
For Rating questions, we use the weighted value assigned in the survey design as the numerical value for each answer option.
You'll need to build your own key to see which answer choice belongs to which assigned number.
For imported SurveyMonkey Audience demographic info, the weights assigned correspond to the order of the answer options in your data tables.

Spreadsheet Organization

Each row in the spreadsheet contains the answer set from a given respondent, allowing you to do your own analysis per question.

Column	Definition
Respondent ID	The unique number associated with the respondent.
Collector ID	The unique number for the collector. Use the CollectorList file, also included in your export, to match this ID to a collector's title.
Start Date	Time stamp when the respondent accessed the survey.
End Date	Time stamp when the respondent submitted or last modified the survey.
IP Address	The respondent's IP address, if you used IP tracking.
Email Address	Available if you used the Email Invitation collector.
First Name	Available if you added this to the contact and used the Email Invitation or Text Message collectors.
Last Name	Available if you added this to the contact and used the Email Invitation or Text Message collectors.
Custom 1-6	Available if you added this to the contact and used the Email Invitation or Text Message collectors. A formatting note—you'll always see a column for custom 1. Columns for custom 2-6 aren't shown unless you're using them.
Question 1	The 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. Questions with multiple rows, columns, or fields of answer choices span across multiple columns in the spreadsheet with each row, column, or field in its own column.
Custom 7-50	Available if you added this to the contact and used the Email Invitation or Text Message collectors. Columns for custom 7-50 aren't shown unless you're using them.

TIP! Still need help with the spreadsheet? Read more about troubleshooting exports.

Get Quick Insights with Analyze with AI

Analyze Multiple Surveys Together

Thematic Analysis

SurveyMonkey