Is it possible to add values in dropdown using excel?

[Vijay Kumar4]

In the Incident table, I need to create a new dropdown field. Since the value list is long and dynamic, is it possible to upload the list from an Excel file?

[kaushal_snow · Accepted solution]

Hi @Vijay Kumar4 ,

> Import into sys_choice Table via Import Sets

Right-click your dropdown field on any record list and select Show Choice List. Export this list to Excel to get proper headers like Table, Element, Value, Label, etc.

>> Prepare your Excel: Ensure you include columns for table and element—they're essential for mapping the dropdown to the correct field.

>> Add your desired choice values.

>> Load and transform: Go to System Import Sets → Load Data, upload your Excel, and choose “Create Table” (makes a staging table).

>> Create a Transform Map from the staging table to sys_choice. Map each field correctly so the records land in the right dropdown.

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.

[Ankur Bawiskar]

@Vijay Kumar4 

Yes you can but why would that drop down field have long choices.

Anything above 5-6 is not a good user experience for user as they need to scroll to select the choices.

You can import data to sys_choice table using Import Sets.

Link for you to setup and get started

How to Load Data from an Excel File into a ServiceNow Table 

But do check this link

Table field value is not populate inside the sys_choice table after Import the data using the excel ... 

If my response helped please mark it correct and close the thread so that it benefits future readers.