Export Over 1000 Results to Excel from JIRA Cloud
Platform Notice: Cloud Only - This article only applies to Atlassian products on the cloud platform.
Platform Notice: Cloud Only - This article only applies to Atlassian products on the cloud platform.
Symptoms
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
Workarounds
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 200k+ 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.