How do I export the contents of the planning board to a spreadsheet?

I am using GreenHopper 5.8.6 and want to export the contents of the Planning Board to a spreadsheet. They are ranked, so, ideally, it would be nice to see them in that order and with the Story Points shown. The goal is to capture the state of the Planning Board near the end of each iteration.

3 answers

This widget could not be displayed.

Hi Ronn,

The easiest way is probably to set up a filter in JIRA (in the Issues menu > Search for Issues) that picks up your project and just orders the results by Rank. You can then just hit the "Views" button and choose Excel.


This widget could not be displayed.

Thanks Shaun. I'm struggling with hitting people with too much data and it not making sense to them. The board views and backlog view are really nice to give a snapshot of work in progress and work to do. An excel sheet will just be ignored I think.

Anyway, the sorting by rank was the key thing I didn't know how to do for data export .. thx for that!

This widget could not be displayed.

For some reason I am not seeing the story point estimate as an export option when I "Search Issues" for a filter, then select Export. If I Export "All Fields" I can't see it either. Am I looking for estimate in the wrong place?

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Published 53m ago in Bitbucket

Branch Management with Bitbucket

As a project manager, I have discovered that different developers want to bring their previous branching method with them when they join the team. Some developers are used to performing individual wo...

15 views 0 3
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you