Export Trello board to Excel: CSV, JSON and the free plan

To export Trello board to Excel in one step, you need a CSV, and Trello offers CSV only for boards in a Premium Workspace. Every board member can export JSON instead, which Excel can open with a little work. This guide covers both, what each file leaves out, and how to get the archived cards and the comments that the CSV skips.

1. Open the board, and open its menu.
2. Choose Print, Export, and Share.
3. Choose the CSV export. It appears for boards in a Premium Workspace, and each user of that Workspace can use it.
4. Open the file in Excel, and save it as an Excel workbook (.xlsx) if you will add formulas or formatting.

Per Atlassian, the CSV holds only cards that aren't archived, and no comments. Both have a way round (below). Cards in your Inbox can't be exported at all, so move any you need onto the board first.

On a free plan, the board menu's Print, Export, and Share offers JSON, and any member of the board can use it. JSON is a file for other software rather than for a spreadsheet: it holds the board's lists, cards and labels as nested data, along with the board's 1000 most recent actions, comments among them. Excel can turn it into rows.

1. Save the JSON. Choose the JSON export from the board menu. If it opens in a browser tab instead of downloading, save the page as a .json file.
2. Bring it into Excel. In Excel for Windows or Microsoft 365, choose Data, then Get Data, then From File, then From JSON, and pick the file. The Power Query editor opens.
3. Find the cards. The file opens as one record. Find the list in it that holds the cards, click it, and choose To Table. Then use the expand button on the column heading to pick the fields you want as columns, such as the card name, its due date and its list.
4. Load it. Choose Close & Load, and the cards land on a sheet, one row each.

Atlassian's page doesn't say what the file's fields are called, so look at what yours holds before you rely on one. If a card's list or labels come out as ids rather than names, load the board's lists or labels from the same file the same way, and look each id up there with XLOOKUP or VLOOKUP.

The CSV from the menu skips archived cards. Atlassian's way round: open the board, and add .csv to the end of its address in the browser's address bar. The file it gives you holds the open cards and the archived ones. Atlassian doesn't say whether it works outside a Premium Workspace, so try it on your board.

No CSV holds comments. Where they are:

• In the board JSON, as part of the 1000 most recent actions on the board. On a busy board that may not reach back far, so check the oldest comment you need is there. In Power Query, load the board's actions the same way as the cards, and keep the comments.
• In a Workspace export, which holds every comment. It needs a Premium Workspace and is for the Workspace's admins; it can include the raw attachments, which makes it a ZIP file.
• By hand, for a handful of cards: open each card, copy its comments, and paste them into that card's row as plain text.

• Keep the columns you need. A card name, its list, its labels, the due date and who is on it is a working report for most boards. Delete the rest.
• Check what came out. Atlassian doesn't list every field, so open a card with a checklist or a custom field and see whether it made it into your file before you promise it to anyone.
• Fix the dates. If a due date sorts as text, select the column, use Data, then Text to Columns, and choose Date in the last step.

Moving the work elsewhere instead? Our guides to exporting Asana to Excel and exporting Jira to Excel cover the same job in those tools, and the general fixes for pasted lists cover the spreadsheet problems all of them share.

Tabless is a browser extension that builds what you ask for from the sites you allow; nothing is typed or submitted without your OK. It isn't open yet. An export like this one is the kind of job we're building it for: asking in plain words for "every card on this board with its list, labels, due date and last comment", and getting it as a CSV or XLSX file with just those columns.

It's designed to read through the session your browser already has, so there are no API keys or passwords to hand over, and to ask before it reads each site. You sign in to Tabless with a Wix account.

No. Per Atlassian, neither the JSON nor the CSV can be imported to recreate a board, so treat the export as a copy to read and report from.

In one go, only with a Workspace export, which needs a Premium Workspace and is for the Workspace's admins. Otherwise, export each board and stack the files in one sheet, adding a column that says which board each row came from.

Not yet. Tabless isn't open, and exports like this one are among the jobs we're building it for. Join the waitlist, and we'll let you know when you can try Tabless.