What if Chinese characters don't display correctly when I open a CSV report in Microsoft Excel?

Follow these steps to render multi-byte characters, including Chinese characters, in Microsoft Excel.

1. Open Microsoft Excel.
2. On the Data tab, in the Get External Data section on the left, click From Text.
3. Navigate to the saved report file, select it, and click Import.
4. In the Text Import Wizard dialog box, select the Delimited file type, and then from the File origin drop-down, select 65001: Unicode (UTF-8).

   

5. Click Next.
6. In the Delimiters section, select Comma.

   

7. Click Finish.

   The Import Data dialog box appears.

8. Click New Worksheet, and then click OK.
9. On the File tab, click Save As, and select a location for your file.
10. Enter a name for the report in File name, and from the Save as type drop-down, choose Excel Workbook (*.xlsx).

    

11. From the Tools drop-down, select Web Options.
12. Along the top, select the Encoding tab, and from the Save this document as drop-down, select Unicode (UTF-8).
13. Select Always save Web pages in the default encoding button, and then click OK and then Save.