# Fixing corrupted Thai Language

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

<figure><img src="https://content.gitbook.com/content/XHLtFtw2BeIo9EXwQ4kE/blobs/nzj58CD1CRlzpnl50KZC/image.png" alt=""><figcaption><p>ตัวอย่างไฟล์ Gradebook ที่ export ออกมาแล้วชื่อ Quiz เป็นภาษาต่างดาว</p></figcaption></figure>

## Solution

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

<figure><img src="https://content.gitbook.com/content/XHLtFtw2BeIo9EXwQ4kE/blobs/0XCVScItUaqiOZhmnDof/image.png" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://content.gitbook.com/content/XHLtFtw2BeIo9EXwQ4kE/blobs/FYdFTjWBaBWqNxJeL6y7/image.png" alt=""><figcaption></figcaption></figure>

Thai language will display correctly.

<figure><img src="https://content.gitbook.com/content/XHLtFtw2BeIo9EXwQ4kE/blobs/fhLnizBjsI0nTU4aXuKs/image.png" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
**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.**
{% endhint %}