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)
- 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.
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 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.
A TSV file is a simple text format for storing data in a tabular structure.
Each record in the table is one 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.
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 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 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
Two 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.
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 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.