How to export data from Trello board to Excel

Trello is an open source web based project management application which organises the project information in the boards. The most important requirement for using these type of tools in our projects is to manage and to save or backup the data efficiently. Organizing data in Trello is very easy and user friendly. And for the backup of data, currently free version of Trello allow to export data into a JSON format. Export feature is available under the Board Menu > More > Print and Export.

 

Board Menu at the right most corner:

 

Print and Export option:

 

In the above pic, we have seen that only Export JSON option is available but if excel support is required then currently Trello does not has this feature in free version, only after subscribing with Business Class package on paid basis, this feature will be included. But not to worry as we can also get this feature simply by downloading a Chrome extension which alows to export data from Trello board to Excel xlsx file without paying a penny. Isn't interesting..that without paying anything Trello Business class feature can be used. Here is how we can do so:

 

Step 1:
Open Chrome Web store and search for extension named Export for Trello.

 

Step 2:
Click on Add to Chrome option.

 

Step 3:
Once the installation is complete, check for icon on chrome browser at the rightmost corner.

 

Step 4:
Next step is to refresh the Trello page once or twice and go to the path Board Menu > More > Print and Export. 'Export Excel' option will start appearing.

 

Step 5:
Click on the Export Excel link and check the downloaded file. All the cards present in the board will be shown as column names on excel sheet. And each column contains data of the corresponding board.

 

I hope this feature will help you a lot and will definitely eliminate most of your manual task. So start using this feature today only and enjoy Trello.

 

Thanks!!