Downloaded CSV files of the reports show irregular/junk characters for few non English languages.
Article ID: 163454
Updated On:
Products
Issue/Introduction
If you download CSV files from the report section and open in excel then it may not display the data as displayed
in the console and may not be understable due to the junk characters.
For e.g. If you download a report 'Size of content on server' from the report section and you have content tittles
in Thai language then characters look like as below:
| Content | Version | File size |
| à¸à¸²à¸£à¸—ดสà¸à¸š | 50.91 KB | |
| à¸à¸²à¸£à¸—ดสà¸à¸š ส่วนที่ 2 | 86.78 KB | |
No Error Message
Cause
The issue is a limitation within Excel as it by default does not handle utf-8 characters correctly within csv files.
Resolution
1) Download the report using the "Download CSV" button, don't open it via Excel and save the file to your drive.
2) Open Excel
3) Click on the "Data" menu bar option at the top.
4) Click on the "From Text" icon
5) Navigate to the location of the file saved in step 1, and click on the "Import" button.
6) In the Text Import Wizard
In step#1 select the following:
>Original data type = Delimited
>File origin = 65001 : Unicode (UTF8)
>My data has headers = Checked
>In step#2 select the following:
Delimiters = Comma
>In step#3 click "Finish" and then click OK.
Feedback
