- CSV (Comma Separated Values)
- SPSS (Statistical Analysis Package)
- XML (Extensible Markup Language)
- HTML (Hypertext Markup Language)
- Fixed Field Text (Plain Text)
- Tableau (Integration with Tableau)
- OData (Open Data Protocol)
You can also export User Submitted Files, or files respondents have uploaded through the File Upload question type.
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.
When using Excel to open your CSV, there are some potential issues to consider:
- Incorrect delimiters: If the downloaded CSV file is not displaying correctly in Excel, you can try using the Text Import Wizard (see below) to change the delimiter options (you can also try using Text to Columns, found under the Data menu of Excel).
- Special characters: If you data contains special characters, you’ll need to follow a few extra steps before opening your file in Excel in order for those characters to display correctly.
The below sections outline suggested steps for overcoming these potential issues.
To use the Text Import Wizard
- Download the CSV file.
- Open Excel.
- Open a new file.
- Go to the Data menu.
- Click From Text (sometimes represented by an arrow and the word “Text”).
Qtip: In Excel 2003, go to Data > Import External Data > Import Data.
- Choose the CSV file you downloaded.
- In Text Import Wizard, select Delimited and click Next.
- Choose the delimiter characters that you know are in your file (note that a file from Qualtrics should be using commas, though you can try other delimiters if selecting Comma doesn’t help it display correctly).
- Click Next and then Finish.
To correctly view special characters in Excel
- Download your CSV file from Qualtrics.
- Create a new spreadsheet in Google Sheets.
- Open your CSV file in Google Sheets.
- Copy and paste your data set from Google Sheets into 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.
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.
HTML format is used to view your data in one large table on web browsers. The file is still downloaded to your computer, but you view it in a browser.
Fixed Field Format
Fixed Field Format is a TXT file type designed to work with many external cross tabulation tools. It is a flat file format and is accompanied by a separate data map file that specifies data offsets for various columns.
Tableau is a data analysis application used by many organizations. Qualtrics currently offers an integration with this application that allows you to send Qualtrics data directly to Tableau. For more information visit our Tableau integration page.
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.