Bad Characters in your Exported csv/xls file?
Problem
You just exported a CSV/XLS file from Germain UX Workspace
but you are getting these bad characters instead?
Solution
That's an issue with your MSFT Excel, not Germain UX's export feature. The exported CSV file is encoded as UTF-8, so it can handle korean characters, but when you open the file on a Excel installation that defaults to Western (ANSI) settings, it will by default open it as a different character set.
Here's how you customize the encoding during import into Excel:
- In Excel, create a new blank worksheet
- Go to DATA > From Text (exact location may vary depending on your Excel version)
- Select your CSV export
- Select "delimited" and "UTF-8" encoding:
- Select "comma" delimited:
- Finish import - you should see valid characters (in this example, Korean characters):