Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

How to export table columns data to EXCEL or CSV

adyreddyn
Mega Contributor

How to export table columns data to EXCEL or CSV, when I am trying export its exporting large number of records(10000) than what is showing in count on columns list. Please help

find_real_file.png

3 REPLIES 3

darius_koohmare
ServiceNow Employee

Right click the blue Dictionary entries then select 'Open in New Window'.


Make sure you are filtered to the data you want to export.


Then Right click a column in the opened window and select Export -> CSV.


Pradeep Sharma
ServiceNow Employee

Hello Suma,



Navigate to the table sys_dictionary and filter the records per your req->Once done you can export the records. More info here.


http://wiki.servicenow.com/index.php?title=Exporting_Data


darius_koohmare
ServiceNow Employee

Also check the Export Row Limit property to make sure it is sufficiently high for your needs.