Loading...
  • Customer Experience
    Customer Experience
  • Employee Experience
    Employee Experience
  • Brand Experience
    Brand Experience
  • Product Experience
    Product Experience
  • Core XM
    Core XM
  • Design XM
    Design XM

Exporting Response Data

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 Exporting Response Data

You can export (another word for “download”) all of your participants’ responses to all the questions in your survey. When you export data from Qualtrics, you can save data to your computer for analysis in another software, to share the file with a trusted colleague, or even to import back into another survey. Each row of the file is a different respondent, and each column is a question of the survey they answered, survey metadata (e.g. Recorded Date, IP Address, etc.), contact fields, and any embedded data you may have recorded for each respondent.

Attention: If the export option is missing in your account, it may be due to one of the following:

  1. If your Qualtrics account is through your university or organization, this permission may simply be disabled for your account. Please contact your brand administrator to get this permission enabled.
  2. If you have a free account, you are not allowed to export data, and will need to upgrade your account.

Exporting Response Data from a Survey

Qtip: If you have a filter applied to data, you will export only the filtered data.
  1. Make sure you are in the Data section of the Data & Analysis tab.
    Exporting the response data by clicking the Export & Import drop down menu
  2. Click Export & Import.
  3. Select Export Data.
  4. Select your desired file format. You have the following options:
    Download Data Table menu with format options and the Download button

    • CSV: A file format that can be opened as a spreadsheet in Excel. If you plan on importing this data back into a survey and your respondents primarily speak English, CSV is a compatible file format.
      Qtip: Note that if you choose a format other than CSV or TSV, the options presented in the next steps may vary.
    • TSV: A file format that can be opened in a text editor or as a spreadsheet in Excel. This file format works better than CSV when data contains special characters or the respondents speak in languages that do not use the English alphabet (or use more characters than the English alphabet, such as à, á, â, etc.). If you plan on importing this data back into a survey, TSV is a compatible file format.
    • Excel: Export the data to an XSLX format, which can be opened in Excel. This file format cannot be imported back into Qualtrics.
    • XML: A file format that can be opened as a spreadsheet in Excel. This format cannot be imported back into a survey.
    • SPSS: This file format is compatible with SPSS, one of the world’s leading statistical softwares, and a staple in many research labs and classrooms. Note that if you do not already have access to SPSS, you should not use this file format.
      Qtip: For more information about file formats and the differences between them, please visit the Export Formats page.
    • Google Drive: Export your data to a Google Sheet in Google Drive. For more information, read our page on Exporting Response Data to Google Drive.
    • User Submitted Files: If you included a File Upload or Signature question in your survey, you can use this option to download either the files users uploaded or the signatures they provided.
      Attention: We recommend that you keep the size of your exports under 1.8 GB.
  5. Select Download all fields if you would like to export all of the data you collected.
    Qtip: If this option is deselected, only columns currently displayed on the Data tab will export. See Choosing Columns on how to customize what’s displayed on your Data tab.
  6. Decide whether you’d like to download data in a quantifiable, numeric format (Use numeric values) or with the answer choices as written (Use choice text).
  7. Click More Options to see additional export options.
  8. Select as desired. For more information on each option, please visit the Export Options page.
    List of expanded options covered at the link. Download button in green bottom-right
  9. Click Download.

 

Available File Formats

Along top of the download data table window is a list of file formats

You can choose the file type of your downloaded data. The available file types include CSV, TSV, XML, SPSS, and more.

To learn about each of these file types and how they’re used, see the Data Export Formats support page.

More Export Options

Download Data Table window expanded, with attention to the lower-left more options and the resulting change

As you’re going through the steps to export your data, you’ll notice that you are asked if you would like to Download all fields, and whether you’d like your data in numeric values or choice text. You’ll also notice a lot of extra options will appear when you click More Options. These options determine whether you include line breaks in open-ended feedback, how you recode seen but unanswered questions, whether your export includes randomized data, and more.

To learn more about how each of these options works, see the Data Export Options support page.

Understanding Your Exported Data File

CSV of data

Once you export your data to a CSV or TSV, that file is organized into rows and columns. Each row is a different respondent, and each column is a question of the survey they answered,  survey metadata (e.g. Recorded Date, IP Address, etc.), contact fields, and any embedded data you may have recorded for each respondent. But what do each of these “metadata” mean? What do their values mean? What does question data look like?

To learn more, see the Understanding Your Data Set support page.

Manage Downloads

After clicking Download, the Manage Downloads window appears. The Manage Downloads window displays all of your requested downloads and their export progress. Each time you start an export, a new entry appears at the top of the list, detailing several pieces of information:

  • Status: Whether the export is In Progress, Failed, or is ready to Download.
  • Type: Which export file format was selected.
  • Percent Complete: How far along the export has progressed.
  • Last Updated: When the export status was last updated.

Manage Downloads menu with previous downloads available for re-download

Large datasets may take a long time to export, but you can leave the page and return later. You can even have multiple downloads running at the same time, starting one download and then immediately beginning another.

When exports are complete, the value of the Status column changes into a download button. The data file automatically downloads to your computer. Clicking on the button also downloads the file to your computer. You can download the file as many times as you would like.

If you leave export jobs in Manage Downloads, you can return at any point by clicking Export Data, Manage Previous Downloads, and download an earlier job. You can also delete an old job from the list by clicking the X to the far right of it.

Manage Previous Downloads in the Export & Import drop down menu

Data Export Security Measures

Qualtrics takes a few precautionary steps to protect you and your CSV/TSV files from any malicious scripts a respondent would try to type into a Text Entry response.

Your CSV/TSV export puts a single quote in front of any data field that starts with +, -, @, or =. For example, a text comment that says “@Qualtrics you’re the best!” would be exported as “@Qualtrics you’re the best!” Note the extra single quote before the @. This prevents Excel from automatically executing a malicious script.

However, if you predict this feature could interfere with any data retrieval scripts you run, have no fear. If Qualtrics knows that the field is a numeric field, it will not add the quote to the front of the data, even if it starts with a + or -.  Numeric fields are guaranteed to be safe, since the text required to create a malicious script would be rejected by the numeric validation.

The following fields are considered numeric:

FAQs