Why language characters are not displaying correctly in CSV export for optimizations?

Our system generates the file correctly, but Excel is not showing the language character properly. This happens because Excel is not able to recognize the characters of the language. A common reason for this is when the language in the CSV file is not the one you use in Excel. For example, you usually view files in English, and the CSV is in German. The file will open correctly in notepad (or another text editor), and the characters will display properly. 

There are two ways to view the file correctly in Excel.

  1. Import the file in Excel as a CSV and set the File Origin to Unicode (UTF-8). You can do it by following the steps below:
    • Go to 'File' in Excel and select the option to 'Import' a file
    • Choose to import the file in CSV format
    • Select the file from where it's stored in your system
    • A window will open up with an option to change the File Origin. Select Unicode (UTF-8) from the drop down
    • Click Finish
  2. Install the Excel language pack for the specific language. More details here.

Can’t find what you’re looking for?

Our award-winning customer care team is here for you.