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
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 1,000 issues right-click on the page and choose 'Inspect'. This will open the developer tools.
Go to the 'Network' tab, select 'Fetch/XHR'
Enter views in the filter.
Next, refresh the page and select the Export dropdown menu.
Copy the URL from the link field of the corresponding export option in the ‘Preview' tab. Here’s an example:
https://<instance name>/sr/jira.issueviews:searchrequest-csv-all-fields/temp/SearchRequest.xls?jqlQuery=&tempMax=1000 or https://<instance-name>/issues/?filter=<filter number>
Append the &pager/start=1000 at the end of the URL string to instruct JIRA to export from index 1001 and above. You may need to change &tempMax=1,000 as well. 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.