SAP Knowledge Base Article - Public

2967812 - CSV records in separate columns when exporting from Integration Center


When exporting a CSV file from SuccessFactors via Integration Center, the records are in 2 separate column.

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


SAP SuccessFactors HCM Suite

  • Integration Center (IC)


This is not an error from Integration Center, this is an expected behavior from Excel and it occurs due to a semicolon (;) in the field value.


To export the CSV file correctly, go to the Options tab:

  • Output File Type: Simple Delimited;
  • File Delimiter: Semicolon (;);
  • Header Type: Your choice;
  • Footer Type: Your choice;
  • Use Double Quotes - Enable

The output file should be exported as the following image:

See Also

Integration Center (IC) Guide:


Integration Center, Outbound Integration, CSV, Excel, Semicolon (;), Separate Columns , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , How To


SAP SuccessFactors HXM Suite all versions


Pasted image.png