Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

Suggest an answer

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

📹 Favorite Trello templates

Hello Community!  My name is Brittany Joiner and I am a Trello enthusiast and Atlassian Community Leader. In this video, I'll share my favorite Trello templates. Templates mentioned in ...

1,539 views 13 35
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