Reporting on Sprints

Question

Hi Team- Looking to see how we can report on the current sprint only and not have multiple columns when I export.

There are some items that aren't finished in the sprint, and if I push to a future sprint, it shows as July+1 for example. When I export from the Issues tab, it shows each sprint separately
 - screen shot included.

Levente Szabo _Midori_ · Answer

@Katie A tried and battle-tested reporting solution is Better Excel Exporter for Jira, which allows you to export sprint reports from Jira to Excel.

To export a sprint report using Better Excel Exporter, follow these steps:

* Open the Active Sprint Board

* Select the “...” Menu

* Export Sprint Report
Choose the option to export a sprint report provided by Better Excel Exporter.

* This app allows you to generate detailed, customizable Excel reports, including committed vs. completed issues, assignee-based summaries, and more.

* Analyze and Share
Use the exported file to perform further analysis or share it with your team.

This method provides a powerful alternative to Jira’s native reports, offering deeper insights.

Learn more about this flexible way to export sprint reports from Jira to Excel.

(I'm part of the Midori team developing Better Excel Exporter for Jira.)

Vitalii_Bobak_SaaSJet · Answer

Hi @Katie It sounds like you’re trying to generate a report that focuses on the current sprint, with all issues listed under a single sprint column, even if some items span across multiple sprints. Unfortunately, Jira’s built-in export functionality often separates issues by sprint when exporting to Excel, especially if issues are associated with past or future sprints. Workaround Options: * Custom JQL Query for the Current Sprint: * You can create a JQL query to filter only the issues in the current sprint: scss sprint in openSprints() * This query will list all issues currently in the active sprint, reducing the chances of having multiple columns related to different sprints. * Using an Add-on: * Consider using an add-on like Time in Status. Add-on provides more advanced filtering and export options, allowing you to generate custom reports without extra columns for previous or future sprints. With Time in Status you can get Sprint Report Also you can get detailed reports (by grid, chart or as a dashboard gadget) filtered the issue list by sprint in add-on You can also book a live session or contact us at Support - we'll help you with Time in Status. Add-on developed by my team. I hope you find this helpful 🚀

Hannes Obweger - JXL for Jira · Answer

Hi @Katie

if you're open to solutions from the Atlassian Marketplace, 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 so-called smart columns that aren't natively available, including the last sprint (along with many other sprint-related columns).

This is how it looks in action:

As you can see above, you can easily sort and filter by the last sprint, and also use it across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Of course, you can also export your data - including the last sprint column - to XSLX (Excel or Google Sheets) or CSV in just 2 clicks.

Any questions just let me know,

Best,

Hannes