Purpose
When trying to open a CSV with Asian (Japanese, Chinese, Korean etc) words, the characters are replaced with unreadable symbols in opened up excel files. Follow these steps to open the export in Excel to correctly display the Asian characters.


Steps
Example for MAC  
Please do following steps to open exported CSV file contains Asian (Japanese, Chinese, Korean etc) words with corruption.
  1. Open a new, blank Excel workbook.
  2. In the Data tab, click From Text.
  3. Select the .csv file and click Import
  4. In the Text Import Wizard pop-up window, under Original Data Type, select Delimited as " and Separated as ,(Comma)
  5. In the Text Import Wizard pop-up window, under File origin, select UTF-8. It may be called 65001: Unicode (UTF-8).
  6. In the Text Import Wizard pop-up window, click Next.
  7. In the Text Import Wizard pop-up window, check the box next to Comma, and then click Next.
  8. In the Text Import Wizard pop-up window, click Finish.
  9. In the Import Data pop-up window, click OK.


You may need to resize your columns once the data is imported, but the language will display properly.

Note: The steps listed above may appear slightly different depending on which version of Microsoft Excel you are using.


Example for Microsoft office 2021

  1. Open a new, blank Excel workbook.
  2. In the Data tab, click From Text.
  3. Select the .csv file and click Import
  4. In the Text Import Wizard pop-up window, 

a) File Original: 65001: Unicode (UTF-8)

b) Delimiter: (Comma)

c) Data type detection: (Based on first 200 rowsComma) 

  1. In the Text Import Wizard pop-up window, click Load.
  2. Data displayed in CHINESE successfully.

 

You may need to resize your columns once the data is imported, but the language will display properly.

Note: The steps listed above may appear slightly different depending on which version of Microsoft Excel you are using.

 

Screenshot for Step (2) 

 

Screenshot for Step (4) 

 

Screenshot for Step (6)