I am looking for a way to export data from archived cards to a spreadsheet. If there a better way to get the data instead of doing it manually by going through each and every card?
one way to do this is to set up an "Archive Board", where archived cards from one or several boards are collected (I use the automation tool Butler for this), and then create a JSON-file from this board.
(I describe this approach in this article: https://medium.com/@nspirITing/3-workflows-for-archiving-cards-in-trello-4fd3f6a9d65f)
Importing JSON into a spreadsheet shouldn't be too difficult.
Yes, that makes lots of sense. It would be easier to export the whole board. I haven’t had a chance to read the article you sent, but I will.
I guess the next question would be is there a simple and fast or automated way to move the cards already archived to the archived board?
The search function will return 1000 cards, so as you append each row to the spreadsheet it moves the cards to an archive board, this means you can re-run the script over and over again until all cards have been moved off your board and into an archive board list.
You can see how to setup and run this code here:
If you had to thrive a new habit during a lockdown, what would it be? Trello
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