Export of a table with more than one million rows

[apulito]

Hello!

I created  my "own list" within the workspace, into the section licensing operation.
I want to do an export of this table, I tried to create a .csv export but it contains only 200.000 rows out of 1.500.000. There is any chance to export the entire table or split the table and then export it?

Thank you!

[uttkarshupa · Accepted solution]

Hey!

Looks like you’re hitting the row limit for the CSV export. Unfortunately, ServiceNow limits CSV exports to 200,000 rows. Here are a couple of ways around it:

1. Export in smaller chunks: You could filter the data (e.g., by date or category) and export smaller sets.
2. Export as XML: This usually doesn’t have the same row limit and could be a good option.
3. Scheduled Export: If you need to do this regularly, you can set up a scheduled export in smaller batches.
4. Use API: You could pull the data via REST API if you're comfortable with that.

For now, these are the options I know of. If any of them help, feel free to accept the solution and give a thumbs up.

[Mark Manders]

Check the 'Import Export' system properties (from navigator). It will show you the limits. I do have my doubts if you should be changing these properties for this, because I see no use of exporting 1.5M rows to csv, but if it's a requirement that does make sense, you can update the properties. Just don't forget to move them back, because it's a global setting and will have huge performance implications.

[Runjay Patel]

Hi @apulito ,

You can change the export property to increase and decrease the export value.

Note: If you increase the default value then it may impact the performance .

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

[Runjay Patel]

Hi @apulito ,

Thank you for acknowledging my solution as helpful! The community now supports multiple accepted solutions, so you can accept more than one answer.