Exporting data from checklist to excel/csv in trello

[Aaron Lewis]

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.  

[Jodi LeBlanc]

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

[Iain Dooley]

@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