It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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
Iain Dooley Community Leader Aug 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

0 votes

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

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Trello

Develop a new Habit during Lockdown

If you had to thrive a new habit during a lockdown, what would it be? Trello

1,520 views 13 5
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you