Exporting Data from Jira Agile

Matthew Billings November 25, 2013

Is there a way to export data from Jira Agile?

I need to be able to display all Velocity and Burndown charts on one report. I can manage Burndown via the dashboard gadgets, but Velocity is proving elusive.

I've tried to export all issues from Jira into a spreadsheet and manage it from there, but info about sprint start dates/duration seems to be stored elsewhere.

Any suggestions for how I can either: a) embed muliple velocity reports in a single document (without copying and pasting each individual report); or b) export sprint start/end dates to a spreadsheet?

Thanks!

6 answers

1 accepted

1 vote
Answer accepted
Benito Picarelli
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 25, 2013

Hello Matthew,

I'm afraid there is no way to export the data in that way right now. You can only gather the info from the selected board's reports (velocity and burndown).

From the looks of what you intend to do, I believe that could be a very specific job for our team of experts, who would be happy to help you out! :)

Best regards,

Benito Picarelli

Matthew Billings November 26, 2013

Thanks for the swift response Benito - your definitive answer will save me hours of frustration!

Kind regards

Matt

Adam April 14, 2015

Is there still no way to export agile data from ondemand to hosted?

Tatum Bisley August 5, 2016

An update to this request would be good. 

Seem's completely bizarre that we can't export data into excel! Really strange!!!!

9 votes
Michael Aniskovich April 17, 2018

It just blows me away-- all of the ink dedicated to this one simple and fundamental ask, including all the gyrations we have to go through (thanks to those who've figured it out).  Just give me an export option for details in a Sprint report.  Please???  How difficult can this be?

Harish Balakrishnan July 17, 2018

True! 

Shawn_Rodgers June 12, 2019

They want you to spend more time on their platform haha

This is such a basic feature that has been asked for nearly 7 years (that's how far back I found a request for this)

3 votes
Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 20, 2018

Our apps provide the following exporting capabilities for Jira Agile (now Jira Software) data.

1. PDF View Plugin can export any issue, also from the backlog, from sprints, from Kanban / Scrum boards to custom PDF documents. Via scripting you should be able to do your own calculations. We even have an old template for team velocity reports that you could as starting point:

jira-burn-down-chart

2. The same app can export all Jira Software gadgets, so you can get burndown charts, sprint health or complete boards at a single click:

jira-dashboard-agile-sprint-report

 

3. Better Excel Plugin can export any issue (backlog, sprints, Kanban / Scrum boards contexts are fully supported) to custom Excel spreadsheets, if this is your preferred tool. You can use functions, formulas, charts on any Jira Software managed value (in this case, to get the Velocity chart):

 jira-agile-report-epic-pivot-chart

I am sure one of these 2 can solve your use case. 

(Disclaimer: these are paid and supported apps, and I am a developer.)

Ivan March 5, 2021

Hi,

 

Why doesn't this plugin export sprint data already closed?

Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 10, 2021

It does, but not from the Sprint Report screen.

Instead, run a JQL query like this in the Issue Navigator

sprint = "Your already closed sprint"

It produces the list of the issues you're asking for. Then export this issue list. That's it.

ivanelson March 10, 2021

Hi,

 

It is possible, but inefficient. It does not export all data (columns) to the sprint.

{ 
 "id": 34,
 "self": "https://fake.site.com/rest/agile/1.0/sprint/34",
 "state": "closed",
 "name": "EQUIPE 1 Sprint  3 - 20/10/20",
 "startDate": "2020-10-20T08:53:00.000-03:00",
 "endDate": "2020-10-27T08:53:00.000-03:00",
 "completeDate": "2020-10-27T09:03:21.083-03:00",
 "activatedDate": "2020-10-20T08:55:48.159-03:00",
 "originBoardId": 143,
 "goal": ""
}

And it is not possible through the Better Excel plugin.

0 votes
AgentSmith
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 27, 2015

You might want to take a look at these existing suggestions:

 

https://jira.atlassian.com/browse/GHS-8804 

https://jira.atlassian.com/browse/GHS-6135

 

0 votes
Jaakko Timonen April 1, 2014

Hi,

I am using Jira as a user in our sub-contractors account. The deal with the sub-contractor is about to expire and we'd like to have all our issues and agile board in our new account. Is there a way to get all the necessary data to the new account?

Thanks in advance!

0 votes
Jaakko Timonen April 1, 2014

Hi,

I am using Jira as a user in our sub-contractors account. The deal with the sub-contractor is about to expire and we'd like to have all our issues and agile board in our new account. Is there a way to get all the necessary data to the new account?

Thanks in advance!

Suggest an answer

Log in or Sign up to answer