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

[Yohannes Shenkute]

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? 

[Josh Costella · Accepted solution]

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

[Hannes Obweger - JXL for Jira]

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:

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

[Dave Rosenlund _Trundl_]

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