SAP Knowledge Base Article - Public

2591681 - Chinese characters not being displayed properly when exported via .CSV - Ad Hoc Reporting


  • A report with Chinese characters do not display properly when exported via (.CSV) and shows random HTML tags
  • Report works properly when exported via (.XLS)


SAP Success Factors Workforce Analytics (ANA) - All versions


The CSV file already contains the correct characters, the issue is it is not being displayed properly by Microsoft Excel.

Instead of opening the CSV file directly in Excel, follow these steps:

  1. Open a blank Excel workbook
  2. Go to Data > From Text > select the CSV file > Import
  3. Under "File Origin" select UNICODE (UTF-8) > Finish > OK

See Also

2253933 - How to remove HTML tags from Performance Management v11 Ad Hoc reports.


Ad Hoc Reporting, CSV, Chinese characters, HTML tags, incorrect chinese characters , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , How To


SAP SuccessFactors HCM Core 1711