Exporting your Responses
Help Center

FluidSurveys Help > Creating Reports & Managing Responses > Responses

Exporting your Responses

You can export all or selected responses in the following formats (all responses will be in the same file):

  • CSV
  • XML
  • SPSS

Or export selected responses in the following formats (each response will be its own file):

  • PDF
  • DOCX

To export responses:

  1. Select the response icon response icon.
  2. 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.
  3. Click the Export Responses button in the upper left corner of the page.
  4. Select the file type you want to export in. PDF and DOCX will only be available if you have manually selected responses.
  5. If you have chosen CSV or SPSS, configure advanced options. See below for details.
  6. Click Download.
VIDEO: Exporting Survey Responses
VIDEO: How to Export Individual Responses
VIDEO: Advanced Export Options for Responses

Click to see more detail:

Advanced Options for CSV Export
Advanced OptionsDescription
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 labelsQuestions with custom score values export with scores instead of question labels.
Include row number for each responseIncludes row numbers with responses to make data easier to read.
Include unique identifier for each responseIdentifiers 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 \nUses \n instead of [Enter] for newlines. Improves compatibility with certain spreadsheet programs.
Replace newline characters with spacesUses whitespace instead of [Enter] for newlines. Improves compatibility with certain spreadsheet programs.
Remove all HTML tags from exported answersRemoves HTML tags, making your file more human readable.
Truncate question headersMinimizes the amount of text shown in your header
Include edit linksProvides a link to the response where you can view or edit answer choices.
Include a list of visited survey pages for a responseIncludes a list of all pages visited while the respondent was taking the survey in a field called Page Path.
Show skipped / empty checkboxesCheckbox 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 (SAV) Export
VIDEO: Exporting to SPSS

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:

  1. Open it in an HTML compatible text editor (Notepad, for example).
  2. Locate the string that says /File=’responses.txt’.
  3. 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’.
  4. 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.