Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

Exporting data from checklist to excel/csv in trello

I collate customer data in checklists in trello cards and want to be able to export it to excel/csv for analysis.  i am currently using trello for free but prepared to go to business class if we can do this.  

2 answers

0 votes
Iain Dooley Community Leader Mar 19, 2019

@Aaron Lewis Google Apps Script/Google Sheets is the perfect option for this. Without knowing anything about the structure of your data, here is a little example of dumping a bunch of checklist items into a sheet using Trellinator:

https://gist.github.com/iaindooley/9b8ae0ff9f24c21a7f928440ebd88667

Here's an article on how to set up Trellinator:

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

Here is a bunch more info on getting Trello data into Google Sheets (this guy's work is where I started):

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

0 votes
Jodi LeBlanc Community Leader Mar 20, 2019

Hi @Aaron Lewis I just read that Trello Business Class lets you export all of the boards in your team in both CSV and JSON format. You can also include all of your attachments as a .zip file in their native format. To do so, go to your team's page and select the "Export" tab. Please note that you'll need to be a team admin to access the "Export" tab. See trello.com/business-class to learn more.

https://help.trello.com/article/747-exporting-data-from-trello-1

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,663 views 16 7
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