What are the different ways in which I can export all my sprints data as a report ?

[Preetham Bhat]

I am looking to export completed, not completed , added and removed story points of each sprint of different jira projects in bulk for analysis. Is there a way to do this using cron or any API ? If yes, could someone please share a document ?

[Himanshi]

Hello Preetham, 

Welcome to the community! You can check the sprint-related data using the Sprint Report feature in Jira : Sprint report

If you are not getting certain details as per your use case, It's worth to explore the marketplace add-on. 

Have a nice day!

[Alexey Pavlenko _App Developer_]

Hi @Preetham Bhat ,

Programatically it's not possible to do this, no REST API allows you to get all this info in once place. You need to write logic for that and iterate over each work-item from each board filter.

The easiest solution here is the Sprint Report but it requires you to analyze sprints one by one. 

You can use the app I developed - Multi-team Metrics & Retrospective, but it's a paid solution if you have over 10 JIRA users. You will be able to see all the sprints in one place, or group them by months/quarters/half-years/years for several teams/boards. With this, you will get many additional valuable features, one of which is in-place retrospectives.

General view:

Summary of metrics:

In-place retrospetives:

Best regards,
Alexey

[Iryna Menzheha_SaaSJet]

Hi @Preetham Bhat  👋

Great question — if you're looking to export story points data across multiple sprints and projects, including completed, not completed, added, and removed issues, here are your options:

✅ 1. Jira REST API (Best for Automation via Cron)

You can use the Jira Agile REST API to fetch sprint-level data:

Key endpoints:

• GET /rest/agile/1.0/board – to list boards

• GET /rest/agile/1.0/board/{boardId}/sprint – to list sprints

• GET /rest/agile/1.0/sprint/{sprintId}/report – to fetch sprint report data (includes completed, not completed, added during sprint, etc.)

⚙️ You can automate this with a cron job to regularly call the API and push the results into a database or export as CSV for analysis.

---

📦 2. Use an App 

If you prefer a no-code option with more analytics capabilities:

• Or use a marketplace app Time In Status to:

  • Filter issues by sprint

  • Export sprint metrics (status time, transitions, assignee data) directly to Excel

Also app give you access to Sprint Performance Report with supports Team-managed project. This report contains various metrics for each sprint, including Team Velocity. You can access it through the Time In Status app.

App developed by my team.
Have a nice day and happy sprinting 🥳

[Danut M _StonikByte_]

Hi @Preetham Bhat,

As far as I know, the only way to do this with Jira Cloud's native tools is to use the data offered by the Sprint Report available in your Jira project. But this does not seem to offer an export capability, so you will have to copy-paste it. There are no APIs available for report data on Cloud.

If you need a better way for this, a solution would be to search for an app on Atlassian Marketplace that offers better reports. 

In case you want to try an app, our Great Gadgets app, offers some gadget that offers sprint data, which can be easily exported in CSV.

Team Velocity gadget - offers detailed numbers about past sprints (story points commited, completed, added, removed, % completed, etc). 

Beside the chart itself, it can display a Data tab where you will find a detailed report for each sprint showing the all kind of stats/numbers for your sprints, which can be easily exported in CSV.

Sprint Burndown Burnup Chart gadget - offers a a chart and a sprint report similar to the one from Jira's Sprint Report, which can be easily exported.

But I expect this app to provide all the stats you need directly in Jira, in real time. So there's no need to export data, which will save you a lot of time!

Danut