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

Question

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?

carrie_eandm · Answer

@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.

Iain Dooley · Answer

@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