Response Data Export Options

When you create a "Raw Response Data" export, the "customise" section has four sub-sections, as follows:


These contain overall content settings, controlled via on/off toggles.

  • Include respondent details: This is information such as ID, start and end date and time of response, IP address and name/email details from the contact list, if relevant.
  • Include contact list custom columns: Any data added as Custom Column data can be included or excluded.
  • Include Respondent Status: Adds a column to track respondent status to make it easier to determine whether non-partial respondents have been disqualified.
  • Include Text Analysis Categories: If any Text Analysis categories have been created for questions on the survey these will be included in the export. They categories for each question response will be listed in a single column after the column for that question. Multiple categories will be seperated in the column by a comma.


Sets how the exported data will appear in the export.

  • Split date and time: Separates the Date and Time elements of the "Start" and "Finish" data into seperate columns to aid processing.
  • Column headings in one row: Some question types (Such as matrix questions) will be reported with the question details across two rows. This option forces them onto a single row.
  • Column heading style: Sets the contents of the column headings. Question contents, question numbers, and question IDs can be chosen.
  • Answer choice style: Set whether the answer text, option number, or option scoring is used. Has no effect on free-text questions.

Using these options, it’s possible to export completely anonymised data sets for ensuring totally unbiased processing.


This lets you select from a few standardised filters for your export.

  • Select custom filter: Choose whether to apply a filter (defined in the filtering tool) to the responses that are exported.
  • Date range: Apply a smart date range filter, calculated from when the export is run. Ideal for daily, weekly, monthly, or other regular reports.
  • Partial responses only: Export only responses that are incomplete.
  • Response range: Export only responses between two defined responses, numbered based on order of response.


Other settings.

  • Custom file name: Create a custom file name for the export
  • Translation: (Only on multi-language Surveys) Choose a translation for the survey content to use in the export.
  • Empty cell value: Change the contents of any empty cells, such as for unanswered questions.
  • Mark Bypassed Questions: This toggle allows you to define a different cell value for questions that were not shown to the respondent, so you can distinguish between questions that were shown but not answered, and ones that the respondent did not see (usually because of Skip Logic).
    • Set the character to use by entering it in the "Bypassed Cell Value" box.

Was this guide helpful?