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:
- Open a blank Excel workbook
- Go to Data > From Text > select the CSV file > Import
- 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