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
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.
Please let me know if the solution is helpful!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @Manisha ,
Welcome to the Atlassian Community!!
It will export two column 1. Assignee Name and 2. Assignee ID.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @Manisha can you please share screenshot of how you are exporting??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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()
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What if there are future sprints you need to pull down to CSVs? something like:
sprint in futureSprints()
?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Mayur Jadhav , we need help exporting subtasks as well. Following this method only exported the main task. Thanks!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No I don't want such specific Features but I just want to export the Current sprint issues.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.