Skip to main content

Exporting Qualtrics Data that Contains Special Characters: Getting Started

On an international campus, Qualtrics surveys may frequently contain special characters like Chinese hanzi. Unfortunately, when downloading Qualtrics data as a .CSV file, the encoding can be lost and the characters may not display correctly.

Exporting Data with Special Characters

 

In the "Data & Analysis" tab,

Screenshot of the Qualtrics toolbar with "Data & Analysis" highlighted.

select "Export & Import", then "Export Data…"

Screenshot of the Export & Import toolbar

You will be presented with the following screen. Although the default selection is "CSV" (short for "Comma Separated Values"), this file format uses UTF-8 encoding which is insufficient to display Chinese characters. Instead, you can use TSV, ("Tab-Separated Values"), which uses UTF-16 encoding and will display Chinese characters correctly. Simply select TSV and hit "Download".

Screenshot of the Qualtrics "Download Data Table" window

You have now downloaded your TSV file, which should correctly encode special characters like Chinese hanzi, for use in your preferred data analysis program.

Importing TSV files into Excel

Although some data analysis programs can open TSV files directly, Microsoft Excel requires an intermediary step.

To open the .TSV data in Excel, first open Excel, then go to File --> Open --> Browse:

Screenshot of Excel Open File Screen

Navigate to where your .TSV file is located, and then be sure that in the bottom-right dropdown, "All Files" is selected instead of the default "All Excel Files".

Filetype dropdown showing "All Files" highlighted

Select your .TSV file and click "Open".

You will be presented with an import pop-up.

Text Import Wizard Step 1

Be sure that you select "Delimited" under the Original Data Type section, then hit "Next".

On the next page, ensure that "Tab" is selected as your only delimiter (remember, that's the "T" in "TSV"), then hit "Next".

Text Import Wizard Step 2

On the next window, there are several formatting options. You can select each column in the Data Preview pane and then select a different format in the Column data format section.

"General" is the default, and is okay in many circumstances. But some areas in which to be careful are ensuring that dates are selected to be in the proper format, and that numerical strings that should not be treated as numbers, for example Coordinates, Phone Numbers, ISBNs, etc are selected to be "text", otherwise they risk being converted to decimal or scientific notation, which can wreak havoc in some situations.

Text Import Wizard Step 3

When you are done, click "Finish" and your data should be properly displayed.

 

Your Librarian