SAP Knowledge Base Article - Public

2676529 - Wrong amount format on CSV file - Employee Central


Customer exported the pay scale level, but the amount value have a diferent value between CSV file and system value.

Example:In the system the amount appears as "11.111,11" but in the excel file the values is coming as "11111.11"

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


Employee Central

Reproducing the Issue

Dowload the CSV file with amout and compare with the target employee under Employee Profile

  1. Go to Admin Center
  2. Go to Import and Export Data
  3. Choose the file that have amount information configured
  4. Download via Monitor Job
  5. Compare the values in the Excel file with the Employee Profile


  • CSV file format


  • Employee Profile



This is expected behavior since the CSV file use the commas to separate the collums in Excel file, and since the system just generate Excel Files this will be the standard behavior when the values comes with a comma.


Employee Central, CSV, Excel File, Comma , KBA , LOD-SF-EC-MDF , MDF & EC2MDF Migration , How To


SAP SuccessFactors HCM Core 1805