SAP Knowledge Base Article - Public

2422566 - Table Report exported with CSV format is displaying wrong/special characters for translated fields, language-specific characters are not retained (e.g. Chinese)

Symptom

  • When a Table report is exported to CSV and opened with Microsoft Excel application, special characters are not being recognized or are not displayed correctly.
  • Table / Adhoc report not showing language translations correctly. E.g. Chinese characters, Japanese characters, etc. are not retained.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors HCM Suite

Reproducing the Issue

  1. Run an Ad Hoc or Table  report that contain special characters (~, Ç, ´, ^) or contains language-specific characters such as Chinese characters and export it to CSV (Download, Export or Run Offline).
  2. Open the exported file with Microsoft Excel.

special_caracter_ansi_new.jpg

Cause

  • Issue is not due to a limitation with Table or Adhoc framework, but with how Excel interprets CSV file based on the encoding value chosen. If the data is displayed correctly in the instance when running Online, e.g. complete Chinese or special characters are shown on screen in BizX, then it is not an issue with the translation either.
  • The file generated is in Unicode (UTF-8) but Microsoft Excel is trying to open the file as ANSI.  The output or content is displayed correctly when using applications where default encoding standard is set as UTF-8, e.g. Notepad++ and other applications, so this is a Microsoft Excel issue.

Resolution

UTF-8 was made as the standard format for CSV across all SuccessFactors applications.  If this is changed in SuccessFactors, it will affect processess, automations or integration that follow strict UTF-8 standards.

There are some possible solutions or workarounds for this:

  1. Run the report with XLS/XLSX output option if output file is intended to be open in Excel.
  2. Set the default encoding of Excel to UTF-8 by modifying the registry entry in end user's desktop. This will require
    admin authorization in user' desktop and should be done with caution.
    http://www.lukemiller.org/journal/2005/03/changing-default-text-import-origin.html
  3. Open a new Excel file and import data from CSV and change the encoding to UTF-8.  Detailed steps below:

a. Open Microsoft Excel with a blank spreadsheet

b. Select the tab DATA

c. Import from text

d. In the import wizard on the field "File Origin" select "65001 : Unicode (UTF-8)"

special_caracter_unicode_new.jpg

4. It is also possible to open the CSV file with Notepad++, which will retain the e.g. Chinese characters.

Keywords

Special ,characters, CSV, Export, ad, hoc, report, incorrect, information, export, chinese characters, japanese characters, table report, table export, adhoc export , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To

Product

SAP SuccessFactors HXM Suite all versions ; SAP SuccessFactors Workforce Analytics all versions