SAP Knowledge Base Article - Public

3500307 - Import from Micorsoft Excel file does not have dropdown option

Symptom

When Importing a standard Excel file, for example Marketing Lead, the columns available does not have dropdown to select the options. Only 'Use Existing Account' has dropdown.

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Go to Sales > Leads;
  2. Click on More > Import from Microsoft Excel;
  3. Download in English (or any other language);
  4. Choose New Marketing Lead;
  5. See the Excel file columns don't have dropdown options except for the Use Existing Account field.

Resolution

This is the expected system behavior for the standard fields.

If the feature/functionality is required urgently, please refer to KBA 3475641 - Functionality Currently not Available.

See Also

The KBA below can be followed to enable the dropdown option in KUT fields only:

2655960 - How to Enable Lookup For Extension Fields in Lead Excel Import

Keywords

KBA , LOD-CRM-LM , Lead Management , LOD-CRM-OPP , Opportunity Management , Problem

Product

SAP Cloud for Customer core applications all versions