Checkbox Survey lets survey editors deploy any survey in multiple languages, including those that do not use traditional ASCII characters. TheUTF‐8 encoding option is used to export results that include non‐ASCII characters, but Microsoft Excel does not always recognize that the exported results file contains encoded data. This guide will show you how to import your results so that they can be read by Excel.
To view a UTF‐8 encoded CSV file in Microsoft Excel, you can follow the steps below. It may seem like a lengthy process, but once you work through it a couple times, it will only take a few seconds.
1. Choose which survey results to export
From the survey dashboard or survey editor, click Analyze -> Responses -> Export Responses.
2. Choose your export options
From the export pop-up, choose to export your file as a Standard CSV file, choose your CSV options (as needed), and select the UTF8 Output Encoding.
3. Download your file
Once the export is complete (as evidenced by the green progress bar), click the Download button and make note of where your computer saves the downloaded file.
4. Open Excel and import Data -> From Text
Open a new Excel workbook and choose the From Text icon in the Data menu. Find the .csv file that you saved in the previous step and select it to import.
5. Choose your data type
On the first step of the wizard, choose to import Delimited text with a File Origin of UTF-8.
6. Choose your text delimiters
On the second step of the wizard, make sure only the Comma delimiter is selected and that the text qualifier is set to the double quotation mark (“).
7. Import your data into Excel
On the final step, choose the location in Excel where your data should be imported. You should now see your survey results with proper character encoding. To preserve this format, you can now save the file as an Excel spreadsheet, which you will be able to open directly without the data import process.