How to export Trello to Excel, Google Sheets or CSV

Which Trello plan do you need to export to Excel?

Premium or Enterprise. Atlassian's documentation states that boards in Premium Workspaces can be exported to CSV, and Enterprise includes everything in Premium. Free and Standard boards can be exported as JSON by any board member, and that is the only built-in export those plans get.

Premium is $10 per user per month billed annually, or $12.50 billed monthly, and Trello's pricing page lists the feature as "Simple data export" rather than naming CSV, which is why people on Standard go looking for a button that is not there.

Premium upgrades the Workspace, so the cost depends on its billable members and multi-board guests. Compare that total with a converter or export Power-Up before paying for a one-off export.

Is there a way to export Trello to Excel on the Free plan?

Not directly. Free and Standard export JSON only, and Excel does not open JSON as a table by double-clicking it. There are three realistic ways around that, and the right one depends on whether this is a one-off.

• Convert the JSON in Excel for Windows. Data, then Get Data, then From File, then From JSON opens the file in Power Query, where the cards sit inside a nested list you expand into columns. It works, and it is fiddly the first time, because card names, lists and labels live at different levels of the file and need joining up.
• Use a Power-Up. Atlassian keeps a directory of backup and export Power-Ups, and several produce a spreadsheet from a board on any plan. They are third-party tools, most of them paid, and the data in them is subject to someone else's terms.
• Pay for a month of Premium. Premium costs $12.50 per billable user for a month. The Workspace billing rules cover members and multi-board guests, so calculate the full Workspace bill before choosing this route.

Copying card names by hand leaves out dates and descriptions. Use an export if you need those fields for sorting, reporting or importing elsewhere.

Where is the CSV export in Trello?

In the board menu, under Print, export, and share. Exports are per board, so there is no button on the board that empties a whole Workspace into one file; that lives in Workspace settings and needs an admin.

1. Open the board you want in Excel.
2. Open the board menu from the top right of the board.
3. Choose Print, export, and share.
4. Choose Export as CSV. The file downloads to your computer with one row per card.
5. Open Excel and choose Data, then From Text/CSV. Select the file and check the delimiter and column types before loading it.
6. Save a working copy as .xlsx before adding formatting or formulas. Keep the original CSV unchanged.

Using Excel for the web

Choose Upload a file on Excel's start page. The CSV lands in OneDrive and opens read-only, and switching to Editing asks to convert it to a workbook, with the original CSV kept as a backup. Use the workbook for formatting, filters and formulas; CSV keeps only the data.

Exporting every board at once

A Workspace admin on Premium can export every board in the Workspace as CSV and JSON together. Find the Workspace in the left navigation, open Settings, then Export, and create a new export. Tick Include raw attachments if you want the actual files; they arrive in a ZIP in their original formats. Without that option the export links to attachments that stay hosted on Trello. Only Workspace admins can create or download this export, so a board member who is not an admin still exports board by board.

Can you get a Trello board into Google Sheets?

Yes, through the same CSV. For the built-in export route, upload the CSV to Sheets. It contains the same data as the file you open in Excel.

1. Export the board as CSV, exactly as above.
2. Open a new or existing spreadsheet in Google Sheets.
3. Choose File, then Import. The Import file window opens with tabs for your Drive and for Upload.
4. Open the Upload tab and drop the CSV on it, or browse to it.
5. Choose where the data should go, a new spreadsheet or the current sheet, and leave the option that converts text into numbers and dates switched on unless you want everything kept as plain text.
6. Import, then freeze the first row from View, then Freeze, so the headings stay visible while you scroll.

Dropping the CSV into Google Drive and opening it with Sheets from the right-click menu gets you the same result with one fewer dialog. Trello's dates arrive as text such as 2026-10-19T09:38:00.000Z, even with that conversion option on. A helper column with =DATEVALUE(LEFT(G2,10)) turns the due date in G2 into a real date, which Format, then Number, then Date then displays as one. And if you were hoping to skip the CSV because you are on Free, Sheets does not help: it has no built-in way to read the JSON export either.

How do you clean up the export in Excel?

Turn the data into a table, check dates, split cells that hold several values and hide columns you do not need to read. These steps make the export easier to filter and report on.

• Make it a table. Click anywhere in the data and press Ctrl+T (Cmd+T on a Mac). You get filters on every column and a header row that stays put, and any pivot table you build later can point at the table name rather than a cell range.
• Check the dates are dates. Trello writes them as text such as 2026-10-19T09:38:00.000Z, in UTC, and a CSV opened straight into Excel keeps them that way. A helper column with =DATEVALUE(LEFT(G2,10)) turns the due date in G2 into a real date to format as Short Date, or set the column type in Data, then From Text/CSV. A time close to midnight UTC can fall on a different day where you are.
• Split cells that hold several values. A card with several labels or members usually comes out with them in one cell, separated by commas. Text to Columns under the Data tab splits them into their own columns; in Excel 365, TEXTSPLIT does the same in a formula and keeps updating.
• Hide the machine columns. Keep identifier columns and links for matching or checking rows. Hide them rather than deleting them, so you can still click back to a card when a row needs checking.
• Tame the descriptions. Card descriptions arrive with their line breaks, which makes rows tall and the sheet hard to scan. Turn off Wrap Text for that column, or move it to the far right so it stays out of the way.
• Build a useful pivot. Cards per list, cards per member, and cards past their due date are the questions most Trello exports exist to answer. Insert, then PivotTable, with the list column as rows and card names as the count, creates the first report.
• Save as .xlsx. Formatting, filters and pivots do not survive in a CSV. Save a workbook and keep the original CSV next to it as the untouched copy.

What is missing from the Trello spreadsheet?

The CSV includes card fields, labels and custom-field data, but leaves out comments. Archived cards come along, flagged in an Archived column.

• Comments are not included. Atlassian states this outright for the CSV export. If you need them, the JSON export carries the 1,000 most recent actions on a board, comments included, and the whole Workspace export carries all of them.
• Archived cards are included. Atlassian's help page says the CSV skips them, but Export as CSV now downloads the board's own .csv address, and archived cards arrive with true in the Archived column. Filter that column to false to see only the live board.
• Inbox cards cannot be exported. Move them onto a board first.
• Attachments are not in the file. A spreadsheet cannot carry files. The built-in route to the originals is the Workspace export with Include raw attachments selected, which is Premium and admin-only.
• Butler rules and Power-Ups are not data. They are not included in the CSV. If the board runs on automations, write them down before you rely on the spreadsheet for anything.
• The file cannot become a board again. Atlassian says it is not currently possible to import JSON or CSV to recreate a Trello board, so treat the CSV as a report, not a backup you could restore from.

One more thing the spreadsheet is not: live. Every export is a snapshot, and there is no sync between a Trello board and a file. Later board changes do not update the file. Use it for a dated report, or choose a separate integration if the sheet must stay current.

Are you exporting a report or moving the board?

For a report, CSV is a useful snapshot. For a move, compare a direct importer with the file route: an importer can preserve discussion and more of the board structure. Trello's CSV includes custom-field data, but not comments, and Trello's built-in importer cannot use the export to restore the board.

Breeze can import Trello boards directly, including lists, tasks, comments, labels, custom fields and checklists. Attachments remain links to Trello rather than copied files, so download anything you need before closing the source account.

Check the Breeze import help and try one board first. Breeze costs $9 per user per month billed yearly, or $10 billed monthly, with every feature included. Compare Breeze and Trello before deciding whether to move.

For JSON, printing and Workspace backups, see the broader Trello export options. If you also use Asana, its Excel export steps work on every plan.