How can I get Excel to properly display accented characters in the
CSV file saved from Waysact?
CSV files that are compliant with the
UTF-8 standard. We do this to ensure that it works well for our customers using different operating systems and different software packages to process these
If you use Microsoft Excel to open the
CSV files, everything works fine when the file contains just English characters. However, you may run into an issue when your CSV file also contains non-English characters (such as é, ç, ü, etc):
Microsoft Excel is unable to properly display
CSV files when they contain non-English characters.
To resolve this issue, please do the following after exporting the
CSV file from Waysact.
- On a Windows computer, open the
CSVfile using Notepad.
- Click "File > Save As".
- In the dialog window that appears - select "ANSI" from the "Encoding" field. Then click "Save".
- That's all! Open this new
CSVfile using Excel - your non-English characters should be displayed properly.
- On a Windows computer, click "File > New" in Excel.
- Click "Data" tab.
- Then click "From Text" option. Select the CSV you file you exported from Waysact.
- 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.
- Excel will display your CSV file - including non-English characters - properly.
You should use either the "Numbers" application, or the free LibreOffice, instead of Excel.