If you're after a small, light, free tool for importing Lists, Cards, Checklists and Items into a Trello board from a CSV file, I'm happy to announce TrelloBuddy. It's a Windows application that comes with an example CSV template and a User Guide. Use it as you see fit, and that's about it. | Download TrelloBuddy | Visit the website |

@james_folk - Let me ask around and confirm what our options are! I don't expect to have an answer for this until next week since it's "late" in the day and also Labor Day in the States 😂

Thanks, Dave. I started writing it up and hit a wall: when I use Create, the only option my account offers is "Ask a question," so it looks like article posting needs a permission I do not have. Is that something you request, or does it come with a rank? Happy to go the long way round if so. The piece is drafted either way. It is five things that go wrong when importing a spreadsheet into Trello: Excel serial dates, ambiguous date formats, board membership, no undo, and what keeping a board in sync actually needs. Not a tool pitch, with the disclosure at the end.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Free CSV importation tool for Trello

unknown

If you're after a small, light, free tool for importing Lists, Cards, Checklists and Items into a Trello board from a CSV file, I'm happy to announce TrelloBuddy.

1 Select Text File.png

2 Parsed Text File.png

3 Provide Credentials.png

4 Select Board.png

It's a Windows application that comes with an example CSV template and a User Guide. Use it as you see fit, and that's about it.

| Download TrelloBuddy | Visit the website |

Accepted answers

All comments

Dave LIAO

@[deleted]- thanks for sharing David!

Seems like this is more freeware than shareware, right? That is, you're not asking for money. 😊

Have any of your code online on Bitbucket or GitHub? Would love to contribute to your project.

unknown

Hello Dave.

Yes, it's freeware, not shareware. I forgot about the distinction between the two. I've updated the discussion heading.

At the moment I'm not hosting the code in the public domain in GitHub or similar. It's mostly PowerShell with some .NET libraries.

Virginie HM

@[deleted]I don't know how this is not getting more love. This freeware is awesome!!!

I haven't found anything else (even paying) that allows uploading Checklists and checklist items.

I know you said you are not doing support but I'm running into issues with the Description field not loading. I think it's because of the markdown I'm using. I'll test some variations.

I'm also having issues with the Due Date. My sample had this date 2020-11-30T10:23:15.000Z and it didn't load.

Let me know if you want to chat about it any further.

Thanks again!

unknown

