Export Over 1000 Results to Excel from JIRA Cloud

Still need help?

The Atlassian Community is here for you.

Ask the community

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.

  1. Run a search on the issue navigator to get all the issues that need to be exported (The example below contains 1000+ issues).
  2. Export the first 1000 issues using the standard export feature (Export > Export Excel CSV (all fields))
  3. 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.

  4. 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).

  5. Open the exported CSV files and manually consolidate them if necessary.


Last modified on Mar 21, 2024

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.