Skip to main content
Skip table of contents

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:

    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):



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.