Exporting Excel from the CSM portal will take me more than 10 minutes for 13,000 records.

[LuisaMariaO]

Hi community,

Exporting Excel from the CSM portal will take me more than 10 minutes for 13,000 records.

What can I do to make it not take so long?

widget: DGS: Mosaic Component List

<ul class="dropdown_menu" ng-if="showDrop">
<li ng-repeat="t in ::exportTypes">
<a ng-href="/{{data.table}}_list.do?{{::t.value}}&sysparm_query={{data.exportQueryEncoded}}&sysparm_view={{options.export_view}}&sysparm_fields={{data.fields.join(',')}}" target="_new" tabindex="-1">${Export as} {{::t.label}}</a>
</li>
</ul>

Thanks

[kaushal_snow]

Hi @LuisaMariaO ,

ServiceNow places default caps on export operations to preserve platform performance:

Row limits: Usually capped at 10,000 records for formats like Excel, CSV, or XML. Exceeding this can lead to incomplete exports or system delays.

Excel-specific limits: Controlled by glide.xlsx.max_cells and glide.xlsx.export.limit properties, typically defaulted for up to 500,000 cells but often restricted to 10,000 rows per export. These limitations are in place to avoid performance degradation or system timeouts during heavy exports.

Steps:

1. System Properties Adjustment (Temporary):

Go to System Properties > Import Export.

Increase glide.xlsx.export.limit (for row limit) and glide.xlsx.max_cells (for cell limit). Remember to revert after use to maintain system health.

2. Chunked Export:

Break your export into smaller batches, filtered by sys_id or date ranges. Useful when exporting directly from UI list or via URL methods.

3. Scheduled Export During Off-Hours:

Start large exports during low user activity windows to reduce strain on the system.

Check below articels:

https://www.servicenow.com/docs/bundle/washingtondc-platform-administration/page/administer/exportin...

https://www.perspectium.com/blog/how-to-increase-servicenow-export-limit

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.

[LuisaMariaO]

The end customer is the one who requires to export this data from the CSM portal.

[Mark Manders]

I guess the best solution would be: Don't download such a huge load of data from the portal.

What's the business case? Why not do this through a scheduled job, if it is really needed to download 13000 records to excel?

[LuisaMariaO]

The end customer is the one who requires to export this data from the CSM portal.