I've got a Trello board which uses the Custom fields power up and labels.
I'd like to export a CSV or XLS file of all the cards with their custom fields and labels included.
I've explored various ways to do this, but so far haven't been able to find a solution. Any ideas?
As of January 2017, there isn't currently a way to export the custom fields data via the UI.
Luckily, it is accessible via the API and a call to the pluginData resource /cards/[cardId]/pluginData.
I've thrown together a small project that gets you halfway to where you want to be. You can check it out here: https://gomix.com/#!/project/export-trello-board-example
This is a small node app that will give you a JSON response containing a card's ID, name, and pluginData (if it has any). You can extend this and add in any fields you want!
pluginData for a card. Only a valid card ID will work for that resource. If you want to get the pluginData for a board, you will want to use this resource. It will take a board ID and give you the pluginData for that board.
Commented
May 15, 2017 at 12:39
From Trello's help page: http://help.trello.com/article/747-exporting-data-from-trello-1
Export to Excel / Spreadsheets
If you need spreadsheet support, boards exported with Business Class include CSV exports which can be imported in to spreadsheet applications like Excel. Each user in a Business Class team has an option on the board to export to CSV.
You can use the Trello Add-in for Excel here https://extracts.io/trello to import directly from Excel.
It imports Cards, Board and Teams. It will also import labels and custom fields.
It saves which boards you've selected, so if you create any charts, summaries or pivot tables, you can just go in and click "Import" to refresh the data.
Disclaimer: I made it!
Zapier has pre-built zaps that let you select custom fields to export to a Google Sheet, etc.
