Download your raw data by going to the Download Data page (View Results tab) and selecting the file type that you would like to download. The available file types are .CSV, SPSS, Fixed Field Text, XML, and HTML. You can save and open the file on your computer, except HTML, which will just open a table in your browser.
Internet Explorer may prevent the download, displaying a yellow bar at the top of the page. Click this bar to give the browser permission to download the file. The page may reload, in which case you will need to re-click the download option.
.CSV (Comma Separated Values)
- A text file type that can be opened in Microsoft Excel. Excel is a convenient program for viewing data. From an Excel file, a .CSV file can be converted and viewed in other statistical modeling software.
- Excel 2003 has a column limit of 256 columns. Some surveys may have more variables than this. The data will be stored in the .csv file, but cannot be displayed in Excel 2003. If this is the case, you will need to find another program to view the data (SPSS, SAS, STATA, Excel 2007).
- To download an SPSS file, navigate to the SPSS section and click Download SPSS .sav File.
- If desired, you can specify the string width or download the SPSS Syntax file.
Fixed Field Text
Fixed Field Text format is designed to work with many external cross tabulation tools. It is a flat file format and is the one most often used for these tools. This was designed to better meet the special needs of our market research clients.
XML is used for putting your data into a database. This is the Extensible Markup Language (XML) format of the raw data, which is a general purpose markup language for easy interpretation.
The HyperText Markup Language (HTML) format shows the data in one large table when you open it with a web browser.
If you used the File Upload question type in your survey, use this option to download all respondent-uploaded files at once in a .zip file.
Troubleshooting Download ErrorsIf the downloaded .CSV file is not displaying cleanly in Excel, you will want to use the Text Import Wizard (you can also try using Text to Columns, found under the Data menu, which is very similar to what is described below…). Follow the instructions below:
- Download the .CSV file.
- Open Excel.
- Open a new file.
- Click the Data menu option.
- Click “From Text” button.
- In Excel 2003…
- Click “Data” menu.
- Select “Import External Data.”
- Select “Import Data.”
- In Excel 2003…
- Select the file you downloaded.
- In Text Import Wizard, select”Delimited” and Press Next.
- Check the delimiter characters that you know are in your file.
- A file from Qualtrics should be using commas.
- You can try other delimiters if selecting Comma doesn’t help it display correctly.
- Proceed to Next Step and Finish.
- Your Excel file will be ready with your data displayed correctly.
Having problems with international characters?
- With SPSS Version 16 or later:
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.” Press the “OK” button.
- With SPSS Version 15 or earlier:
Qualtrics encodes international characters using the unicode UTF-8 character set. Unfortunately, old versions of SPSS do not support unicode. You may want to consider upgrading to a newer version of SPSS.