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.  

[Elinor Ni Chathain]

This is an old question, but I couldn't find a helpful answer. If you are on the free version of Trello, you can try printing to PDF, then copy and paste into Excel or LibreOffice Calc. This worked for me.

1. Go to Share > Print

2. Then instead of selecting your printer, change the destination to save as PDF, save.

3. Open the PDF in a document viewer, and copy the checklist items.

Only select the checklist, ignore the other parts of the card.

4. Open Microsoft Excel or LibreOffice Calc and paste the checklist items in there.

[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