Support Center > Knowledge Base> Article: Viewing Exported CSV files containing Arabic characters

Viewing Exported CSV files containing Arabic characters

Article ID: 45188 Email Print
Question
When i export analytics data, specifically Contact list reports, i am unable to view arabic characters

Answer

Excel is not capable to process UTF-8 characters correctly when CSV is opened directly in Excel.

The solution is to use data import:

  1. Save the exported file as a csv
  2. Open Excel
  3. Import the data using Data-->Import External Data --> Import Data
  4. Select the file type of "csv" and browse to your file
  5. In the import wizard change the File_Origin to "65001 UTF" (or choose correct language character identifier)
  6. Change the Delimiter to comma
  7. Select where to import to and Finish

 

 


Related articles

Article Details
Views: 45569 Created on: May 27, 2014
Date updated: Sep 13, 2014
Posted in: Troubleshooting
Tagged: Export


Poor Outstanding