51

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

25

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,
  • 3
    This will get the multiple cards very quickly, though it doesn't allow you to add multiple fields. – Jared Oct 17 '13 at 14:25
  • This is the help page of trello – twnaing Mar 1 '16 at 6:23
6

Most of the solutions I saw here were pretty technical. Here is one that is really easy to do. You could use this Zap to automatically create Trello Cards from Google Docs spreadsheet rows.

Google Docs to Trello

The idea is that once you make this Zap, you can paste your CSV into the a Google Doc and run it through into Trello.

I think there is a limit of about 200 items per 10 minutes when importing stuff across, but normally you won't hit that.

  • 2
    Not really keen on a solution that requires a subscription, but some people may be fine with that. – Jared Oct 17 '13 at 14:24
  • Why not just copy and paste into Trello, since Trello now adds separate lines as separate cards? – Simon East Aug 21 '14 at 0:52
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/

  • Thank you, this works great. It allowed me to import my backlog very easily. – Remko Jansen Jan 8 '14 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 May 11 '18 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.

  • Does Import2 allow you to import checklist items along with your cards too? – Simon East May 11 '18 at 23:32
  • @SimonEast Unfortunately not at this time – Ashley_Milne May 14 '18 at 18:08
  • Does not appear to support comments either (many-to-one with a card) – DaveInCaz Jan 31 at 11:12
-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)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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