Can we export Current Sprint to Excel

[Shubham Jadhav]

Hello,

I want to export my current sprint issues to excel but didn't find out the way to do it

is that possible to export sprint issues?

Thanks in Advance

[Mayur Jadhav · Accepted solution]

Hi Shubham,

Welcome to the Atlassian Community!!!

Yes it is possible to export the Current sprint issues in excel.

you can try the following steps:

1) Switch to Reports> Sprint Report.

2) Select desired Sprint.

3) Select the option "View in Issue Navigator".

4) Use "Export" to CSV option.

[Mayur Jadhav]

Please let me know if the solution is helpful!!

[Shubham Jadhav]

Thank you @Mayur Jadhav 

I am able to export the current sprint issues to Excel.

[Manisha]

Hi @Mayur Jadhav 

I have followed the solution given by you for downloading current spirt to excel.

After downloading a excel Assignee column is showing some I'd but not the exact assignee of the ticket.

Could you please help me with that?

Regards,

Manisha 

[Mayur Jadhav]

Hello @Manisha ,

Welcome to the Atlassian Community!!

It will export two column 1. Assignee Name and 2. Assignee ID. 

[Manisha]

Hi @Mayur Jadhav 

I appreciate your prompt response.

As I can see in file only one column is existing for "Assignee"

Which is having I'd of assignee

I would like to ask how can I get Assignee name.

Regards,

Manisha 

[Mayur Jadhav]

Hello @Manisha can you please share screenshot of how you are exporting??

[Manisha]

[Manisha]

I have downloaded with CSV ( all fields ) and tried with CSV ( current fields)

[Jack Brickey]

When you export any user field will be the user ID. This is part of GDPR adherence. Ne option is to leverage the APIs to export to CSV. I believe there are some Community post on this.

[Manisha]

Hi @Jack Brickey 

I tried with excel download option and It worked.

Thanks !

[Jack Brickey]

If you do this often then simply create a filter and save it. This way you can easily export. If your scrum board is simple (single project) the following JQL might work…

project = xxx and sprint in opensprints()

[Eric Andrade]

What if there are future sprints you need to pull down to CSVs?  something like: 

sprint in futureSprints()

? 

[Suvradip Paul]

Hi @Shubham Jadhav ,

Thanks for posting and welcome to the community.

 I think you can follow the suggestion as mentioned by Mayur above. Do you have any other specifications(like columns you are looking as part of this excel report)?

[Shubham Jadhav]

Hi @Suvradip Paul 

No I don't want such specific Features but I just want to export the Current sprint issues.

[Suvradip Paul]

Great @Shubham Jadhav  then Sprint Report would be perfect. Thanks for confirming.

Please keep visiting the community and sharing your thoughts, queries here.

Stay safe and healthy.