Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

How can I make the title of each card in a specific Trello list generate a new line in Excel?

Stephanie Mellor August 20, 2019

I have a list in Trello that I would like to use to directly populate an Excel spreadsheet. I know there is a way to feed Excel using the comments in a Trello card, but is it possible to use other parts of the card (such as the title or description) to populate Excel as well?

2 answers

0 votes
carrie_eandm
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 22, 2019

@Stephanie Mellor I use the Booklet by Vince power-up on my boards! It allows you to select what list (or lists) you want to export directly into an Excel. It pulls in all the card information - description, labels, dates, members, etc. You can run the power-up whenever you need to.

Here's a link with more info on the Booklet by Vince power-up:
https://trello.com/power-ups/598b2de2adedc253537fdfcb/booklet-by-vince

There's also Board Export (Excel, CSV, PDF):
https://trello.com/power-ups/5c9418019e56bd8abf98d83f

I haven't used this one, but from the overview page, it seems to do the trick as well.

0 votes
Iain Dooley
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 20, 2019

@Stephanie Mellor if you're happy to go to Google Sheets first then download as Excel you can use Trellinator, here's a snippet that will create one row per card with name,description and comments:

https://gist.github.com/iaindooley/37321429c2732a7f05dad9c8c988046f

You can read more about Trellinator here:

https://community.atlassian.com/t5/Marketplace-Apps-articles/Introducing-Trellinator-Automate-Trello-with-Google-Apps-Script/ba-p/925271

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events