Trello board to dashboard
One Trello board, turned into something you can measure.
Export a board to CSV from the Trello board menu and drop it here. Archived cards come along in the export and are filtered out of the live counts, Labels and Members are split back into individual values, checklist progress is turned into a percentage, and Due Complete is kept distinct from whether the card sits in a Done list, because those two disagree more often than anyone expects.
Prefer the full explorer? Open the app, or start from the generic dashboard builder.
The export is one board, and it includes the dead cards
Trello's CSV export lives on the board menu, covers exactly that board, and requires a paid workspace plan. Free boards get the JSON export instead, which is a full backup rather than a table and needs flattening before anything can chart it. If the Export CSV option is missing for you, that is the reason, and it is not a permissions bug on your account.
What surprises people who do have the option is what comes out. Archiving a card in Trello does not delete it; it just hides it from the board. The export includes archived cards with an Archived flag set, so a board that has been running for two years hands you every card anyone ever swept away. Load that raw and your Done column looks enormous and your throughput chart is a fiction. Filtering on that one boolean is the difference between a useful file and a misleading one.
How to export from Trello
- Open the board and its menu Sign in at trello.com, open the board, then click the three dots at the top right to open the board menu. Export sits under the More section of that panel.
- Choose Export as CSV This option needs a paid workspace plan. On a free board you will only see Export as JSON, which is a backup format rather than a table and takes real work to flatten.
- Wait for the file to build Trello generates the CSV in place. Busy boards with long comment histories take a few seconds, and the file downloads directly rather than arriving by email.
- Repeat for each board you care about There is no workspace-wide CSV. A team running one board per squad needs one export per squad, and the headers line up so they merge cleanly afterward.
- Drop the file here List Name becomes the flow axis, the Archived filter is applied before any count, and Labels appear as separate chips rather than one joined string.
The JSON export from a free board contains the same information in a nested shape. Flatten the cards array to a table first and the resulting columns line up closely enough that this page reads it without complaint.
Try with sample Trello data (the same columns, 84 rows, no upload needed).
What the dashboard shows
Every panel below is built from a column that is actually in the export, named the way Trello names it.
- Cards by list. List Name is Trello's status, so it becomes the primary breakdown, ordered the way the board is ordered rather than alphabetically.
- Label mix. Split from the comma-joined column, so a card labeled both bug and blocked counts once under each rather than creating a third pseudo-category.
- Member load. Members split and counted per person, with unassigned cards kept visible because an unowned card in a Doing list is worth knowing about.
- Due date pressure. Overdue, due this week and no due date at all, as three buckets, with Due Complete respected so finished work stops nagging.
- Checklist completion. Checklist Items Completed against Checklist Items, which for teams that live in checklists is a better progress signal than list position.
- Staleness. Last Activity against today, ranked, which is the fastest way to find cards nobody has touched since a reorg.
Card ID,Card Name,List Name,Labels,Members,Created Date,Due Date,Due Complete,Last Activity,Votes,Checklist Items,Checklist Items Completed,ArchivedWhat the Trello export does not tell you up front
- CSV export is a paid feature. It requires a workspace on a paid plan. Free boards get JSON only, which is a nested backup rather than a table, and no amount of clicking will reveal the CSV option.
- One board per file. There is no workspace export. Squads that split work across boards get one file each and have to merge them, using the file name to remember which board is which.
- Archived cards are included. Archiving hides a card from the board but keeps it in the data. Every card ever archived on a long-running board arrives in the export with a flag you have to notice.
- Labels and Members are comma-joined. Both are multi-value. Two members on a card produce one cell with both names in it, which counts as a distinct pairing unless something splits it into individuals.
- Due Complete is not the same as Done. It is a checkbox on the due date, ticked independently of which list the card sits in. A card in Done with an unticked due date, and a card in Doing with a ticked one, are both extremely common.
- There is no completion timestamp. Trello records Last Activity, not when a card entered its final list. Cycle time cannot be computed from this file, only approximated from Created Date to Last Activity.
Trello was never designed as a reporting tool, and the export reflects that: it is a faithful dump of a board, not a record of how work moved. Filter the archive, split the multi-value columns, and it still tells you plenty about where the work is sitting right now.
Frequently asked questions
Why can I not find Export as CSV on my board?
Because CSV export requires a paid Trello workspace plan. On a free workspace the board menu offers Export as JSON instead, which contains the same cards in a nested structure meant for backup rather than analysis. You can flatten the cards array into a table and load that here, but it is genuinely more work than the CSV path.
How do I stop archived cards from inflating my counts?
Filter on the Archived column, which is a boolean set to true for anything you swept off the board. Archiving in Trello is a hide, not a delete, so a board that has been running for a couple of years hands you every card that was ever cleared away. This page applies that filter by default and shows you how many rows it removed.
Does Due Complete mean the card is finished?
Not reliably. Due Complete is a checkbox attached to the due date and is ticked by hand, entirely separately from which list the card sits in. Plenty of teams move a card to Done without ever ticking it, and some tick it while the work continues. The dashboard shows both signals side by side so you can see how far apart they have drifted on your board.
Can I get cycle time out of a Trello export?
Only an approximation. The file records Created Date and Last Activity, but not the moment a card entered a particular list, so there is no true completion timestamp to subtract from. Created Date to Last Activity is a reasonable proxy for cards that stopped moving once they were done, and a bad one for cards that keep collecting comments afterward.
Why do two members on a card create their own category?
The Members column is a single cell holding a comma-separated list of names, so a card assigned to two people produces a value that is literally both names joined together. A plain group-by treats that as a third person who does not exist. The parser here splits the cell and attributes the card to each member individually, which is why per-member counts can add up to more than the card count.
Is my board content sent to a server?
No. The CSV is read by JavaScript inside your browser tab and nothing is transmitted. Card names on an internal board frequently contain customer names, incident detail or hiring notes, which is exactly the kind of content that should not be pasted into an unfamiliar web tool. Close the tab and the file is gone from memory.
Related tools
Load a Trello board and see it without the archive
84 cards across four lists, archived rows mixed in, labels and members comma-joined, and a handful of cards with a due date ticked complete while sitting in Doing.
Open the sample Trello dashboard