SAP Knowledge Base Article - Public

2599530 - Report Excel Formatting


A cell within a CSV report splits into more lines due to a carriage return, line break CR or LF character.


SuccessFactors Learning Management System (LMS) - All Supported Versions.

Reproducing the Issue

  1. Login as an admin.
  2. Navigate to Reports.
  3. Download a report in CSV format.
  4. Open with Excel.
  5. Note that a cell contains multiple lines due to special character.


  • This issue is caused by Excel foramtting.
  • LMS application is unable to alter this.


As a workaround:

  1. In the filter section of the report interface, choose semicolon as the delimiter.


  1. Download the report with the special character.
  2. Manually remove the special characters from the report in Excel.
  3. Use the command =CLEAN(A1).
  4. This will remove the extra lines.


  1. Change LMS application to English - there are no carriage returns.
  2. Download the report.
  3. Revert the LMS application language to the user's preference.


  • Download the report in HTML format.


Excel, Report, LMS, Formatting, Carriage Return, CSV, language, LF, Line BReak , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-DB , DB Data & Services , How To


SAP SuccessFactors Learning all versions