Chinese support: How can I view downloaded Chinese results in Excel?
Some versions of Microsoft Excel do not display all Chinese characters properly, causing problems when opening CSV files of results downloaded from Chinese-language polls.
This issue is known to affect:
- Excel 2010 for Windows
- Excel 2011 for Mac
Here are two easy workarounds for this issue.
Using Google Docs:
If you already have a Google account (for example, a Gmail address), you can easily use Google Drive's Sheets functionality to make your downloaded .CSV file readable by Excel.
- While signed in to your Google account, go to drive.google.com.
- Click New in the left sidebar, then choose File Upload.
- Select the CSV file you downloaded from your Chinese-language Textizen poll.
- Once the file is imported, find it in your Google Drive, and double-click it to open a preview.
- Click "Open" above the page preview to open it as a Google Spreadsheet. In this Google Sheet, you should see all the Chinese data correctly.
- On the Google Sheets page, go to File -> Download as -> Microsoft Excel (.xlsx).
- The new downloaded file will now display correctly in Excel.
Using Numbers for Mac:
If you are a Mac user and own a copy of Apple's spreadsheet application Numbers, you can use it to view and convert the Chinese CSV file as well.
- Open Numbers.
- Go to the File menu and select Open. Locate the CSV file you downloaded from your Chinese-language Textizen poll.
- The file should open and display all Chinese characters correctly.
- Go to the File menu again, select Export, and choose Excel (.xls or .xlsx) format.
- The exported file should display correctly in Excel.