Attendee report in CSV file is showing unreadable symbols, how to display the correct characters in the file?

Keiko So

February 08, 2021 04:13
Updated

When trying to open a CSV from exporting attendee list 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.

Step 1: Open Excel, select “DATA” tab then choose “From text” option under “Get External Data”

Screenshot_2021-02-08_at_11.50.17_AM.png

Step 2:Open the CSV file and the Text Import Wizard (image below) will pop up. Select “Unicode (UTF-8). Notice the preview will change to readable characters.

Screenshot_2021-02-08_at_11.52.31_AM.png

Step 3: In Step 2, select “comma”. Notice now each item is separated in each cell instead of lumped together.

Screenshot_2021-02-08_at_11.53.01_AM.png

Step 4: Click finish and it’s all done.

Screenshot_2021-02-08_at_11.53.29_AM.png

Step 5: All characters can display correctly in the excel file.

Screenshot_2021-02-08_at_11.53.55_AM.png

Step 1: Open Excel, select “DATA” tab then choose “From text” option under “Get External Data”

Step 2:Open the CSV file and the Text Import Wizard (image below) will pop up. Select “Unicode (UTF-8). Notice the preview will change to readable characters.

Step 3: In Step 2, select “comma”. Notice now each item is separated in each cell instead of lumped together.

Step 4: Click finish and it’s all done.

Step 5: All characters can display correctly in the excel file.

Related articles