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 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.

|improve this answer|||||
  • That's more of a comment, isn't? – Jacob Jan Tuinstra Jan 4 '13 at 19:06
  • 1
    Why would it be a comment? The OP asked if there was anything that would export to excel from Trello - I pointed to a possible solution. – ferventcoder Jan 5 '13 at 15:39
  • The "I'm looking at using this" triggered me a bit. – Jacob Jan Tuinstra Jan 5 '13 at 19:00
  • 1
    I used for about a week and I can say that it sort of fills the job. You can export and import records, but it doesn't seem to update. – ferventcoder Jan 16 '13 at 10:38

This is a bit off topic because it doesn't answer the question of Excel exporting, but it does address the side of good solutions for burndown charts. We use Trello Burndown from Blue Line Game Studios. It does a pretty good job and everyone can update their piece so it's not dependent on sharing an excel spreadsheet. You can find that at http://bluelinegamestudios.com/trello

Another thing I've seen folks do is use Google Docs Spreadsheets to do the charting. There are several articles listed that walk through how to set that up. There is a good one at http://echobehind.wordpress.com/2012/06/28/create-your-own-burndown-chart-using-trello-api-and-google-apps-script/ and at http://luebken.com/?p=354

|improve this answer|||||

There is no current functionality to do this (I'm not on the Beta, so I cannot test the Bulk Export functionality currently on offer, although it doesn't look like its what you need).

However, there is a card on the Ideas stack (sort of a feature request list), entitled CSV or Other Export. This looks like more what you want - however it's not implemented and is not on the list of items coming next. Looking at the comments on this card shows a workaround posted by "Zander Hill" which details how to use a Ruby Gem into XLSX (plus other formats). You may find joy in that solution, however I am unable to provide any support for this as I'm not a Ruby expert.

Hope that Helps!

|improve this answer|||||
  1. Go to Board Menu > Share, Print, & Export (this will export the data to a JSON file)

  2. Use this JSON to CSV converter to convert the JSON file to CSV format.

  3. Open the file up in Excel.

As recommended by Trello: http://help.trello.com/article/924-making-sense-of-trellos-json-export

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.