How to export sprint status report in excel as-is?

Question

I have a requirement in which I want to export sprint report data as-is in excel.

I tried "View Issue in navigator" from sprint report to extract the data, but it always gives the latest status of a the issue, whereas I would like to know what is the status of issue at each sprint if issue is spanning from one sprint to another.

Example

Issue  logged in Sprint 1 and started working so status -in-progress

Sprint 2- Development is complete

Sprint 3- Closed

Now I am in sprint 3 , if I query the issue data then it shows Sprint as all 3 sprints and status as "closed" where as in each sprint "sprint report" it shows proper status at that sprint.

So question is how to get that sprint level status in excel?

Bill Sheboy · Answer

Hi @Nitu Tarnekar -- Welcome to the Atlassian Community!

What problem are you trying to solve?  That is, why do this?  Knowing that may help the community offer better suggestions / solution approaches.

Until we know that...

The information you note is stored in the history for each issue, but that cannot be easily queried with JQL and exported.  There may be marketplace addons to help to that, or the REST API functions may be called to get the history for each issue, and then reported in another tool.  There is / was a legacy REST API function to get the sprint report content, but I would not recommend using that as it is undocumented.

Please note what you describe for the carrying over of work, sprint after sprint, is a symptom of other problems.  This could include challenges with backlog refinement, sprint planning, team focus, scope churn, etc.  Rather than building a permanent reporting mechanism for this symptom, perhaps the team could pause at the end of each sprint's retrospective to investigate any carry over, identify the root cause, and then create experiments to resolve the problem and improve.  Your team's scrum master or agile coach could help do that.

Kind regards,
Bill

Kalyan Sattaluri_iinm1n · Answer

I dont think such thing exists.

You need to manually create snapshots of your sprint data daily or whatever frequency yourself.

In our company, there is a team dedicated to taking data extracts daily and publish tableau reports.