How to export CSV file more than 1000 issues through CSV file in Jira cloud

[Gomathi Sundarraj]

When i try to give message in comment section: 

I want to bulk export 6145 issues in Jira SaaS. How can I export them to a CSV file?

[Jack Brickey]

Hi @Gomathi Sundarraj , I recommend using either the Excel or Google Sheets extension to do this. Basically, within excel or sheets, you will be able to run a JQL query directly and get the results that you desire and it is not limited to 1000 issues. You can then save to CSV 

https://marketplace.atlassian.com/search?query=official%20excel

[Hannes Obweger - JXL for Jira]

Hi @Gomathi Sundarraj

if you're open to solutions from the Atlassian Marketplace, there's a number of apps available that provide enhanced export functionality, including the ability to export more than 1000 issues in one go.

E.g., you may want to have a look at 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 long list 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:

Any questions just let me know, 

Best,

Hannes

[Prachi Bolar]

Hello @Gomathi Sundarraj ,

Welcome to Community :) 

• Refer to this article on how to use Google Sheets or Microsoft Excel to export over 1000 results.
• An alternative solution is to use the Filter Counts gadget for projects with fewer than 9999 work items.
• Another option is the Starred Filters gadget, which retrieves even more tickets.

A few other solutions:

• After running the JQL query, just tap on the 'Export' icon on top right side and select 'Print List' option. It will show the full list of the work items with total number of work items, from which you can get the count.

In addition to the above workaround, there is also a knowledge article, which provides a workaround to see the total count of work items. 

• How-to-see-total-count-of-work items-when-using-jql-and-the-result-is-greater-than-1000

Thank You,

Prachi

[ELFAPP Technologies]

You can use our app Backup Projects for Jira, which allows you to export up to 25k issues in a single CSV file before it paginates into multiple files or export any Jira issues based on JQL at intervals that you can easily download anytime. It also allows you to change the CSV file delimiter to other characters besides just a comma.

[Key, Todd]

If you still are limited to 1000 by Jira's design try adjusting the time of these 6k+ line say if it was over one month export only 5 days at a time then later combine these< 1k. That is what I have to do. Cheers!