SAP Knowledge Base Article - Public

2609670 - Adhoc CSV exports: Chinese characters display in unreadable format

Symptom

When exporting information in Chinese in Adhoc or the Online Report designer, the output is unreadable.

Environment

SuccessFactors BizX
SuccessFactors Analytics

Cause

Chinese characters are not compatible with CSV when exported directly.

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

Resolution

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

    fromdata.png

  3. Under "File Origin" select UNICODE (UTF-8) > Finish > OK

Keywords

Adhoc, Adhoc report export, Chinese export, CSV , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , How To

Product

SAP SuccessFactors HCM Core all versions ; SAP SuccessFactors Workforce Analytics all versions