Export Over 1000 Results to Excel from JIRA Cloud

Still need help?

The Atlassian Community is here for you.

Ask the community

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

Workaround

Use the pager/start URL parameter to workaround 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 need to be exported (Example below contains 200k+ issues).
  2. Export the first 1000 issues using the standard export feature (Export > Excel)
  3. For the next thousand issues, right click on the same option above and open in 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 Feb 5, 2018

Was this helpful?

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