SAP Knowledge Base Article - Public

2255189 - Unable to import the excel file in compensation executive review offline editing - Compensation Management


Executive review offline edit is not working. Getting the below error message while uploading the file.

Unable to import file. This might due to one of the following:

1. File is not in Excel Format.

2. File was not saved in earlier versions of Excel (Excel 97 -2003).

3. Original file was not exported from the system.



Compensation Management :

Reproducing the Issue

Export the file as excel and re-import the same file still not able to import the off-line edit file.


This issue occurs if customer is importing comp rating with text value(that can be ideally entered with a dropdown list driven by a rating scale in Excel export file). By design this is known limitation we cannot import the comp-ratings if the values are text and as of now we only support numerics.


Delete the comp-rating column and import the excel file and the issue would be resolved.


Executive review Import, Executive review Offline Edit Error, Offline edit. , KBA , LOD-SF-CMP-EXR , Executive Review , Problem


SAP SuccessFactors HXM Suite all versions