How to Export a Trello Board to Excel, on Any Plan
Your manager wants the board as a spreadsheet. Trello's export lives in the board menu under Print, Export, and Share. What you get depends on the plan: boards in a Premium Workspace can export to CSV, which opens straight in Excel. Everyone else gets JSON, which Excel can still read with a few extra clicks.
Premium Workspace: open the board menu, choose Print, Export, and Share, then Export as CSV, and open the file in Excel.
Board menu › Print, Export, and Share › Export as CSVAny plan: choose Export as JSON from the same menu, then load it in Excel with Power Query (steps below).
Whole Workspace: Workspace admins on Premium can export every board as CSV or JSON from the Workspace's Settings, then Export.
Workspace › Settings › ExportWhich Trello export gets you the spreadsheet you need
.csv at the end of the board's URL to include archived cards.Trello CSV or JSON: what lands in Excel
Ready to read
- One row per card, with list names, labels and dates as columns.
- Open it and sort. No setup.
- Unarchived cards only, and no comments.
Everything, but raw
- Cards, lists, labels, members, checklists and recent actions as separate arrays.
- Cards point at their list by ID, so you join the two to get list names.
- Available to every board member, whatever the plan.
Turning a Trello JSON export into an Excel table
These steps use Power Query in Excel for Windows or Microsoft 365. Names in Excel's menus can vary a little by version.
- 1
Export and save the file
From the board menu, choose Print, Export, and Share, then Export as JSON. If it opens in the browser, save the page as a
.jsonfile. - 2
Load it with Power Query
Data › Get Data › From File › From JSONPick the file. Power Query opens with the board as one record holding fields like
cards,lists,labelsandactions. - 3
Expand the cards
Click into
cards, convert the list to a table, and expand the columns you want:name,desc,due,idList,closed,dateLastActivity. Filterclosedto false if you only want open cards. - 4
Swap list IDs for list names
Load
liststhe same way as a second query, then merge it with the cards onidList=idand keep the listname. Labels work the same way throughidLabels.Watch for: custom field values sit in their own arrays, matched by IDs. Leave them out unless the report needs them, because the joins multiply fast.
- 5
Close and load
Load the result to a sheet. Next week, save the new export over the old file and click Refresh: the steps re-run, but someone still has to download the export first.
Trello export and import questions
Can I export a Trello board to Excel?
Yes. In a Premium Workspace, export the board as CSV and open it in Excel. On other plans, export JSON and load it with Power Query. Either way it's a manual snapshot, so a recurring report means repeating it each time.
Can I import a CSV into Trello automatically?
Not natively: Trello's help says its own JSON and CSV exports can't be imported to re-create a board, and there's no built-in scheduled import. Power-Ups and tools like Zapier can create cards from rows. For a recurring import from another system, n-frames builds a job on the Trello API that creates cards as new rows appear.
Does this work with Trello Power-Ups like the CSV importer?
Yes. A scheduled job can sit alongside an import or export Power-Up, or take over the manual trigger so it runs on a timetable or when something changes elsewhere in your stack.
Why is my Trello CSV export missing archived cards and comments?
The board CSV only includes unarchived cards and leaves comments out. Add .csv to the end of the board's URL to include archived cards. For every comment, a Premium Workspace admin can run a Workspace export.
We like Trello, but someone still exports the same report by hand every week. Is that worth fixing?
Usually. A weekly export and reformat takes time and almost no judgment, and it's easy to skip in a busy week. Pulling the board through the API on a schedule removes the download step and keeps the columns the same every time.