How to export table columns data to EXCEL or CSV

adyreddyn
Kilo Contributor

‎05-23-2017 08:47 AM

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

Preview file
89 KB
  • 33,963 Views
3 REPLIES 3

darius_koohmare
ServiceNow Employee
ServiceNow Employee

‎05-23-2017 02:13 PM

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
ServiceNow Employee

‎05-23-2017 02:14 PM

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


0 Helpfuls

darius_koohmare
ServiceNow Employee
ServiceNow Employee

‎05-23-2017 02:15 PM

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


0 Helpfuls