You can export all or selected responses in the following formats (all responses will be in the same file):
Or export selected responses in the following formats (each response will be its own file):
To export responses:
- Select the response icon .
- If you do not want to export all responses, select the responses you do want to export from the responses list or apply a filter that filters out responses you do not want to export.
- Click the Export Responses button in the upper left corner of the page.
- Select the file type you want to export in. PDF and DOCX will only be available if you have manually selected responses.
- If you have chosen CSV or SPSS, configure advanced options. See below for details.
- Click Download.
Click to see more detail:
|Excel Compatible (UTF–16, tab-separated)||Generates a file that is Excel compatible.|
|Split into files of 255 columns each (for old versions of Excel)||Splits export into files with no more than 255 columns to make your export compatible with very old versions of Excel.|
|Export scores instead of labels||Questions with custom score values export with scores instead of question labels.|
|Include row number for each response||Includes row numbers with responses to make data easier to read.|
|Include unique identifier for each response||Identifiers will show along with the questions.|
|Export questions on separate rows (for database import)||Puts questions in rows rather than columns.|
|Replace newlines characters with \n||Uses \n instead of [Enter] for newlines. Improves compatibility with certain spreadsheet programs.|
|Replace newline characters with spaces||Uses whitespace instead of [Enter] for newlines. Improves compatibility with certain spreadsheet programs.|
|Remove all HTML tags from exported answers||Removes HTML tags, making your file more human readable.|
|Truncate question headers||Minimizes the amount of text shown in your header|
|Include edit links||Provides a link to the response where you can view or edit answer choices.|
|Include a list of visited survey pages for a response||Includes a list of all pages visited while the respondent was taking the survey in a field called Page Path.|
|Show skipped / empty checkboxes||Checkbox questions that never appeared to the user are marked with a “dash”. Checkboxes questions that appeared but had no answers chosen are marked with a 0. Otherwise, a score appears.|
SPSS is an advanced statistical analytics program that can be used to perform further analysis on your collected data. Before exporting results into SPSS make sure that your questions have the appropriate identifiers and that your choices have the appropriate scores associated with them.
When exporting to SPSS, select Export to .SAV format to download as a single .SAV file. Otherwise a .txt and script.sps file will download.
If you download two files, you’ll need to make a slight modification to the “script.sps” file:
- Open it in an HTML compatible text editor (Notepad, for example).
- Locate the string that says /File=’responses.txt’.
- Change the ‘responses.txt” portion to reflect the actual location of the file. For example, if the file was downloaded to your Downloads folder, you’d change it to: /FILE=’C:UsersDownloadsresponses.txt’.
- Save the file once and the change will be made.
You’ll now be able to run your script.sps file by double-clicking on it. When you do, SPSS will open and you’ll see your script. Just click on the Run menu then click on “Run all”, and all of your response data will appear in SPSS.