How to export a choice list field's values?

[maryellc]

I am in need of providing the list of choices for a choice list field, in Excel for subsequent import to a different system.  The 'export' option is not available from a column header when I view the field's choices.  Is there a way to export the values?

[JaeggerLegane]

Hello Maryellc,

Try this:
1. Filter navigator -> type sys_choice.list
2. Use the conditions to filter the relevant choices
3. Try export again via the column headers, this should work

[maryellc]

Thank you!  I also just happened to find that in the UI, I may right click on the field label and select 'show choice list' - which is then exportable via the column header option.  Appreciate the quick response!

[ersureshbe]

Hi, In OOB - You should do the manual action and export as csv or pdf files. If you want to achieve it through UI action then create a UI Page and option select the table and UI page should trigger based on UI Action. Write custom script to export as a file.

https://www.servicenow.com/community/developer-articles/generate-csv-file-through-script/ta-p/231977...

Use the following and take it as a reference & modify based on your requirements.

[maryellc · Accepted solution]

My solution was as simple as:

-locating the field on the UI form view

-right click and select 'show choice list'

-list view opens; select any column and export to xlsx