Is there any way to automate data exporting from trello to excel?

[Gushan Janith]

designing a dashboard in Excel using data extracted from trello and required to make this process automated. (The export data feature in trello can only be used to extract the past data?) 

[Torben · Accepted solution]

Hi there, 

The export in Trello will just export the board at the current state. 

You can automate this process by using an undocumented API feature. If you're unfamiliar with the API, you can read more at https://developer.atlassian.com/cloud/trello. For a Python example of exporting your organization's data via the API, see https://github.com/bentleycook/trello-python-demo/blob/master/demo_bc_org_backup.py

Another option might be using a 3rd party service like Zapier to keep data from Trello in sync with the other service: https://zapier.com/apps/trello/integrations