How to import CSV to Trello

Question

I have a .csv file that I want to import to Trello. How can I go about doing that? Zapier won´t work because there are too many and I would be required to pay, which I´m trying to avoid.

there is a free power-up now which does this, including custom field data https://www.bluecatreports.com/imports/ — Robin, Aug 25 '22 at 09:18

score 15 · Answer 1 · answered May 18 '15 at 18:22

15

It's been some time since I used it, but this was killer:

Online Scrum Tools – Part 3 – Import Backlog into Trello

Basically, it's a Google Docs Spreadsheet with some custom JavaScript in it. You set it up with your Trello API Key, the Board ID, and the List ID, and it does the magic.

answered May 18 '15 at 18:22

Pittsburgh DBA

6,672
2
39
68

4

This was very helpful. Still works as of 2016.10.05. – bdwakefield Oct 05 '16 at 15:07
1

Still working as of 27-sep-2017 – Andrés Fernández Sep 28 '17 at 20:41
1

Man! Was this awesome. Thank you. Still working as of Feb 27, 2018. – aero Feb 27 '18 at 20:52
2

still works in March 2020 – hello world Mar 27 '20 at 17:38

score 2 · Answer 2 · answered Nov 17 '17 at 01:31

2

You can do this via the Import Wizard, by Import2 (disclaimer, I work for Import2). This will import your lists from CSV directly into Trello and there is no limit on number of items.

answered Nov 17 '17 at 01:31

Ashley_Milne

29
2

Konstantin Taranov · Answer 3 · 2019-01-31T11:55:17.280

Official Trello recommendation: https://help.trello.com/article/751-importing-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
Import2 Wizard - is a third party solution that allows you to import data in Trello from CSV files.

Bonus: Custom python script (thanks yo Joshm Carthur) https://gist.github.com/joshmcarthur/2839352#file-trello-cards-from-csv-rb

This exports from Trello, not INTO Trello – StayOnTarget Jan 31 '19 at 10:52 — StayOnTarget, Jan 31 '19 at 10:52

How to import CSV to Trello

3 Answers3