Special characters in accented words in CSV reports
Failure
When downloading and opening reports in CSV format in Excel, words with accents are replaced by symbols or special characters.
Cause
This failure occurs due to an incompatibility in the character encoding between the CSV file and Excel. Excel may not correctly recognize the UTF-8 encoding of the file, resulting in the incorrect display of accented characters.
Solution
To correct this fault, follow the steps below:
Locate the downloaded CSV file on your computer
Right-click on the file
Click Open with
Click Notepad
In notepad, click File in the top menu
Click on Save as
In the save window, change the Encoding to ANSI
Click the Save button
If prompted to replace the file, click Yes
After following these steps, open the file again in Excel. The accented characters will be displayed correctly.
The steps described were carried out in Windows 11.
Related pages
{{component-feedback-article}}