Limitations on CSV Exports of Data with Special Characters
If you export data in a language other than English to a CSV and open it in Excel, some special characters may not show correctly.
Exported CSV files are plain text and don't include any BOM (byte order marker) for encoding information. These files use UTF-8 encoding, but without a BOM, Excel uses a different encoding, so special (non-ASCII) characters may not show correctly.
This doesn't happen when you open an exported XLS file in Excel, or when you open a CSV in Notepad or another text editor.
To avoid this issue:
-
Export your data to Excel instead of CSV.
-
Open the file in Excel.
-
Save the file as a CSV if you want.
Note that Excel adds a BOM character to the start of the CSV file.