Data Export Options

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.

Export Options when using Download Data Table

Options 3-12 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.
11. Exclude survey response edits: When this option is enabled, edits made to survey responses will not show up in your dataset.
12. Include download links for user-uploaded files: This option adds a column to your dataset for every file upload question in your survey. This column contains links that allow you to view and download user-uploaded files.

Exporting Data in Different Project Types

You can export response data in many different types of projects. The steps and options described on this page apply to the following project types:

• Survey projects
• XM Solutions

There are a few other types of projects where you can export response data. However, there are important differences to keep in mind:

• For Imported Data projects, see Data & Analysis in Imported Data Projects.
• For 360 projects, see Exporting Response Data (360).
• For all other Employee Experience projects, see Exporting Response Data (EX).
• For Conjoint, see Exporting Raw Conjoint Data.
• For MaxDiff see Exporting Raw MaxDiff Data.

FAQs