What we do
Tools
Industries
Department
How we workLet's talk →
Home/Trello/Export Trello Board to Excel
Trello

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.

Board to spreadsheet

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 CSV

Any 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 Export

Which Trello export gets you the spreadsheet you need

What you need Route What it leaves out
One board, readable, today CSV export (Premium Workspace) Archived cards and comments. Type .csv at the end of the board's URL to include archived cards.
One board on the free or Standard plan JSON export, opened with Power Query Only the 1,000 most recent actions, so older comments drop off.
Every comment, every board, attachments too Workspace export (Premium, admins only) Tick Include raw attachments for a ZIP of the original files. Otherwise you get links.
A file someone else formats for you An export Power-Up from the Power-Up directory What each one includes, how often it runs, and whether it needs a paid tier. Read the listing first.
The same report every week, or several boards in one sheet A scheduled job on the Trello API Needs code, an API key and a token: the scheduled job n-frames builds.

Trello CSV or JSON: what lands in Excel

CSV

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.
JSON

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. 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 .json file.

  2. 2

    Load it with Power Query

    Data Get Data From File From JSON

    Pick the file. Power Query opens with the board as one record holding fields like cards, lists, labels and actions.

  3. 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. Filter closed to false if you only want open cards.

  4. 4

    Swap list IDs for list names

    Load lists the same way as a second query, then merge it with the cards on idList = id and keep the list name. Labels work the same way through idLabels.

    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. 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.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.