Export Over 1000 Results to Excel from JIRA Cloud
Platform Notice: Cloud Only - This article only applies to Atlassian products on the cloud platform.
Summary
From the Issue Navigator, users are unable to export to Excel more than 1000 rows.
Cause
The 1000-row export limit within JIRA Cloud is hardcoded specifically to prevent a performance hit to your instance
Solution
Workaround 1
Export issues by using Google Sheets or Microsoft Excel.
All steps can be found here: How to export more than 1000 issues using Google Sheets
Workaround 2
Use the pager/start
URL parameter to work around 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 that need to be exported (The example below contains 1000+ issues).
- Export the first 1000 issues using the standard export feature (Export > Export Excel CSV (all fields))
For the next thousand issues, right-click on the same option above and open in a new tab, you should get a URL string like below:
https://<instance name>/sr/jira.issueviews:searchrequest-csv-all-fields/temp/SearchRequest.xls?jqlQuery=&tempMax=1000
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:
https://<instance name>/sr/jira.issueviews:searchrequest-csv-all-fields/temp/SearchRequest.xls?jqlQuery=&tempMax=1000&pager/start=1000
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.