Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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

share|improve this question

4 Answers 4

I wrote a bookmarklet to help with this task. It's very crude and it works for me today, but I've only tested it briefly and only in Chrome. It calls some JavaScript functions in Trello directly so it's extremely likely that it will break when they update the site. Hopefully it works for you, but please don't use it if your data is critical in case it mangles it.

If you want to try it out, you can get the code from here. There's both a readable version, and a version suitable for copying into a bookmarklet. To use:

  1. Go here, select the entire contents ("javascript:..." to "...%29%28%29%3B") and copy to the clipboard.
  2. Create a new bookmark, call it something like "Trello - Add Many" and paste the contents from step 1 into the URL field for the bookmark.
  3. Go to the Trello board you want to add items to and click the bookmark. An overlay should appear that will let you select the list you want to add cards to, and enter a number of new card titles -- one per line.
  4. The overlay will disappear when you hit "Submit". If you want to get rid of the overlay without adding any new cards then just refresh the page.

Note: If you're trying to get your tasks out of Google Tasks and into Trello then choose Actions - Print task list in Google Tasks, copy the tasks from the printable view, and paste into the bookmarklet's entry box.

share|improve this answer
    
+1 Nice! Thanks Dave, saved me lots of time. –  Jonathan Moffatt Sep 25 '11 at 23:19
    
Glad it worked :) –  Dave Sep 26 '11 at 8:21
    
Wow ... impressive! –  Daniel LeCheminant Sep 26 '11 at 16:45
    
You are a hero. –  Kurt Spindler Nov 24 '11 at 17:43
    
Thanks, this worked like a charm! –  gabeiscoding Jan 10 '12 at 17:27

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,
share|improve this answer
1  
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

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.

share|improve this answer
1  
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 Aug 21 at 0:52

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/

share|improve this answer
    
Thank you, this works great. It allowed me to import my backlog very easily. –  Remko Jansen Jan 8 at 12:43

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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