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:
- Save the exported file as a csv
- Open Excel
- Import the data using Data-->Import External Data --> Import Data
- Select the file type of "csv" and browse to your file
- In the import wizard change the File_Origin to "65001 UTF" (or choose correct language character identifier)
- Change the Delimiter to comma
- Select where to import to and Finish