Print this page

Non-Roman characters appear incorrectly in a CSV export of a Social Studio performance report

Knowledge Article Number 000193727
A performance report in Social Studio provides performance metrics for your social accounts in a specific workspace or across all workspaces in your Organization.
If non-Roman characters are appearing incorrectly when you export the performance metrics in a CSV export, convert the file origin to Unicode (UTF-8).

Convert to Unicode

1. Export your performance report from Social Studio.
2. Save the report to your computer.
2. Open Excel.
3. Import the Performance Report using Excel's Text Import Wizard.

In step 1 choose:
  • File type:  Delimited
  • File Origin:  65001: Unicode (UTF-8) 
In step 2 choose:
  • Delimiters: Comma
            4. Click Finish to complete the import using the Text Import Wizard.

The imported text in UTF-8 is inserted in the selected cell and displays non-Roman characters correctly. 

promote demote