@Virginie HMWith regards the Description problem, I found it was due to the markdown containing pound (#) symbols for headings. The bug also affected Comments if they contained pound symbols in their markdown. I've fixed the cause of the problem.

Please download the updated version, which now also:

Parses and adds multiple Labels with Label Colors to cards
Parses and adds multiple Members to cards, based on the board member's email addresses.

With regards the Due Date, it needs to match the date format your Trello instance / Atlassian account is configured for. If you're using US date format, swap the day and month around. IE 2020-30-11

unknown

A general update on some recent improvements to TrelloBuddy:

Added - Can now parse and import multiple Comments, delimited by semicolons, into each Card.
Added - Can now parse and add multiple Members, delimited by semicolons, to a Card using their usernames or email addresses.
Changed - Labels and Label Colors are now all delimited by semicolons, to allow commas in Label names.
Changed - The name of the Custom Field is logged when attempting to import data into it.
Changed - The Due Date is set after the Card is created, to allow for a supplied Due Date being invalid.

unknown

A general update on some recent improvements to TrelloBuddy v1-14:

Added - Can now parse and import a due date and a member into each Checklist Item.

Dave LIAO

@[deleted]- nice! I'm guessing we can import by Trello username now?

unknown

Yes, you can use either a Trello username or an email address. It doesn't check to see if any person found is or isn't a member of the Board, it only logs an error when trying to make that person a member of a Card or Checklist Item.

unknown

A general update on some recent improvements to TrelloBuddy:

Added - Can parse and import a Start Date into each Card
Added - Can parse and import a Cover Color into each Card
Added - Can parse and import a Cover Size into each Card
Changed - Errors when searching for usernames are now correctly logged
Fixed - Cards are correctly created if they have no Description
Fixed - Checklist Items will not be uploaded if the prior Checklist was not created

I'm also looking into parsing unlimited Custom Fields, instead of just one.

unknown

A general update on some recent improvements to TrelloBuddy:

Added - Can parse and import a Cover Brightness into each Card

The logic of the cover brightness is bizarre. If you set it to 'light' the text comes out black, and it you set it to 'dark' the text comes out white. Brightness is really referring to the brightness of what's behind the text, so the text has enough contrast to be read.

The brightness setting only has a visible effect if the cover size is also set to 'full' to make the text of the card's name overlap the cover color or image.

unknown

A general update on some recent improvements to TrelloBuddy v1-20:

Added - Can parse and import an option into a dropdown list Custom Field for each card
Changed - Will no longer parse unrecognised types in the CSV file

When importing an option into a dropdown list type of Custom Field, TrelloBuddy will go through all the options available for that Custom Field and try to find one that matches the value you supplied in the CSV file, irrespective of whether you supplied text, a number, a date or true / false.

David Bakkers

A general update on some recent improvements to TrelloBuddy v1-21:

Added - Can parse and import multiple Stickers, delimited by semicolons, into each Card

For the default sticker pack, the stickers are 'check', 'heart', 'warning', 'clock', 'smile', 'laugh', 'huh', 'frown', 'thumbsup', 'thumbsdown', 'star' or 'rocketship'.

For the Taco sticker pack, the stickers are 'taco-love', 'taco-confused', 'taco-cool', 'taco-angry', 'taco-celebrate', 'taco-robot', 'taco-alert', 'taco-active', 'taco-money', 'taco-reading', 'taco-trophy', 'taco-sleeping', 'taco-pixel', 'taco-proto', 'taco-embarrassed' or 'taco-clean'

For the Pete the Computer sticker pack, the stickers are 'pete-happy', 'pete-love', 'pete-broken', 'pete-alert', 'pete-talk', 'pete-vacation', 'pete-confused', 'pete-shipped', 'pete-busy', 'pete-completed', 'pete-space', 'pete-sketch', 'pete-ghost', 'pete-award' or 'pete-music'

Unfortunately, for custom stickers, they don't have names, they only have ids, like '60d7ab7573518d6c8de0432a'. The web interface doesn't provide those ids, so you're forced to use the REST API to look them up first. Refer to this article on how to use the REST API to lookup the ids of custom stickers for board members.

Alejandro Flores Mosquera

Thanks for sharing @[deleted]!!

Have you made progress in importing more than one custom field?

unknown

Hello @Alejandro Flores Mosquera

Yes, I did make a version that supports unlimited custom fields, but I decided against releasing it, because I didn't want to make a tool that competes against commercial products.

I know what it's like trying to make a living from being a small scale developer, and then someone produces a free version of what one of your products does, so I was keen not to be that someone.

Alejandro Flores Mosquera

Understood @[deleted], thxs anyway

Kate Bourland

Where will I find my key and token? I don't see it anywhere.

thanks

unknown

I've moved the location where TrelloBuddy is stored to my DropBox public folder, as Google keeps flagging *.ZIP files that contain *.EXEs as 'abuse' according to their new, more oppressive "If it's not a Google document, we'll make your life miserable" policy.

Grrrr!!

Hallina

I'm trying to download cards from one board specifically to Excel or cvs file - is this possible

Dave LIAO

@Kate Bourland - have you figured this out?

Dave LIAO

@Hallina - hi Hallinan! If you're part of a Premium workspace, you can export a Trello board in CSV format:

https://support.atlassian.com/trello/docs/exporting-data-from-trello/

Definitely start a new question if you have another one - click "Ask the community" in the header!

Ninel B_

@[deleted], thanks for making and maintaining this tool! And I appreciate your integrity : )

unknown

A general update on some recent improvements to TrelloBuddy v1-22:

Added - Card labels can be set to any of 30 colors, as part of Trello's updated color scheme

| Download TrelloBuddy |

unknown

5th June, 2024

A general update on some recent improvements to TrelloBuddy v1-23:

Added - Can set Lists to any of 10 colors, provided the user is on at least the Standard Trello plan
Changed - Will log when an invalid List, Cover or Card Label color has been provided, then set as a default value

| Download TrelloBuddy |

james_folk

Trello's built-in option only creates bare cards from a pasted list of titles, so anything with a description, a due date, or a checklist needs a power-up, and most of the CSV ones are paid.

I built a free one: Kanban Importer. It reads CSV, Excel, ODS, and JSON, matches your columns to card fields, and shows a preview of what it will create before it creates anything. No account, no card, no import limit.

https://njligames.com/tools/kanban-importer

Dave LIAO

@james_folk - thanks for sharing! 👏

If you haven't, I recommend writing up a fresh new article to highlight the Kanban Importer tool!

james_folk

Thanks Dave, and good idea. I will write one up.

The thing I would find useful as a reader is less "here is a tool" and more "here is why spreadsheet imports go wrong", since the same four or five things catch everybody. I will put that together.

Dave LIAO

@james_folk - You rock, and you're speaking my language! ✨

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

csv

trello

rest-api

import