Adhoc Report exported as CSV file with Excel Special characters not displaying correctly.
SuccessFactors HCM Core
Adhoc / ORD Online Report Designer
Reproducing the Issue
- Run adhoc report (with field containing with special character) online or offline
- Export file as csv.
- Open the file with Excel
- Result display wrong character. E.g. "Operateur de production" is displayed "OpÃ©rateur de Production"
Excel limitation when opening csv file
Export the file as Excel XLS or XLSX
Or open the CSV file with Notepad ++
KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem