Export Over 1000 Results to Excel from JIRA Cloud
From the Issue Navigator, users are unable to export to Excel more than 1000 rows.
The 1000 row export limit within JIRA Cloud is hardcoded specifically to prevent a performance hit to your instance
pager/start URL parameter to workaround this issue by adjusting the index value to export issues from 1001 onwards. You will need to merge the results manually.
- Run a search on the issue navigator to get all the issues need to be exported (Example below contains 200k+ issues).
- Export the first 1000 issues using the standard export feature (Export > Excel)
For the next thousand issues, right click on the same option above and open in new tab, you should get a URL string like below:
Cancel the download, as we only require the URL string.
Append the &pager/start=1000 at the end of the URL string to instruct JIRA to export from index 1001 and above. Example:
Visit this URL in your browser and save the file when prompted. For the subsequent 1000 issues, adjust the index value accordingly, for example
&pager/start=2000(and so forth).
- Open the exported CSV files and manually consolidate them if necessary.