Fixing corrupted Thai Language

When exporting a .csv file, there may be issues with the display of the Thai language.

ตัวอย่างไฟล์ Gradebook ที่ export ออกมาแล้วชื่อ Quiz เป็นภาษาต่างดาว

Solution

Open Excel, and go to the tab Data -> From Text.

Choose the .csv file you wish to correct, and select '65001 Unicode (UTF-8)' from the File Origin options. After that, click 'Load'.

Thai language will display correctly.

This method is intended only for editing or viewing within the file. Importing a file that has been modified using this method may result in an incorrect format or failure in data mapping.