SAP Knowledge Base Article - Public

2489655 - Unable to Import Picklist


Attempt to import a picklist ended without any message or errors - nothing happened and the picklist was not updated; and the UI will suddenly change from the import screen to the admin center.

Reproducing the Issue

Issue 1 - Import a picklist using an excel file type.

Issue 2 - Import a picklist using a CSV file but face the same symtoms.


Issue 1 - This behaviour is caused by the incorrect file type being used like an Excel file (.xls).

Issue 2 - The picklist import template has been incorrectly modified or has deleted fields.


Issue 1 - Please use CSV file (.csv) type for import.

Issue 2 - If you experience the same symptom even when using a CSV file, please check that the correct picklist template is being utilised.

You can do this by using the 'Export data format' button in Picklists Management. No fields should be removed from the template as the system expects these fields during the upload.

Also, please ensure that no external codes are maintained for deleted picklist values. These fields should be blank.


Legacy Picklist Import, Strange Ui behaviour when importing, blank screen, , KBA , LOD-SF-EC-EDP , Employee Data Imports , Problem


SAP SuccessFactors HCM Core 1705