Free Trello JSON to Excel converter
Convert a Trello board's JSON export into a free Excel or CSV spreadsheet, with one row per card. Every board member can export JSON on any Trello plan; Trello's own CSV export requires a Premium Workspace.
Your board stays on your computer. This page reads and converts the file inside your browser, and nothing is uploaded or sent anywhere.
Or paste the JSON:
How do you get the JSON file from Trello?
Open the board menu, choose Print, export, and share, then Export as JSON. Any board member can do this on Free, Standard, Premium or Enterprise.
- Open the board and open the board menu, the three dots at the top right.
- Choose Print, export, and share.
- Choose Export as JSON.
- Save what Trello gives you as a .json file and drop it above. If it opens as a page of text in a browser tab, save the page with Ctrl+S (Cmd+S on a Mac), or select all of it and paste it into the box.
Each JSON file covers one board. To combine boards in one sheet, export each board and select the files together. The Board column identifies each card's source.
Which card details are included?
The spreadsheet includes each card's list, title, description, labels, members, dates and checklist counts. Each row represents one card, ordered list by list and top to bottom.
| Column | What it holds |
|---|---|
| Board | The board's name, useful when several boards share one sheet. |
| List | The list the card sits in. |
| Card | The card title. |
| Description | The card description as plain text, with any formatting symbols left as typed. |
| Labels | Label names, separated by commas. A label with a colour but no name shows as the colour, for example "green (no name)". |
| Members | The people on the card, by full name. Someone who has left the board shows by name if the file still mentions them, otherwise as "Unknown member". |
| Start date, Due date | In your computer's time zone, as Trello shows them. The Excel file holds real dates you can sort and filter. |
| Complete | Yes when the card is marked complete. |
| Checklist items done, Checklist items total | Counts across every checklist on the card. They are two columns because Excel would read "3/5" as the third of May. |
| Archived | Yes for an archived card, or a card in an archived list. |
| Custom field: name | One column for each custom field, if the board has any. |
| Card URL | A link back to the card in Trello. |
Archived cards, and cards in archived lists, are left out unless you tick the box to include them. Comments, attachments and the activity history are not converted. In the CSV, a cell that starts with =, +, - or @ gets an apostrophe in front, so Excel reads it as text rather than a formula. The Excel file needs no such change.
Trello JSON to CSV, or Trello's own CSV export?
Choose Trello's own CSV export for a board in a Premium Workspace: select Export as CSV from the same menu. It includes custom fields, and Enterprise includes this Premium feature. For Free or Standard boards, export JSON and use the converter above.
Neither file is a reliable record of comments. Atlassian's export help page says the CSV leaves them out, and a board's JSON holds only its 1,000 most recent actions, which is where comments live. Neither file can be imported back into Trello to rebuild the board either, so treat the spreadsheet as a report or a record, not a backup you can restore.
Use spreadsheet analysis steps to build tables and pivots or split labels into columns. For whole-Workspace backups, see board and Workspace exports.
If the spreadsheet is a step toward leaving Trello, Breeze imports Trello boards directly, with lists, cards, checklists, labels and comments, and no file in between. See importing into Breeze.
Trello export questions
- Is my Trello board uploaded anywhere?
- No. The page reads the file in your browser and builds the spreadsheet there. Nothing is sent to Breeze or anyone else, and closing the tab clears it.
- Does it work on Trello's free plan?
- Yes. Every board member can export JSON on any Trello plan, and the JSON file is all the converter needs.
- Are comments included?
- No. The sheet has one row per card, and a card can have any number of comments. The board's JSON also holds only the 1,000 most recent actions, so older comments are not in the file at all.
- Can I convert several boards at once?
- Yes. Select or drop several JSON files together and they go into one sheet, with the board's name in the first column.
- Why do accents look wrong in my CSV?
- The CSV is saved as UTF-8 with a marker Excel recognises, so names like Jørgensen should open correctly with a double-click. If an older Excel still garbles them, use the Excel download, which has no encoding step.
