Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,463,730
Community Members
 
Community Events
176
Community Groups

Can we export Current Sprint to Excel

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

3 answers

1 accepted

8 votes
Answer accepted
Mayur Jadhav Community Leader Oct 30, 2021

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.an1.PNGan2.PNG

2) Select desired Sprint.

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

4) Use "Export" to CSV option.

an4.PNGan5.PNG

Mayur Jadhav Community Leader Oct 30, 2021

Please let me know if the solution is helpful!!

Like # people like this

Thank you @Mayur Jadhav 

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

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 

Hello @Manisha ,

Welcome to the Atlassian Community!!

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

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 Community Leader Oct 19, 2022

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

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

Jack Brickey Community Leader Oct 19, 2022

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.

Hi @Jack Brickey 

 

I tried with excel download option and It worked.

 

Thanks !

2 votes
Jack Brickey Community Leader Oct 30, 2021

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()

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

sprint in futureSprints()

0 votes

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)?

Hi @Suvradip Paul 

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

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.

Like Mayur Jadhav likes this

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events