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:
Summary Data exports organize survey results by question. Depending on question type, the XLS export includes presentation-ready tables with:
Make sure to select include open-ended responses when exporting to see answers from Comment Boxes, Textboxes, or questions where Other was an answer option or comment field.
Responses Data 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.
This setting only affects questions with a single answer choice allowed.
By default, spreadsheet columns are condensed. This means 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.
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.
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.
Each row in the spreadsheet contains the answer set from a given respondent, allowing you to do your own analysis per question.
|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.|