Export more that 100000 records via Export Set in xlxs format

[Service Manager]

Hi All,

I need help to export more than 100000 Incident records via export set.

FYI - All the system properties associated with export limit has been set to 100000, we can export as many records  as required manually but when we tried to automate the process via Export set.

It has a threshold at 10000, when I switch the the format to CSV it worked as expected. Is there  any way to export more than 10000 in xlxs format ?

Thanks

[AbhishekGardade]

Have you gone through this?

Export limit properties

Please mark as Correct Answer and Helpful, if applicable.
Thanks!
Abhishek Gardade
Hexaware Technologies

[Service Manager]

I tried but unfortunately it didn't work. However we tried via alternative way, elevated delta export  on export set and it worked.

Thanks!

[Ankur Bawiskar · Accepted solution]

Hi,

yes xls format has the limitation since Microsoft word itself has the row, cell and column limit.

you can use csv format; ideally it doesn't have any limit as such

I have exported ~3 or 4 lakh records using csv using export set

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Ankur Bawiskar]

Sorry for the typo.

It's Microsoft excel

Regards

Ankur