CSV and JSON import

Upload CSV for spreadsheet-style rows or JSON for structured records.

Choose CSV for portable flat tables.

Use familiar tabular data without manually copying every row into a card.

Choose JSON for structured technical storage.

Bring structured JSON records directly into a useful board workflow.

Prepare the CSV

Use one row for each Trello card you want to create. Keep the first row for column names and remove empty rows, merged cells, spreadsheet formulas, and presentation-only headings.

ColumnPurposeExample
card_titleThe short, recognizable card name.Confirm project scope
descriptionContext that belongs in the card body.Review the scope with the project owner
list_nameThe destination list for the card.To Do
Use a small test file first

Import five representative rows before running a large migration. Include a long description, an empty optional value, and at least two destination lists.

JSON import for Trello

Bring structured JSON records directly into a useful board workflow.

[
  {
    "card_title": "Confirm project scope",
    "description": "Review the scope with the project owner",
    "list_name": "To Do"
  },
  {
    "card_title": "Prepare launch checklist",
    "description": "List the final launch steps",
    "list_name": "In Progress"
  }
]

Select the structured source and preview the records before importing them.

Use a small test file first

Import five representative rows before running a large migration. Include a long description, an empty optional value, and at least two destination lists.

Map fields to Trello

JSON/CSV Importer

Connect source columns or properties to card titles, descriptions, and list placement.

Do not guess when two columns contain similar data. A preview is easier to correct than a board filled with cards whose titles and descriptions were reversed.

Run and follow the import

  1. Confirm the number of records matches the number of expected cards.
  2. Check several records from the beginning, middle, and end of the file.
  3. Confirm list names are consistent; “In progress” and “In Progress” should not accidentally become separate destinations.
  4. Start the import and keep the Power-Up open while it reports progress or errors.

Verify the board

After the import, compare the board with the source file. Count the created cards, open several records, confirm descriptions, and check that cards landed in the intended lists.

Common mistakes

  • Importing the entire spreadsheet before testing a representative sample.
  • Using inconsistent list names or invisible trailing spaces.
  • Putting several separate tasks into one row.
  • Assuming every spreadsheet feature has a direct Trello equivalent.
  • Skipping the post-import count and spot check.

Ready to import the file?

JSON/CSV Importer provides a visible upload, field-mapping, preview, and progress workflow inside Trello.

Explore JSON/CSV Importer