SAP Knowledge Base Article - Public

2352120 - Issue with formatting of Excel report

Symptom

When I run an Excel report, the data is not in the respective columns and therefore I cannot use filters.

Environment

Learning Management System (LMS)

Cause

This is a formatting issue with the default csv file viewer customers may experience depending on the Excel version used in their business.

This is not an issue with the report nor the LMS.

Resolution

When the report has generated and you get the pop up do not choose the OPEN option.

Instead save it on your computer and open it from the folder where you saved it, the output should be correct there.

See Also

2158316 - Why data in the generated CSV report are not separated by columns in Microsoft 2013 Office?

Keywords

LMS report, Excel, format, formatting, CSV viewer , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS , Learning Management System , Problem

Product

SAP SuccessFactors Learning 1602