2582788 - When exporting Learning reports to CSV, leading 0s in IDs are missing

When exporting a Learning report to a .csv file, the leading zeros on IDs are missing when opened in MS Excel.

SAP SuccessFactors Learning

1. The LMS has Item IDs, User IDs, etc., that are numeric only >
2. Run a report that returns numeric IDs and outputs to a CSV file >
3. Open the CSV file in MS Excel >
4. Note that the leading zeros are removed.

This is the expected behavior of Microsoft Excel and is a third-party issue. The zeros are being exported by Learning.

• View the .csv export in a text editor such as Notepad, and you will see the zeros are visible.
• To preserve the leading zeros when viewing the CSV in MS Excel, format the column containing the IDs as Text before saving.
• Refer to Microsoft support for additional assistance if needed.

learning, leading, 0, zero, missing, remove, incorrect, wrong, ID, user, User Item, export, csv, comma, delimited, excel, report , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS , Learning Management System , Problem