2599530 - Learning Reports - Data in Excel cells split into multiple cells

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

SAP SuccessFactors Learning

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 formatting.

As a workaround:

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

Alternative:

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.

Alternative:

• Download the report in HTML format.

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