Response Data Export Options

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

Options 

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.

Appearance

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.

Filters

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.

Misc

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.

Was this guide helpful?