How to export sprint metadata to CSV?

[Ivan]

Hi,

I want to export data from a sprint to CSV (Excel). In the Jira interface I did not find a simple and visible way to do this.

- Sprint name, id, Started; Planned; Ended...

I tried this plugin, but it didn't bring that data: https://www.midori-global.com/products/better-excel-exporter-for-jira/server/documentation/

[Bill Sheboy · Accepted solution]

Hi @Ivan 

You probably cannot do that with out-of-the-box Jira.  You could use the REST API to get the sprint information as JSON, and convert it as needed.  Here is the documentation on a couple of calls that would support that.

https://docs.atlassian.com/jira-software/REST/7.3.1/#agile/1.0/sprint-getSprint

https://docs.atlassian.com/jira-software/REST/7.3.1/#agile/1.0/board/{boardId}/sprint-getAllSprints

Best regards,

Bill

[Ivan]

Hi Bill,

Great tip! The sprint id is a little hidden inside the Jira UI, but I will follow.

Grateful.