Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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?

share|improve this question
    
If you're just looking for an efficient way to create charts, you can take a look at the Trello API at trello.com/docs or if you don't want to program your own service or app, you can check out Trello charting options from sites like chartbreeze.com or bluelinegamestudios.com/trello –  Dan Esparza Mar 14 '13 at 14:57
    
blog-trapias.rhcloud.com/trelloexport-trello-to-excel a chrome extension that does the job –  Vijay Nov 12 at 9:06

4 Answers 4

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.

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

share|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!

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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