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

Business Class - Exporting Data

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!!

1 answer

0 votes
Iain Dooley Community Leader Oct 24, 2018

@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.

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,569 views 13 5
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