How to download ServiceNow table data to excel .xlsx file

[Dush]

hi team
I have a task to download nearly 400000 records from the incident table to a excel (.xlsx). but the limit I can reach is 50,000 records as SNOW system restrictions.
I have searched the articles and found that I can change the system properties ' System Properties > Import Export' . But system prevent me overriding the value for rows in excel (.xlsx) section.
further Break up a large export (servicenow.com) depicts how to accomplish the requirement for XML.
I tried several times to tweak the code to EXCEL (XLSX) but downloading does not start.

https://instance name.service-now.com/incident_list.do?EXCEL%20(XLSX)&sysparm_orderby=sys_id&sysparm_record_count=50000

please advise how should I continuously download the full table 400000 records in to excel.xlsx

Do you have any other alternative approached to reach the same goal?

[stevemac]

there are limitations on how much data can be exported to XLSX.  It is a lot less than the hard limit in Excel.  Recommend you export to CSV instead

System Properties controlling how many records can be exported are

• glide.csv.export.limit
• glide.xlsx.export.limit
• glide.excel.export.limit

if you have to increase them - then revert them post export.

alternate approach would be to export them using API

[IAmAbhigyaan12]

@Dush : You can find the below mentioned properties and update that

EXCEL (XLSX)	glide.xlsx.export.limit	glide.ui.export.limit	10,000
EXCEL (XLS)	glide.excel.export.limit	glide.ui.export.limit	10,000
EXCEL (XLSX)	glide.xlsx.max_cells	N/A	500,000
EXCEL (XLS)	glide.excel.max_cells	N/A	500,000

Please mark helpful if you find that correct

[Dush]

@IAmAbhigyaan12  and @stevemac  both of your answers are correct and I'm in a state of catastrophe right now to decide who to give the correct answer flag. 😞