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
Zapier - Zapier 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.