Getting started with Kanban Importer
Install the Trello Power-Up, connect your account, and turn your first spreadsheet into a kanban board in about two minutes.
Kanban Importer turns a spreadsheet into a Trello board. One card per row, in the right list, with labels, dates, members and checklists already attached.
Add it to a board
- Open the board you want to import into.
- Open the board menu and choose Power-Ups.
- Open the Custom tab and add Kanban Importer.
- An Import button appears in the board header.
Connect your Trello account
The first time you use it, choose Connect to Trello and approve the request. It asks for read and write access because it has to read the board's existing lists and labels in order to match your file to them, and write the cards you asked for.
You only do this once. If nothing opens when you click it, allow pop-ups for trello.com and try again.
Your first import
- Click Import in the board header.
- Drop your file on the drop zone, or click Browse files. You can also expand Paste the data instead and paste straight out of a spreadsheet.
- Check the column matching. Columns are matched automatically from your header names, so a file with
Task Name, Status, Tags, Assignee, Due Dateusually needs no changes at all. - Read the preview. It shows the first rows exactly as they will be created, plus a summary of the lists and labels about to be added.
- Click Import cards.
Every row reports success, skip or failure as it goes. Cards are created in file order at the bottom of their list.
No file yet?
Click Download a template CSV. It is a filled in agile example built against your own board's columns, with one card per kanban stage and acceptance criteria already written as checklists. Delete the example rows and fill in your own.
What to know before a big import
There is no undo. Importing the same file twice creates the cards twice, so if a run fails part way through, use Download failed rows and import only that smaller file rather than running the whole thing again.
Try a five row file first. It costs thirty seconds and tells you whether your columns are matched the way you expect.