Exporting Trello Data for Reporting

Updated:

OK Spreadsheet nerds, this section is for you 🤓. Sometimes you want to have even more control over your reporting. Maybe you want to manage your own reporting in Excel or Google Sheets or pull data into BI tools to create your own analysis. All these tools and add-ons will help you export your data to get it out of Trello into any tool you want.

Trello Board Export Logo

Trello Board Export

Trello Board Export

Firstly we have to look at the export tool built in to everyones Trello Boards. From the menu on the right of your Board in Trello you can export to Excel (CSV) or JSON format. Exports include the main data from your cards, including any custom fields. As a starting point for getting data out of Trello and into Excel this is as good as any. If you need more complex capabilities then take a look at the options below.

Board Export (Excel, CSV, PDF, Image) Logo

Board Export (Excel, CSV, PDF, Image)

Get Power-Up
Board Export (Excel, CSV, PDF, Image)

Board export takes trello export functionality and adds a bunch of useful capabilities. You can export more fields than you can with the built in Board export, like comments and last activity date. They also add the ability to export to pdf or image as a way of getting a quick report on your board. If Trello’s built in export capabilities don’t deliver, or especially if you want a way to quickly export data from a selection of cards as PDFs this is a good choice.

Pricing is $7.50/month per user for unlimited boards (or $24/year)

Trello API Logo

Trello API

Worth a mention here but we will not go into any in depth coverage. If you are willing to work with the Trello REST API you can extract any data you want, and given some time and ingenuity can recreate any of the charting options mentioned here (and plenty more besides).

To get started with the Trello API check out