How to Export a Trello Board (2026 Guide)
Exporting a Trello board in 2026 means choosing between three native formats and a handful of API or Power-Up workarounds. Free users get JSON. Premium and Enterprise get CSV. Everyone can print. And anyone willing to use the API can sync to Excel or Google Sheets directly. Here’s how each option works and which to pick.
1. Export to JSON (Free, All Plans)
JSON export is available on every Trello plan, including Free. It’s the most complete machine-readable export, but it’s not human-readable.
Steps
- Open the board you want to export.
- Click Show menu in the top-right of the board.
- Click More.
- Click Print, export, and share.
- Click Export as JSON.
- Trello opens the JSON in a new browser tab.
- Save the page (Cmd+S / Ctrl+S), or copy the contents into a file with a
.jsonextension.
What’s in the JSON
- Every list on the board.
- Every card: title, description, labels, members, due date, position.
- Every attachment URL (not the files themselves).
- All labels defined on the board.
- Every member of the board.
- The most recent 1,000 actions (card moves, comments, edits, archives).
- Custom Fields values, if you use Custom Fields.
- Power-Up data stored on the board.
When to use JSON
- Backups. Save monthly snapshots in case something goes wrong.
- Migrating to another tool: most project management tools that offer Trello migration (Asana, Linear, ClickUp, Notion, Jira) accept JSON.
- Programmatic processing. Pipe into a script that filters, summarizes, or reshapes the data.
Comments and history limit. JSON export includes the 1,000 most recent actions on the board. On busy boards with thousands of comments and edits, older history won’t be in the export. For full history, export all Workspace boards as Premium or use the API to paginate
actions.
2. Export to CSV (Premium and Enterprise Only)
CSV export is gated behind paid plans. It’s the right format if you actually want to read or analyze the data in a spreadsheet.
Steps
- Open the board.
- Click Show menu > More.
- Click Print, export, and share.
- Click Export as CSV.
- Trello downloads a
.csvfile.
Columns in the CSV
| Column | Contents |
|---|---|
| Card ID | Unique Trello ID for the card |
| Card Name | Title |
| Card URL | Direct link |
| Card Description | Plain-text description |
| Labels | Comma-separated label names |
| List Name | List the card is in |
| Members | Comma-separated member usernames |
| Due Date | Date string |
| Date Last Activity | Last edit timestamp |
| Attachment Count | Number of attachments (URLs not included) |
| Checklists | Names and items |
CSV does not include comments, full action history, or attachment URLs. Use JSON for those.
Include archived cards
By default, CSV export only contains active (non-archived) cards. To include archived cards too:
- Get your board’s URL (for example,
https://trello.com/b/abcd1234/my-board). - Append
.csvto the board ID portion:https://trello.com/b/abcd1234.csv. - Press Enter.
- Trello downloads a CSV that includes archived cards.
You must be a Premium or Enterprise member of the Workspace for this to work, the URL trick still respects plan gating.
Workspace-level CSV export (Premium and Enterprise)
Workspace admins can export every board in the Workspace at once:
- Go to Workspace settings.
- Click Export.
- Choose CSV or JSON.
- Optionally include raw attachments as a ZIP (admins only).
- Trello emails a download link when the export is ready (large Workspaces can take an hour or more).
3. Print a Board for a Snapshot
For a quick visual handoff or a printout, the print option works on all plans.
- Open the board.
- Click Show menu > More.
- Click Print, export, and share.
- Click Print.
- Your browser’s print dialog opens with a formatted view.
The printable view shows lists, card titles, labels, members, and due dates. It does not show full descriptions, attachments, comments, or checklists.
To save as a PDF instead, choose Save as PDF (or Print to PDF) in the destination field of the print dialog. Useful for status meetings, executive snapshots, or printing a board for a war room wall.
4. Sync to Excel or Google Sheets via the API
If CSV export is gated by your plan or you need the data updated automatically, the Trello REST API works on every plan.
Get your API key and token
- Go to trello.com/power-ups/admin.
- Create a new Power-Up (or open an existing one).
- Generate an API key.
- Click Token to authorize a personal token.
Pull cards from a board
The endpoint:
GET https://api.trello.com/1/boards/{boardId}/cards?key={key}&token={token}&fields=all
Returns a JSON array of every card on the board. Add &attachments=true to include attachment data, &actions=commentCard to include comments.
Pipe into Excel (Power Query)
- In Excel, go to Data > Get Data > From Web.
- Paste the API URL.
- Click OK, then Load.
- Right-click the loaded query > Properties > Refresh data when opening file.
Pipe into Google Sheets (Apps Script)
- Open a sheet > Extensions > Apps Script.
- Paste a script using
UrlFetchApp.fetch(url)to call the API. - Parse the JSON and write rows to the sheet.
- Set up a time-driven trigger (every hour, every day) to refresh.
This route gives you a live Trello-to-spreadsheet pipeline without paying for Premium and without a Power-Up subscription.
5. Power-Up Exports
Several Power-Ups in the Trello directory add export options Trello doesn’t ship natively:
- Export for Trello: bulk CSV/Excel exports with more fields than native CSV.
- Backup for Trello: scheduled JSON snapshots to Dropbox, Google Drive, or Box.
- Reports by Screenful: exports as PDF reports and analytics dashboards.
Most are paid (per-Workspace subscription) and require admin permissions to install. They’re worth it if you’re on Free or Standard and need recurring exports.
Quick Reference
| Format | Plan needed | Includes | Best for |
|---|---|---|---|
| JSON | Free | All cards, lists, members, attachment URLs, last 1,000 actions | Backups, migrations, programmatic use |
| CSV | Premium, Enterprise | Card metadata, no comments, no archived cards by default | Spreadsheet analysis |
| CSV with archived | Premium, Enterprise | Same plus archived cards | Full snapshot |
| Print / PDF | Any | Card titles, labels, due dates | Visual snapshots |
| API to Excel/Sheets | Any (with token) | Anything you query | Live syncs |
| Power-Up exports | Any (Power-Up cost) | Varies | Scheduled backups |
Which Format Should You Use?
- Need a backup or a portable copy? JSON.
- Need to analyze cards in a spreadsheet? CSV (Premium) or API to Sheets (any plan).
- Need a quick snapshot for a meeting? Print to PDF.
- Need data updated automatically? API + Power Query or Apps Script.
- Need scheduled, hands-off exports? Backup Power-Up.
Skip the Export-and-Email Loop
If you’re exporting Trello so you can send a summary, build a status report, or update another tool, an AI assistant can do that directly. Carly is an AI assistant that connects to 200+ apps including Trello and handles status updates, board summaries, and cross-tool sync for you.
More Trello guides: How to archive a card in Trello · How to copy a board in Trello · Best AI workflow automation tools
Ready to automate your busywork?
Carly schedules, researches, and briefs you—so you can focus on what matters.
Get Carly Today →Or try our Free Group Scheduling Tool or Free Booking Page