CSV report looks corrupted on Microsoft™ Excel not supporting UTF8
You run a report asking to save the result in a CSV file. When you open the CSV file using Microsoft™ Excel, the content of the file looks corrupted.
Cause and solution:
To bypass this problem, make sure that the version of Microsoft™ Excel you are using supports
the UTF8 character set. If it does not, install a more recent version
that supports UTF8. Then, follow these steps to correctly open CSV
reports from Microsoft™ Excel:
- Open Microsoft™ Excel.
- In the Data menu entry, select Import External Data and then Import Data.
- Select the CSV file saved and click Open.
- In the field File Origin, select UTF8.