microsoft excelmigrate-datatrello
I am using Trello as the Scrum tool of choice but need a way of exporting data to populate my burn down charts.
We are using Google Chrome but have data security concerns, so exporting to Excel is the preferred method at present.
How can I export Trello data to Excel?
There are only up to 5 or 6 lists that can be viewable at the same time.
So the two options would be to use:
In the first option I would imagine it would have to be something like
Here you would need to add up the points manually (Or create a userscript/extenstion see next option).
In the second option you can use this Chrome Extension to take care of your user points and let cards handle user stories. As you said this can be come unmanageable with next up/in progress/review/ so then you would have to keep the tracking cards to the left and the feature to the right on your board. When a new activity appears on a board ensure it is "bubbled" to the left as the most recent feature update. Assigning members can also ensure nothing is forgotten.
They should be given the same max height, i.e. they should be the same length if they would otherwise go off the board. If not, it's a bug.
There's a known bug that you may be experiencing. If you are zoomed out and click the 'Add card', then click off, it can shorten the list.
Most of this weirdness will go away with the new card composer, though. https://trello.com/c/pRlmLRWS
Best Answer
There is a free application known as TrelloExcel out there. I've been using it for about a week or two now - https://github.com/dillenmeister/TrelloExcel
It will very nicely export/import data, but it doesn't seem to handle updating existing items. For what you need it for, I think it will work to get you the task name, description, and due date (but no story points, hours or what is left). But then again, TrelloScrum adds the story points to the name in parentheses, so it couldn't be extremely difficult to extract it for your charts.