How can I use the Export to Excel functionality for more than 1000 issues?

Maria Giannatou

We currently have a project that contains about 10k issues. I would like to know a way on how to export all of these issues to an excel file.

The currently implemented export to excel only exports the first 1000 of them without giving you a way to select (bulk select) the issues you would like to export in order to export, say, 10 different files containing 1k issues each.

This is what we want to do: Not bypass the 1k limitation (if this is possible, we could use it , but a way to export different issues multiple times in order to export all the 10k of them.

Nic Brough -Adaptavist-

Look at the url the excel link generates, it'll have &tempmax=1000 in it. Copy the url and paste it, but add a zero or two to the end of the number.

If that does not work, then your admins have deliberately locked it down to prevent it, but most off-the-shelf installs will let you do it.

However, please bear in mind that the limit is there for a good reason - the Excel export especially thrashes the system and you can expect Jira to slow down for everyone while it's exporting 10k issues.

On a human level, you have to ask why you think you need 10k issues in an Excel sheet, as there's almost certainly a better way to achieve the end result...