When export a report to CSV, special characters are not being recognized.
SAP SuccessFactors Adhoc Reporting
Reproducing the Issue
- Run an Ad Hoc report that contain special characters (~, Ç, ´, ^) and export to CSV.
- Open the exported file with Microsoft Excel.
The file is in Unicode (UTF-8) and the Microsoft is trying to open the file as ANSI.
- Open Microsoft Excel with a blank spreadsheet
- Select the tab DATA
- Import from text
- In the import wizard on the field "File Origin" select "65001 : Unicode (UTF-8)"
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