Business Class - Exporting Data

Ellie Kuuskvere

Hey!! We are looking to export CSV files of our Trello Boards, so that all the information on our cards will be exported in columns in a file. 

We want to be sure, before we buy Business Class (currently we have been able to use the free version) that we can specify WHAT those columns will be. For instance, if we want an export that shows Due Date, three different Custom fields, and the Title of the card, we can make that. We also want to be able to export a file that includes the last comment on the card, for instance, and maybe a line of the description on the card.

Is any of this possible?

- Exporting files and specifying what the columns will have

- Exporting data from the description, comments, checklists on a card?

 

Thank you!!

Iain Dooley

@Ellie Kuuskvere everything is "exportable" from Trello in that it's got one of the best APIs on the market. This guy got me hooked on Trello automation with Google Apps Script, and he publishes a bunch of freely available scripts for doing things like backups and 2 way synchs with Google Sheets:

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

So basically what you would do is have a Google Apps Script that writes the data to a Google Sheet, then save that as a CSV. Trello doesn't have a direct-to-csv export feature.

I also created an open source framework for automating Trello with Google Apps Script:

http://www.trellinator.com/

This makes creating the type of thing you're after pretty trivial. You can export whatever you want to Google Sheets and work with it as CSV from there.