search cancel

Downloaded CSV files of the reports show irregular/junk characters for few non English languages.

book

Article ID: 163454

calendar_today

Updated On:

Products

Mobility Suite

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.