Viewing Exported CSV files containing Arabic characters

When i export analytics data, specifically Contact list reports, i am unable to view arabic characters

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