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

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.


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!

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
Community showcase
Posted yesterday in Agile

What is Scrum? A good, bad, and ugly answer.

In a world of dark-scrum, faux-scrum, and scrum-butt, the question still remains: What is scrum and how do you do it “right?” That’s the question we set out to answer. I'm Max, I've been teaching c...

65 views 0 2
Join discussion

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