Breadcrumbs

Bad Characters in your Exported csv/xls file?

Problem

You just exported a CSV/XLS file from Germain UX Workspace
image2024-10-11_9-57-39.png


but you are getting these bad characters instead?

image2024-10-11_9-53-26.png

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:

    1. In Excel, create a new blank worksheet

    2. Go to DATA > From Text (exact location may vary depending on your Excel version)
      image

    3. Select your CSV export

    4. Select "delimited" and "UTF-8" encoding:
      image

    5. Select "comma" delimited:
      image

    6. Finish import - you should see valid characters (in this example, Korean characters):
      image2024-10-11_10-1-15.png