2422566 - Special characters in a csv file - Adhoc

SAP Knowledge Base Article - Public

2422566 - Special characters in a csv file - Adhoc

Symptom

When export a report to CSV, special characters are not being recognized.

Environment

SAP SuccessFactors Adhoc Reporting

Reproducing the Issue

  1. Run an Ad Hoc report that contain special characters (~, Ç, ´, ^) and export to CSV.
  2. Open the exported file with Microsoft Excel.

special_caracter_ansi.png

 

 

Cause

The file is in Unicode (UTF-8) and the Microsoft is trying to open the file as ANSI.

Resolution

  1. Open Microsoft Excel with a blank spreadsheet
  2. Select the tab DATA
  3. Import from text
  4. In the import wizard on the field "File Origin" select "65001 : Unicode (UTF-8)"

special_caracter_unicode.png

Keywords

Special characters - CSV - Export - ad hoc report - incorrect information on csv - Incorrect export to csv , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , How To

Product

SAP SuccessFactors HCM Suite all versions