Export your responses
About exporting responses
An export downloads your responses as a file: to analyze them in Excel, SPSS, R or Stata, to share them, or to keep a copy. You choose the file format, which responses to include and how questions and answers are written. Exporting does not change or remove your responses.
Export your responses
Click Results in the top bar of the editor.
Click Export results at the top right. The page Export results opens.
Choose the file format under Export format (1).
Under Completion state (2), choose All responses, Completed responses only or Incomplete responses only.
Check the other options. The defaults suit most exports.
Click Export (7). Your browser downloads the file.
Close takes you back to the responses list.
Tip: Export your responses before you deactivate a survey or correct answers. You keep a copy of the original data.
Choose the file format
| Format | Use it for |
|---|---|
| CSV | Any spreadsheet or statistics tool. Set the CSV field separator to Comma, Semicolon or Tab. |
| Microsoft Excel | Excel. |
| SPSS (.sav) | SPSS. |
| R (syntax file) and R (data file) | R. Export both, save them in the same folder and run the syntax file in R. |
| STATA (.xml) | Stata. |
| JSON | Other software. |
| PDF, HTML and Microsoft Word | Reading or printing the answers. |
The other options
- Export language: in a multilingual survey, the language of the question and answer texts.
- Range (3): the response IDs to export, from and to. By default all responses.
- Export responses as (4): Full answers, the answer texts such as Phone, or Answer codes, the codes you set for the answers, which statistics tools prefer. Tick Convert Y to or Convert N to to replace the codes Y and N with another value, 1 and 2 by default. Quote equations for CSV export is on, so answers that look like spreadsheet formulas stay plain text.
- Export questions as (5): Question code, Abbreviated question text, Full question text (default) or Question code & question text. Strip HTML code removes formatting from the question texts. The other switches replace spaces with underscores, shorten texts to the Number of characters, or use ExpressionScript codes.
- Select columns (6): all columns are selected. To export only some, click the first one and Ctrl-click the others (Cmd-click on a Mac). If Save timings was on, the timing columns are in this list too.
- Participant control: in a survey with a participant list and without anonymized responses, add participant fields such as First name, Last name and Email address to each response.
Export one response
In Results, click Responses list in the left panel.
Click ... in the row of the response and then View/edit response details.
Click Export response. The page Export results - Single response opens with the same options, without Range.
Choose the format and click Export.
Next steps
- Statistics: see the answers as charts
- Timing statistics: how long respondents take
- View, filter and edit responses
FAQ
Excel shows all answers in one column. What went wrong?
Your Excel expects a different separator than the one in the CSV file. Export again with Microsoft Excel as the format, or set CSV field separator to Semicolon.
The export has fewer responses than Results shows. Why?
Check Completion state and Range. Completed responses only leaves out incomplete responses, and Range limits the export to the response IDs you entered.
How do I export the questions without the responses?
Export the survey structure from the ... menu of the editor, under Tools > Export. See Export a Survey.