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”
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.