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.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.