I want to export all jira issues for the last three years. But I was only able to export 1000 record

Yohannes Shenkute April 22, 2024

Need help: Business wants to know the issues trend over the years and wanted to export all jira issues for the last three years. But I was only able to export 1000 records. why is that so? is it licensing? or configuration? 

3 answers

1 accepted

1 vote
Answer accepted
Josh Costella
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 22, 2024

Hi @Yohannes Shenkute

I would recommend adding a date filter to your JQL to narrow down the results. Also, if you have the free integration with Google Sheets, you can export more than 1000 tickets at a time. You can do up to 10k at a time. 

https://marketplace.atlassian.com/apps/1220382/jira-cloud-for-google-sheets-official?tab=overview&hosting=cloud

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
April 22, 2024

Hi @Yohannes Shenkute

to add to the previous answers, there's a number of apps available on the Atlassian Marketplace that allow circumventing Jira's 1000 issue export limit.

E.g., if a solution from the Marketplace is an option for you, 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, it allows exporting any number of issues in just a click, like so:

export-to-excel.gif

You may already know that you can trial any app for free for 1 month, and depending on the size of your size, it may be free forever. So if an app is an option for your, perhaps try a few and see which works best for you.

Any questions just let me know, 

Best,

Hannes

0 votes
Dave Rosenlund
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 22, 2024

Hi, @Yohannes Shenkute  👋  You're not the first to ask this. 

Check out @Alex Koxaras _Relational_'s answer in this thread for a work around: Jira's export limit is set to 1000 rows. Is there a way to increase that limit?

And be sure to vote for the enhancement request Alex lists, too 😊

Best,

-dave

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events