Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Gomathi Sundarraj February 26, 2025

 

 

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?

5 answers

1 vote
Jack Brickey
Community Champion
February 26, 2025

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

0 votes
Hannes Obweger - JXL for Jira
Atlassian Partner
February 27, 2025

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:

export-to-excel.gif

Any questions just let me know, 

Best,

Hannes

0 votes
Prachi Bolar
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
February 26, 2025

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. 

Thank You,

Prachi

0 votes
ELFAPP Technologies
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 26, 2025

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.

 

0 votes
Key, Todd
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 26, 2025

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!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events