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?
@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.
@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:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.