Importing data into Trello

Trello doesn't have a generic import tool, but you have several options for bringing your data into Trello:

  • Copy Paste - When you paste text into a Trello card, each new line becomes a new card. This means if you have a list of card titles e.g. in an Excel spreadsheet, you can simply copy the title from one column and each cell from the sheet will become a card in a Trello list.

  • Trello API - You can use the Trello API to have full programmatic control of the import process
  • ZapierZapier is a third party solution that allows you to integrate over 600+ apps with Trello. Using Zapier, you can set up an integration between Google Spreadsheets and Trello so that lines in the spreadsheet get added as Trello cards.

    Here’s a premade Zap you can used to get started with that:

    There’s also a more detailed guide on using Google Sheets this way on Zapier here:  https://zapier.com/help/import-export/#using-google-sheets-for-import

    This offers more control than copy/paste without all the work of using the API.