Matching columns to Trello card fields
Every column becomes something on the card or is ignored. Ten fields are available: title, description, list, labels, members, due date, start date, checklist, first comment and attachment URL. Matching is automatic from your header names, and each field is a dropdown you can change before anything is created.
Every column in your file becomes something on the card, or is ignored. The matching is a guess you can correct: each Trello field is a dropdown listing your columns, and Do not import leaves a field out.
The fields
| Trello field | What the column should contain |
|---|---|
| Card title | Any text. Required. Rows with an empty title are skipped and reported |
| Description | Any text. Markdown works |
| List | A list name. Matched to an existing list, otherwise created |
| Labels | One or more label names, bug, urgent. Matched by name, otherwise created with a rotating colour |
| Members | Username, full name or initials. Only people already on the board can be matched |
| Due date, Start date | See the date formats below |
| Checklist items | Several items in one cell, separated by | or by line breaks |
| First comment | Posted as a comment on the new card |
| Attachment URL | An http or https link attached to the card |
How the guessing works
Header names are matched against the words people actually use. Task Name, Summary and Subject all find the card title. Status, Stage and Column all find the list. Assignee finds members. An exact match always beats a loose one, so a file with both Name and List Name gets it right.
Each column is used once. Anything left over is ignored unless you tick Append unmapped columns to the card description, which adds them to the bottom of each card as Story Points: 3.
Dates
These all work: 2026-09-03, 9/3/2026, 03.09.2026, 2026-09-03 14:30, 9/3/2026 2:30 pm, and anything Excel stores as a real date.
Day first dates such as 31/12/2026 are understood automatically when the day is above 12. When it is ambiguous, 3/9/2026 could be March 9th or September 3rd, tick Dates are day first and it reads them the European way.
A date with no time is set to midday, so it never slips to the previous day for members in another timezone.
Members
Trello only allows assigning people who are already members of the board. Names that do not match anyone are listed in the preview before you import, and the cards are still created without them. Add the person to the board first if you need them assigned.
Several values in one cell
Labels and members accept a comma separated list, bug, urgent. Checklist items use | or line breaks, because commas are common inside a task.
If a cell contains line breaks, those win, so a checklist written one item per line inside a spreadsheet cell imports as you would expect.