How to export all issues of a single project to excel file

Rasika Senarath
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!
July 1, 2020

We are in requirement to export all issues of a project and consolidate them in to a single excel file for the ease of sharing between the stakeholders of the project. 

Excel file shall include data such as Issue ID, Reported Date, Priority, Reporter, Assignee, Status & Comments in separate columns.

Regards

2 answers

1 vote
Tim Straub
Contributor
July 2, 2020

Ha @Rasika Senarath ,

 

you can search for all issues within a project. In the results lists select the columns you want to have in the Excel file usins the button "Columns".

With the action "Export" you will be able to export them to a CSV file (Export >> CSV (Current fields).

Import them into Excel.

 

Hope this helps. 

0 votes
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 6, 2020

Hi Rasika - Welcome to the Atlassian Community!

Take a look at this free add-on from Atlassian. 

https://community.atlassian.com/t5/Jira-Articles/The-add-in-you-ve-been-waiting-for-Jira-Cloud-for-Excel/ba-p/1210420

It will allow you to open all issues in the filter in Excel even if there are more than 1,000. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events