Use the 'Numbers' application instead of Excel. Excel will display your CSV file - including non-English characters - properly.

In the dialog window that appears - click 'OK' button.In 'File origin' field - select '65001 : Unicode (UTF-8)'.Unfortunately, Im not able to find the same option in the new import wizard (Power Query). In the previous Excel versions, there was the possibility to convert them during the import wizard. Excel will display 'Text Import Wizard'. The problem is that numbers are written with comma decimal separator, but my PC is working with dots as decimal separator.Select the CSV you file you saved from Accompa. On a Windows computer, click 'File > New' in Excel.That's all! Open this new CSV file using Excel - your non-English characters should be displayed properly.In the dialog window that appears - select 'ANSI' from the 'Encoding' field.On a Windows computer, open the CSV file using Notepad.To resolve this issue, please do the following after saving the CSV file from Accompa. Microsoft Excel is unable to properly display UTF-8 compliant CSV files when they contain non-English characters.However, you may run into an issue when your CSV file also contains non-English characters (such as é, ç, ü, etc): If you use Microsoft Excel to open the CSV files, everything works fine when the file contains just English characters.

We do this to ensure that it works well for our customers using different operating systems and different software packages to process these CSV files, and to ensure that the processed CSV files can be imported back into Accompa. Home > Miscellaneous Questions > How can I get Excel to properly display accented c.Īccompa creates CSV files that are compliant with the UTF-8 standard. How can I get Excel to properly display accented characters in the CSV file saved from Accompa?

Excel text import wizard save settings