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.

  • That's more of a comment, isn't? 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. Jan 5 '13 at 15:39
  • The "I'm looking at using this" triggered me a bit. 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. 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


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!


I have tested 2 tools allowing to export trello data to Excel:

Directly in Trello, you can subscribe to their Business Class package and export all cards from all boards in one operation. See their help page here. https://help.trello.com/article/747-exporting-data-from-trello-1

You can use the add-on Bridge24 for Trello. That tool allow you to select exactly which boards and cards you want to export to Excel. It will export your cards (including custom fields), checklists, comments and documents to separate sheets.

  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

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.