SAP Knowledge Base Article - Public

3808703 - RBP Group Change Audit Report: CSV file columns appear misaligned or show a large string when opened via Excel Import

Symptom

  • The RBP Group Change Audit Report exported as a CSV file cannot be correctly parsed via Excel import.
  • Column data does not align with the report headers, and a very large string appears across multiple columns, preventing the data from being mapped correctly to the expected fields. 
  • The same CSV file opens and displays correctly when opened directly (e.g., by double-clicking) or viewed in a plain text editor.

Environment

SAP SuccessFactors HCM Suite

Reproducing the Issue

  1. Generate and export the RBP Group Change Audit Report as CSV.
  2. Create a new Excel workbook

  3. Go to Data → Get Data (Power Query) → From Text/CSV

  4. Select the CSV file and choose Comma as the delimiter

Resolution

The RBP Group Change Audit Report is exported as a standard CSV file. The Change Audit report download feature does not provide special support for Excel's "Import from CSV" functionality or any third-party tool's CSV import behavior.

The CSV file can be correctly opened and read by:

  • Double-clicking the file directly to open it in Excel or any other spreadsheet application.
  • Opening it in a plain text editor (e.g., Notepad, VS Code).

From a product standpoint, direct opening via Excel or a text editor is the supported and sufficient method for accessing the exported data.

If the file appears misaligned, the recommended action is to open the CSV file directly rather than using Excel's import wizard or File → Open dialog. Misalignment caused by third-party tool import behavior is outside the scope of the SuccessFactors Change Audit Report feature.

See Also

KBA 3772421 - Long field content may be truncated in Change Audit reports

Keywords

RBP Group Change Audit Report, CSV, misaligned columns, Excel import, column headers, Change Audit, LOD-SF-PLT-CHA, SAP SuccessFactors Platform, audit export, CSV open, direct open, third-party tool, INC32494396 , KBA , LOD-SF-PLT-CHA , Change Audit , LOD-SF-PLT-AUDR , Request Audit Report (Not Change Audit) , Problem

Product

SAP SuccessFactors HCM Suite all versions