Data Export Formats
About Export Formats
Among your export options, you can choose the file type of your downloaded data. The available file types are:
-
- CSV (Comma Separated Values)
- TSV (Tab Separated Values)
- Excel
- XML (Extensible Markup Language)
- SPSS (Statistical Analysis Package)
- Google Drive (Exports as a Google Sheet)
- Tableau (Extension with Tableau)
Warning: This export format is available only if you have the Tableau Extension enabled for your account.
- JSON (Javascript Object Notation) & Open Data Protocol
Warning: This export format is available only with the API Extension.
You can also export User Submitted Files, or files respondents have uploaded through the File Upload question type.
CSV
CSV is a text file type that can be opened in Microsoft Excel, a convenient program for viewing data. From Excel, a CSV file can be converted and viewed in other statistical modeling software.
CSV and TSV are compatible file formats for importing response data and contacts to Qualtrics. See the Troubleshooting CSV/TSV Upload Issues support page if you are having trouble importing with these file types.
TSV
A TSV file is a simple text format for storing data in a tabular structure.
Each record in the table is 1 line of the text file and columns are separated (delimited) by a tab. TSV is an alternative to the comma separated values (CSV) format and can be opened by Text Editors (such as Notepad) and spreadsheet programs (such as Excel).
CSV and TSV are compatible file formats for importing response data and contacts to Qualtrics.
Excel
When you choose to export in Excel format, you will export your data to an XLSX file.
Although CSV, TSV, and XML are all compatible with Excel, the default document format in Excel is generally XLSX. XLSX exports can support customization in Excel such as sheets, highlights, column filtering, and other advanced changes that the other available file types cannot.
XML
XML is a general-purpose markup language that defines a set of rules for encoding documents. Files in XML format are readable by both computers and machines and are commonly used for putting your raw data into a database. It is also compatible with Excel.
SPSS
SPSS is a software package used for statistical analysis. SPSS files download in SAV format.
If you’re having difficulty with international characters in your file and you’re using SPSS version 16 or later, you can try changing the Character Encoding for Data and Syntax setting to Unicode.
To change the Character Encoding for Data and Syntax
- Close any open datasets.
- Go to the SPSS Edit menu and select Options.
- In the general tab under Character Encoding for Data and Syntax, choose Unicode.
- Click OK.
Qualtrics encodes international characters using the unicode UTF-8 character set. Unfortunately, old versions of SPSS (SPSS Version 15 and earlier) do not support unicode. You may want to consider upgrading to a newer version of SPSS.
SPSS Syntax Files & Corresponding Data Files
2 additional file formats are available in the More Options for SPSS exports: SPSS Syntax File and Corresponding Data. The syntax file and corresponding data can be used to build the SPSS file after download. However, please note that prior SPSS knowledge is needed to do this. Qualtrics Support is unable to help with SPSS file parsing.
If you are looking for a simple SPSS file, we recommend downloading the standard SPSS file format.
Google Drive
The Google Drive export option allows you to export your data as a Google Sheet to Google Drive. To use this feature, you must have a Google account to link to your Qualtrics account. For more information about linking your account and exporting your data, read our page on Exporting Response Data to Google Drive.
User Submitted Files
If you used the File Upload question type in your survey, you can use the User Submitted Files option to download all respondent-uploaded files at once. They will download to your computer in a .zip file and will include the original file names and the response ID for each response submitted.
Tableau
Tableau is a data analysis application used by many organizations. Qualtrics currently offers an extension with this application that allows you to send Qualtrics data directly to Tableau. For more information visit our Tableau extension page.
JSON & Open Data Protocol
JSON (Javascript Object Notation) and Open Data Protocol exports are only available through our API Extension. See our Create Response Export documentation for exporting a file in JSON format.
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:
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.