Export over 1000 results in Jira Cloud
Platform Notice: Cloud - This article applies to Atlassian products on the cloud platform.
Summary
In Jira Cloud, exporting up to 1000 issues at a time using the Export feature from the Issue Navigator is not supported.
- JRACLOUD-25493 - Getting issue details... STATUS
Below you can find two workarounds to accomplish this.
Workaround 1 - Export issues by using Google Sheets or Microsoft Excel
From the Issue Navigator (Filters > View all issues), after filtering the issues you want to export, you can click on Apps and select the desired option.
All the detailed steps can be found in the following article:
Workaround 2 - Export issues by adjusting URL parameters
This option doesn't work on the new issue search experience.
If you wish to proceed with the following workaround, if available on your instance, you can swtich back to the old issue search by clicking on More options (••• three dots menu) > Go back to the old issue search.
Once you are on the old issue seach experience, you can follow the steps below.
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.
- 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.