Is it possible to export 200,000 cases from jira to excel?

[Matthew Olavydez]

I have tried at least 20,000 and it works well using the Jira for Excel add-ins. I wonder if this is doable for 200k?

[Joshua Sneed Contegix · Accepted solution]

Hi Matthew,

Yes, but it is painful. Review Atlassian's Export over 1000 Results to Excel from Jira Cloud page. TL;DR, iterate the 1000 result export 200+ times. If you're handy with scripting, you might be able to perform the same iterative method via the API.

I have exported ~132k issues on Jira Server 8.3 by changing the jira.search.views.default.max and jira.search.views.max.limit values. You may need to Export to Server, modify those settings, and then export all at once. I didn't experience any OOMEs with a 2GB heap in a virtual machine. Cheers!

[Matthew Olavydez]

Thanks a lot! Very useful tip :)