How can I export more than 1000 rows of filter results?

Steve Hooczko
Contributor
August 31, 2024

 

How can I export more than 1000 rows of filter results?

When I run a filter and do the export CSV or Excel it only exports 1000 rows.

How can I export as many rows as I like?

6 answers

2 accepted

2 votes
Answer accepted
Manoj Gangwar
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 1, 2024

Hi @Steve Hooczko , 

You can break the JQL to multiple parts using the created date range. 

For ex- project = ABC and created >= 2024-01-01 AND created <= 2024-07-01

Check the results if it is more than 1000 then reduce the date range. After that again run another JQL for next part of issues. 

Ex- project = ABC and created >= 2024-08-02 AND created <= 2024-12-01

As so on...... 

 

Steve Hooczko
Contributor
September 2, 2024

It took some more work to get all the data, but your solution worked.

Thanks for responding.

Like Yohei Umetsu_NRI_ likes this
0 votes
Answer accepted
OMAR MOHAMED AHMED MOHAMED FATHY
Contributor
September 1, 2024

try add on free of charge called status time free, and select the JQL , and Fields you want then export 

3 votes
Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 2, 2024

If you don't want your end-user waste their valuable time with manipulating request parameters or splitting the large result set to smaller chunks, just use the Better Excel Exporter app to export more than 1000 issues to standard Excel files (XLSX).

It just works.

(Discl. it is a paid and supported app developed by our team. Free for 10 users!)

2 votes
Mohamed Riza August 31, 2024

Hi @Steve Hooczko 

There are some workarounds to get more than 1000 users. These are explained in the following KB: https://confluence.atlassian.com/jirakb/export-over-1000-results-to-excel-from-jira-cloud-779160833.html

Hope that helps. 

Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 31, 2024

Nice! I did not remember the URL parameter.

Like Mohamed Riza likes this
2 votes
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 31, 2024

Hello @Steve Hooczko 

If you are using the UI there is a hard limit of 1000 issues for the export. You would need to refine you filter to get the issues in groups of 1000 or less, modifying you filter to get another group and export each group separately.

There may be third party apps that would enable you to export more than 1000 issues at a time. Are you willing to consider an app?

Or you can use the REST API to make multiple calls to retrieve the issues and save the results.

0 votes
Hannes Obweger - JXL for Jira
Atlassian Partner
September 12, 2024

Hi @Steve Hooczko,

just to add to @Manoj Gangwar's answer: If the issues that you're interested in have a (more or less) continuous sequence of issue keys within a project, another trick is to break your search up into smaller chunks using a condition like e.g.

issuekey >= "PROJ-1" AND issuekey < "PROJ-1000"

... and so on. This way, you at least don't have to fiddle around with your query to only hit <1000 issues.

Of course, as already suggested, it would certainly be easier to utilize one of various Marketplace apps that allow circumventing Jira's 1000 issue export limit. 

If I may provide a specific recommendation, this would be easy to do using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Plus, its export feature does all the work for you to work around Jira's 1000 issue limit:

export-to-excel.gif

Any questions just let me know, 

Best,

Hannes

Suggest an answer

Log in or Sign up to answer