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

Is there a way to export all archived cards without having to go through each card?

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?

4 answers

I installed a similar extension.  Thanks, I'll check it  out.

0 votes
Iain Dooley Community Leader Feb 13, 2019

@Tai Nguyen this is a great article on backing up Trello to Google Sheets:

http://www.littlebluemonkey.com/blog/trello-backup-30

Thanks, I'll take a look!

0 votes
Katrin Anger Community Leader Feb 14, 2019

@Tai Nguyen

Hi Tai,

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?

Katrin Anger Community Leader Feb 14, 2019

Hm, that's tricky ... before I continue thinking about it: do you already have an account with Butler? (Because if not, then we would have to stop here anyway as Butler currently doesn't allow new users on board)

Iain Dooley Community Leader Feb 14, 2019

@Tai Nguyen @Katrin Anger here's the Trellinator code to do it:

https://gist.github.com/iaindooley/6f78c2fe6c19f86cb4bcf1a6907a1241

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:

https://community.atlassian.com/t5/Marketplace-Apps-articles/Introducing-Trellinator-Automate-Trello-with-Google-Apps-Script/ba-p/925271

0 votes

It takes just a few seconds using this Trello Excel export Chrome browser extension!

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