Information submitted through the support site is private but is not hosted within your secure CDD Vault. Please do not include sensitive intellectual property in your support requests.

CSV import in Excel with "garbled" characters

You are opening a csv file in Microsoft Excel and are seeing incorrect, or garbled characters, such a  é, ü, Å, etc. 

This could be due to the CSV file being of the so called UTF-8 compliance standard. CDD uses this to ensure maximum compatibility over multiple platforms and software. However, if a CSV file contains non-English characters, this can lead to display issues within Microsoft Excel. Excel is unable to properly display UTF-8 compliant CSV files when they contain said non-English characters. 

To resolve this issue, please do the following after exporting a CSV file from CDD:

On a Windows machine:

  • On a Windows computer, click "File > New" in Excel.
  • Click "Data" tab.
  • For older versions of Excel:
    • Click "From Text" option. Select the CSV you file want to import.
    • Excel will display "Text Import Wizard".
    • In step-1 of this wizard:
      • Select "Delimited" radiobutton.
      • In "File origin" field - select "65001 : Unicode (UTF-8)".
    • Click "Next >" button.
    • In step-2 of this wizard:
      • Select "Comma" checkbox.
    • Click "Finish" button.
    • In the dialog window that appears - click "OK" button.
  • For newer Versions of Excel:
    • Click "From Text/CSV" option. Select the CSV you file want to import.
    • In the next box  select:
      • In "File origin" field - select "65001 : Unicode (UTF-8)".
    • Click "Load" button.
  • Excel will display your CSV file - including non-English characters - properly.

On a Mac:

If you are using Excel 2016 or later, then above Method 2 will work also on Mac. Otherwise you might want to consider using e.g. the "Numbers" application instead of Excel.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.