Import cards from a file

Bring cards in from a spreadsheet, a Trello board, or a Jira, GitHub or Asana export, check a preview first, and undo the whole import in one step.

In short

Import turns the rows or cards of a CSV, Excel, Trello or Jira file into new cards on a board. You see a preview first and nothing is added until you press "Import". The whole import can be undone in one step.

Before you start

• Who: only people who manage the board can import, and only they see "Import cards".
• Plan: every plan. Imported cards count against the plan's card limit, and an import that would pass it is refused.
• First: have the file ready: a CSV or .xlsx sheet, a Trello board exported as JSON, Jira issues exported as CSV, GitHub issues saved as JSON, or an Asana project exported as JSON or CSV. It may be up to 10 MB and bring up to 2,000 cards.

Steps

1. Open the board's ... menu and choose "Import cards". The arrow beside "Add card" offers it too, and so does Board settings › "Connections" › "Imports".
2. Drop a file on the box or choose one. Change "Kind of file" if it was guessed wrong. "Download an example file" gives a CSV with every column read.
3. For a CSV or Excel file, check "Columns in your file": each card value, such as Title, Description or Due date, is read from the column you choose. Set a column to "Not imported" to leave it out. You need at least the Title.
4. Press "Preview" and read it. It shows which cards go to an existing column and which to a New column. It also shows who was matched, the first 20 cards, the rows left out and why, and the warnings.
5. Press "Import".

Result: a message says how many cards were imported and how many new columns were made.

Good to know

• Only people who manage the board can import.
• A file may be up to 10 MB and bring up to 2,000 cards. Cards come in with their column, labels, owner, dates, priority, checklist and comments, and with the values of your own board fields.
• Import always adds new cards. A card with the same title as one on the board is pointed out in the preview and still added.
• Labels from the file become your workspace's labels: a label you already have, in any spelling of upper and lower case, is reused, and a new one is added. A card keeps up to 10 labels.
• Imported cards do not set off board rules. They count against your plan's card limit, and an import that would pass it is refused.
• What happens next: the cards appear in their columns without setting off board rules. Nothing is sent to Trello or Jira.

Undo an import

Board settings › "Connections" › "Imports" lists each import: the file, who ran it, how many cards it made and how many rows were left out. "Undo" takes the whole import back in one step: its cards are archived, and the columns and the labels it made are removed while no other card uses them. Cards that were on the board before are untouched. An import that is undone cannot be undone again.

If something goes wrong

Related

• /help/boards/custom-fields
• /help/boards/columns-and-workflows
• /help/boards/move-and-archive