How to export Jira issues to CSV
Hi everyone,
We have identified this topic as a highly viewed Community post. In order to better serve all users that come across this post, here is an updated answer I hope will address the majority of visitors to this thread.
Yes, you can export Jira issues into a CSV format. The most direct way to do this is to first open the issue navigator and search for the issues you want to export.
In Jira Server/Data Center you can go to the top navigator bar and choose Issues → Search for issues.
In Jira Cloud today, the top navigation bar has this under Filters → Advanced issues search.
In either platform, Cloud or Server/Data Center, the URL of this page will be https://[$yoursiteURL]/issues/
Next you will want to search for the issues you want to export. Personally I prefer the Advanced Search mode that let’s you use JQL search here. So if you want to see all the issues in a project you can use
project=XYZ or if you want to try to see all the issues in Jira, use something like
ORDER BY created And then be sure to click the Search button.
Side note: JQL will only show you issues that your account has permission to view. That means if your account does not have browse permission on a project in question, or there is a security scheme in place that prevents you from seeing one or multiple issues, the JQL search results will not show those issues to you in these search results. This method of exporting issue data only applies to issues you have permission to see.
2nd side note about searching for ALL issues: Previous versions of Jira would almost always allow you to enter in an empty or blank JQL search in order to return all issues you can see. However for really large sites we found that doing this can sometimes cause performance problems to constantly try to return all the issues in a system, hence the use of the “ORDER BY created” JQL will still return all the issues, even if your Jira site might have disabled the ability to execute a blank JQL query.
Once you have completed the search you want, the top right corner of the Issue navigator page will have an Export button.
Server/Data Center export:
Cloud export:
Click that Export button and you can select from various formats to export this data, including CSV (if in Server/Data Center) or Excel CSV (if in Jira Cloud). The output here will be in a CSV format.
I hope this helps.
Andy
19 answers
1 accepted
Hi everyone,
We have identified this topic as a highly viewed Community post. In order to better serve all users that come across this post, here is an updated answer I hope will address the majority of visitors to this thread.
Yes, you can export Jira issues into a CSV format. The most direct way to do this is to first open the issue navigator and search for the issues you want to export.
In Jira Server/Data Center you can go to the top navigator bar and choose Issues → Search for issues.
In Jira Cloud today, the top navigation bar has this under Filters → Advanced issues search.
In either platform, Cloud or Server/Data Center, the URL of this page will be https://[$yoursiteURL]/issues/
Next you will want to search for the issues you want to export. Personally I prefer the Advanced Search mode that let’s you use JQL search here. So if you want to see all the issues in a project you can use
project=XYZ
or if you want to try to see all the issues in Jira, use something like
ORDER BY created
And then be sure to click the Search button.
Side note: JQL will only show you issues that your account has permission to view. That means if your account does not have browse permission on a project in question, or there is a security scheme in place that prevents you from seeing one or multiple issues, the JQL search results will not show those issues to you in these search results. This method of exporting issue data only applies to issues you have permission to see.
2nd side note about searching for ALL issues: Previous versions of Jira would almost always allow you to enter in an empty or blank JQL search in order to return all issues you can see. However for really large sites we found that doing this can sometimes cause performance problems to constantly try to return all the issues in a system, hence the use of the “ORDER BY created” JQL will still return all the issues, even if your Jira site might have disabled the ability to execute a blank JQL query.
Once you have completed the search you want, the top right corner of the Issue navigator page will have an Export button.
Server/Data Center export:
Cloud export:
Click that Export button and you can select from various formats to export this data, including CSV (if in Server/Data Center) or Excel CSV (if in Jira Cloud). The output here will be in a CSV format.
I hope this helps.
Andy
I use JIRA cloud - having clicked onto all issues from the JIRA board, I then had to switch to Advanced Search using the option on the top right, before I could get the export buttons, see screenshots below.
We are on JIRA Server 7.3.1. The only export options we have available are XML, Word and Printable.
I would be happy having either CSV or Excel, but currently there is nothing. Any idea what to do?
Try exporting by first navigating to Issues dropdown > more..., then click All issues on the left, then narrow down issues to export by filters, then click export. There are more export options in this view.
If you use Jira cloud is very easy. You must go at View all filters, choose one that you need work, and in top rigth yo have a selector with arrow, and you push and you can exportx in CSV. After you must save un format UTF8 or other because is a little bit ugly the format that it is downloaded.
Hi, I have a similar issue on my Jira, I cannot see the export to CSV.
Do you have any clue?
If anyone is still experiencing issues with this, it will give you all export options when in Issue Navigation screen. Filter your data to be exported by project, type, etc. Then click export.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.