When opening the data export characters might be missing or weird looking. This is caused by Excel's lack of support for CSV files encoded with UTF-8.
To fix this:
Open Excel
Import the data using Data > Import External Data > Import Data (or From Text option)
Select the file type of “csv” and browse to file
In the import wizard change the File Origin to “65001 Unicode (UTF 8)” (or choose correct language character identifier)
Optionally, change the delimiter to semicolon
Select Load / Transform data