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?
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @Gomathi Sundarraj ,
Welcome to Community :)
A few other solutions:
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.