Have you planned too much work this week?
Trello Power-Ups can help you figure that out. Plus, did you know there's an easy way to export all your cards from your board to a CSV?
Happy Trello Thursday! I’m heading to Italy in a few weeks and my Trello planning board is getting a lot of action this week. If you’ve been to Italy, feel free to share your tips with me!
🌮 Exporting archived cards from your Trello boards
🗞️ Discover more Trello use cases from experts
🛎️ Change boards without touching your mouse
💪 Do you know if you’ve planned too much? You can with this pup.
⚡ [PREMIUM] Hey Trello, tell me what to work on this week
Need a guide to setting up Trello, building automations, and adding Power-Ups to improve your workflows? I’m obsessed with Trello and I literally wrote the book on it!
Okay, now back to the show!
🌮 Dear Taco
This is a section where readers can submit their Trello questions, and each week I’ll pick one and answer it! It’s like “Dear Abby” but make it trello. Have a question you want to submit? Share it here.
Just saw this, "Trello's CSV export option no longer exports archived cards as of January 25, 2024. The CSV export now only exports visible cards.” This has thrown a huge wrench on a bunch of my projects. Any suggestions?
Hey again Forrest! Keep the great questions coming!
I wrote out a brilliant solution, and then
reminded me of another hack. While the export option on the board only exports visible cards, adding `.csv` to the end of your board’s URL will export ALL the cards, including archived ones.So you could just save that url and create a card on the board with it, so whenever you click it, it will download everything.
If that doesn’t work, or if you want a button on your board that also does it… keep reading. You can fetch all the cards on a board by using the board’s endpoint and passing a query parameter with filter=all.
https://api.trello.com/1/boards/{boardId}/cards?filter=all&key=APIKey&token=APIToken
That will return all the cards, and each one has a property called closed which is either true or false (true means it’s archived).
If you don’t have a dev background, that might sound useless to you. But here’s why you should care.
You should be able to activate this automation I built with PixieBrix: I haven’t done extensive testing with it yet, but it’s working for me.
Under the hood, I made the API request, got all the cards from the board, cleaned it up with a little Javascript, and then exported those to a CSV file that will appear in your downloads.
What you’ll need to do:
Install the PixieBrix Chrome Extension (it’s free) and create an account.
Create a Trello integration in PixieBrix. (This will feel a bit technical, but hopefully these docs I made for integrating Trello and PixieBrix will make it clear. There’s a video! You can also reach out to me if you get stuck.)
Once you’ve done that, click this link to activate the automation that I made for exporting. (You’ll need to select the Trello integration that you created in Step 2.)
And now when you go to a Trello board, you should see a button in the top of the board for Export Cards
and even if you don’t see it, you should be able to press CMD/Ctrl + M and open the PixieBrix Quick Bar, which will show the action.
Click it the button on the board or in the Quick Bar to run the action, and then check your downloads for the CSV.
If you run into any errors at all, make sure the board name doesn’t have any special characters in it, like emojis or dashes. I was having some trouble with that and I think I sorted out but some edge cases may sneak up.
For anyone who wants to try this out but needs some help getting set up, reply back to this email and I’ll send you a link to schedule a PixieBrix call with me to set this up together.
Want to submit your question? Maybe it’ll be featured next week!
🗞 New(s) and Links
If you’re free in a few hours, come join me today for Hold My Beer, Jira! I’ll show you how to decide when you should Jira, or when Trello might make more sense.
RSVP here to get the link to join at 2pm ET.
We’re teaming up with the Atlassian Community Events team to host an epic showcase next week: Trello enthusiasts will feature some of their favorite Trello boards, helping everyone learn more fun ways to use Trello. Join us on Sep 24, 12:00PM ET 👉 Save your spot!
🛎️ Trello Tip of the Week
Did you know you can press B anywhere in Trello to open a board search bar? Just start typing the name of the board you want to go and BOOM you’re there! (Michael Pryor himself showed me this feature many years ago and since learning, it’s the only way I navigate to other boards.)
💪 Featured Power-Up
Whether you’re an engineer or not, you should probably be adding story points to your tasks.
Why? Because story points track the estimated effort involved in a task, and if you’re not estimating how much work is on your plate each week, then you’re setting yourself up for failure.
I recently found Scrum Poker, which lets you assign story points to your cards, and perhaps the most fun feature- you can do Planner Poker with your team. Rather than one person deciding how much effort is involved in a task, everyone on the team votes, and the average is selected. Then you decide which ones you queue up to work on. You can set the number of story points you want as a max, and how you score cards, such as by numbers or t-shirt sizes.
And the best feature, you can see how many points you have across the lists in your board so you can check in with how you’re going through the week and compare how much you’ve accomplished week over week.
Special shoutout to my premium sponsors!
Thanks to:
Mike Day - Dreamsuite Mike
🎉 New Website 🎉
Trello Consulting done differently
Notes and Docs
Advanced notes and documents like in Notion, OneNote, or Confluence, but designed to be part of your Trello experience. Keep everything together without the need to jump back and forth between apps.Amazing Fields
Build custom workflows with extra data for cards with formulas, formatting, styling, custom fields, and everything else you could imagine needing to make Trello do your bidding.Turn Trello into a business hub with robust Power-Ups for recruitment, customer support, employee directory, knowledge base and more.
The best all in one power-up for planning, tracking and managing work across boards. Use extended board, reports, master boards, Gantt views and card mirroring across boards.
Unito
With Unito you can easily connect Trello to your other business critical apps with live bi-directional sync. In just a few minutes you can create your first flow, no coding or technical resources needed. Try it free today.Make the review and approval process an absolute breeze with Approvals for Trello, and say goodbye to never-ending email chains and having to chase your teammates for feedback.
Sendboard - Email for Trello
Organize & automate your Email in Trello. Connect any Trello board with Gmail, Outlook, Yahoo & more.Do more and enhance your Trello experience with the Handy Power-Ups Pack! Discover a variety of Power-Ups designed to boost your and your team's productivity. Try them out with a free trial and experience the difference today!
Tables & Spreadsheets
Easily create and manage tables within your cards, track tasks, budgets, and more with customizable columns. Perfect for teams needing organized data at their fingertips. Enhance your Trello experience with flexible tables and boost your productivity today!
🤔 Did you find at least one thing useful in this newsletter? I’d be thrilled if you’d share it on LinkedIn or with a friend!
The following content is only available for Premium Subscribers. Go to your substack settings and upgrade to a monthly or annual subscription!
Keep reading with a 7-day free trial
Subscribe to How To Trello to keep reading this post and get 7 days of free access to the full post archives.