Non-ASCII characters like ä, ü, ó, ż, ę or others, Cyrillic letters, Japanese letters etc. are not displayed in usage reports.
Microsoft Excel does not correctly recognize non-ASCII characters in CSV files.
The issue has been fixed in version 7.7.
- Open Microsot Excel.
- Choose Data -> From text.
- Select the report CSV file
- Specify the following:
- Data format – with separators
- File format – “65001: Unicode (UTF-8)” or the local coding (such as 932: Japanese (Shift-JIS) for example).
You will see the preview so you will be able to check if the encoding actually fits your needs.
- Click Next.
- Make sure to check the “comma” as a separator symbol, otherwise, the table will split the data incorrectly.
- Confirm the selection.
- Choose to place the data to a new or an existing page and click OK.
This changes the CSV encoding and all the necessary symbols appear as intended.