SAP Knowledge Base Article - Public

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


Employees are getting unreadable reports that are generated by the LMS if they upgrade their Microsof Office Version from 2010 to 2013.

The data is not not separated by the columns.



PCs which have Microsoft 2013 installed and use 2013 Microsoft Office  Excel.

Especially for European Users who have decimal separator as comma.

Reproducing the Issue

In LMS system, run any report in CSV format and open the report right after it's generated.


This seems an issue with the new version Excel in Microsoft Office  2013 especially for European users.


 We could have 2 workaround:

1. The decimal separator in win 7 for european countries is coma . You have to open Control Panel -> Regional and Language Options -> Aditional Settings -> Decimal Separator : click to enter a dot (.) and to List Separator enter a coma (,).


2. If the do not double click and open the csv files in excel, they could


  1. Open Blank Workbook.
  1. Go to DATA tab.
  1. Click button From Text in the General External Data section.
  1. Select your CSV file.
  1. Follow the Text Import Wizard. (in step 2, select the delimiter of your text)


Either solution should resolve the issue.  You could find more details at

If the workarounds not acceptable by the customers, we might need to reach Product Engineering Team to see whether a permanent solution possible.

See Also

2352120 - Issue with formatting of Excel report


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


SAP SuccessFactors Learning all versions