UTF-8 encoded data corrupted in CSV exports
When exporting from PHPMyAdmin as CSV, Excel usually doesn’t know how to deal with the special characters, resulting in corrupted data.
In order to avoid this, we use the following method:
- Open a new Excel book
- On the “Data” tab, click on the “From Text” button:
- Locate your CSV file and click on “Import”
- In the dialog box, select the appropriate encoding (i.e. UTF-8) from the dropdown list:
- Next, select the delimiter for the CSV (i.e. comma):
- Then click on Finish (you will be asked where to insert the data – normally [A1] is the place to put it).
- Now the data is correctly displayed in Excel:
