Skip to main content
  • Customer Experience
    Customer Experience
  • Employee Experience
    Employee Experience
  • Brand Experience
    Brand Experience
  • Product Experience
    Product Experience
  • Core XM
    Core XM
  • Design XM
    Design XM

Data Export Options

What's on This Page:

Was this helpful?

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The feedback you submit here is used only to help improve this page.

That’s great! Thank you for your feedback!

Thank you for your feedback!

About Export Options

In addition to choosing the file format of your data export, there are various options for customizing your data output. You can review and change your data output each time a file is downloaded by using the various export options.

Qtip: This page focuses on the many export options available for exported data files. For instructions on exporting the data, please visit the Exporting Response Data page.

Export Options when using Download Data Table

Options 3-10 are accessed by clicking the More Options button at the bottom-left of the Download Data Table window.

  1. Download all fields: With this option checked, all possible columns of data are exported. With this option unchecked, only currently displayed columns in the Data & Analysis tab are exported.
  2. Use numeric values/choice text:
    • Use numeric values: Instead of exporting the text of the answer choice, the Recode Value for the answer choice exports.
      Qtip: If you only have answer choices 1-5 and you see much larger numbers in your exported data, you may need to go back and check your Recode Values. When you add and remove answer choices, your Recode Values may become out of order. You will be able to change these coded values after you have collected your data without invalidating your results. Visit the Recode Values page to learn more.
    • Use choice text: The data is output as full answer choice text.
      Qtip: If the text that exports looks different from what you set in the survey editor, chances are you have set Variable Names or Question Labels. Visit the links to learn how to edit these or remove them. If you want to shorten the column names and answer text that exports in your data, we encourage you to use Question Labels or Variable Names.
  3. Compress data as .zip file: The data is combined into a compressed .zip file in order to reduce the overall file size.
  4. Use commas for decimals: All decimal characters in the data output are replaced by commas.
  5. Remove line breaks: In a Text Entry question type, respondents can use line breaks to separate paragraphs. This option removes those breaks, and turns the text response into one solid block of text.
  6. Recode seen but unanswered questions as -99: By default, questions that participants chose not to answer are left blank in the survey data. When this option is enabled, any questions that participants saw and chose not to answer are coded as a value of -99 (or any other number you specify by clicking on the number and editing it) in order to distinguish them from questions participants didn’t see.
  7. Recode seen but unanswered multi-value fields as 0: This option is similar to “Recode seen but unanswered questions as -99” and can only be enabled if that option is also selected. Additionally, your exported data will only show this option if “Split multi-value fields into columns” is also selected because multi-value fields must be in their own column in order to display the value as 0 (or any other number you specify by clicking on the number and editing it), this identifies answer choices which were shown to a respondent but were unanswered.
  8. Export viewing order data for randomized surveys: When this option is enabled, columns are added to your dataset for each randomized element in your survey. These columns contain information on the order in which your randomized blocks, questions, or answer choices were displayed to the individual respondent.
  9. Split multi-value fields into columns: Certain question types allow for multiple answer choices to be selected for a single question. This option splits each possible answer to the question into a unique column, rather than combining every chosen answer into a single column.
  10. Use internal IDs in header: With this option unchecked, question column headers display the editable question number (e.g., Q4). With this option checked, the question column headers display the internal IDs (which cannot be edited) as assigned by Qualtrics.