How can I import a large list of tasks (.csv or .txt) into Trello and convert into cards that are part of a list
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:
Note: If you're trying to get your tasks out of Google Tasks and into Trello then choose
|show 5 more comments|
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.
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.
A workaround, for PC users who are really keen to import lots of items into Trello:
If you're on a Windows PC, and you've really got too much text to use a manual copy-and-paste route, then it might be worth your while to have a go with AutoHotKey, which allows you to write scripts that automate PC applications.
The following isn't meant to be a complete description of how to implement it, but instead to just give a flavour of what AutoHotKey could do.
Here is an example sequence of AutoHotKey commands, that adds three items, "Foo", "Bar" and "It works with multi-word items too":
If you had AutoHotKey installed, then you would use this by:
The above example just shows that it's possible to script Trello with AutoHotKey.
In order to use this for your task, you'd also need code to read the lines from your text file. See the documentation for
(Disclaimer: in FireFox 6.0.2 on Windows, the above commands insert the list items in reverse order: you could obviously work around this by processing the file in reverse order)
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/