55

How can I import a large list of tasks (.csv or .txt) into Trello and convert into cards that are part of a list

5 Answers 5

29

This facility is now built in to Trello.

  1. Copy all your notes, one-per-line, to the clipboard
  2. In a list in a Trello board, click on "Add"
  3. Paste in all your lines, to this first new item
  4. Click Add, or hit Enter, and Trello will create one new task per row,
2
  • 3
    This will get the multiple cards very quickly, though it doesn't allow you to add multiple fields.
    – Jared
    Commented Oct 17, 2013 at 14:25
  • This is the help page of trello
    – Tun
    Commented Mar 1, 2016 at 6:23
4

I've created and shared a Google Spreadsheet which you can use to import multiple entries. It's geared towards a Scrum product backlog, but you could customise it if you want. Details here: http://www.littlebluemonkey.com/blog/online-scrum-tools-part-3-upload-existing-product-backlog-into-trello/

2
  • Thank you, this works great. It allowed me to import my backlog very easily. Commented Jan 8, 2014 at 12:43
  • Nice! This is the only option I've seen that allows you to import checklist items for your cards too. Is this script still working as of 2018?
    – Simon East
    Commented May 11, 2018 at 23:32
1

Another option is to use the Import Wizard, by Import2 (disclaimer, I work for Import2). This will import your data directly from CSV into a list in Trello.

3
  • Does Import2 allow you to import checklist items along with your cards too?
    – Simon East
    Commented May 11, 2018 at 23:32
  • @SimonEast Unfortunately not at this time Commented May 14, 2018 at 18:08
  • Does not appear to support comments either (many-to-one with a card) Commented Jan 31, 2019 at 11:12
0

There is now a free power-up which lets you import multiple cards from Excel/CSV files. This includes the ability to add all the standard Card fields and any Custom fields you have set up. You can try it out here Trello Import by Blue Cat.

-2

I assume you got this TXT or CSV file by exporting data from some other system. in some cases you can skip this intermediate step and transfer tasks between systems directly. one of the products that can do that is TaskAdapter: http://www.taskadapter.com.

e.g. here are steps for Trello and Atlassian JIRA integration: http://www.taskadapter.com/user-guide/trello/

or for JIRA and Microsoft Project: http://www.taskadapter.com/user-guide/atlassian-jira/atlassian-jira-and-microsoft-project-integration-step-by-step-guide/

(disclaimer: I am owner of TaskAdapter product)

Not the answer you're looking for? Browse other questions tagged or ask your own question.