Qualtrics: Exporting Data to Excel

Summary

Learn how to export Qualtrics data then import it into Excel.

Body

Log onto Qualtrics

  1. Open or Select an Internet Browser such as Microsoft Edge, Google Chrome, Mozilla Firefox, or Safari.
  2. Visit the Qualtrics: Online Survey Tool knowledge base article.
  3. Click Qualtrics Login.
  4. Select a survey > Click the survey name.
  5. Click Data & Analysis.
  6. Click Export & Import.
  7. Click Export Data…
  8. Click Excel.

    CSV:  A file format that can be opened as a spreadsheet in Excel. If you plan to import this data back into a survey and your respondents primarily speak English, CSV is a compatible file format.
    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 XLSX 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 software, 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.
    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.

  9. Select Use choice text.
  10. Click Download.
  11. Click DownloadIt will be downloaded onto your download folder on your computer.
  12. Double click on the document to open it.

Note: The name of your document differs from the one in the example.

Details

Details

Article ID: 139136
Created
Wed 4/13/22 11:42 AM
Modified
Thu 1/25/24 5:03 PM

Related Services / Offerings

Related Services / Offerings (1)

Qualtrics is a powerful online survey research tool, and it is available to all faculty, staff, and students at UT. Qualtrics meets IRB requirements for collecting and storing data including PII, FERPA, and HIPAA/PHI (it is encrypted in transit, at rest, and in backups).