Business

How to export Trello to Google Sheets

  • Trello is a visual collaboration tool that gives teams a shared perspective on any project. It allows you to list out tasks related to a specific project and move them through different stages of completion in a visual and collaborative way. When you are working in Trello, you may want to export your entire project into a Google Sheet to edit and view it. It's easy to do and automate with IFTTT.

    join today button

    Here are the # methods we'll cover for exporting Trello to Google Sheets:

    Automated:

    • Sync Trello & Google Sheets with IFTTT [5 minutes]

    Non-Automated:

    • Use the Trello & Google Sheets Add-On [30+ minutes]
    • Export Trello Manually & Import to Google Sheets [30+ minutes]

    Sync Trello & Google Sheets with IFTTT [5 minutes]

    IFTTT stands for "If This Then That." It is an easy-to-use automation tool that allows you to transfer data between 750+ services online. In this instance, it allows you to connect and transfer data between Trello and Google Sheets. With IFTTT you can easily export Trello into Google Sheets and vice versa. The best thing about IFTTT is it is a no-code tool. That means you don't need to understand code to edit and create automations. All you need to do is drag and drop the triggers and actions you want to happen.

    How to Export Trello to Google Sheets with IFTTT

    1. Sign up for IFTTT.

    Join IFTTT

    1. Connect Google Sheets.

    google sheets integrations

    1. Connect Trello.

    Trello Integrations

    1. Create a custom Applet that allows you to export Trello to Google Sheets.

    DIY Applet creation

    Explore What You Can Do When You Connect Trello to Sheets

    [Feature popular Applets and link to the connect page: https://ifttt.com/connect/trello/google_sheets]

    2. Use the Trello & Google Sheets Add-On [30+ minutes]

    There are a few different Google Sheets add-ons or custom Trello add-ons that will allow you to export Trello into Google Sheets. Notes they cost money and are a little more complicated to build and manage than IFTTT.

    How to Export Trello to Sheets with an Add-On [30+ minutes]

    Blockspring is a google Sheets add-on that allows you to write custom code for Google Sheets. With Blockspring, you can write a script that keeps Trello in synce with Google Sheets. It requires you to understand how to write javascript, so it is a little more complicated than IFTTT. Blockspring is also more expensive than IFTTT with packages starting at $29/month. Here's how they do it, if you are more technical and can follow along.

    3. Export Trello Manually & Import to Google Sheets [30+ minutes]

    Trello has built-in functionality to export data into a CSV. You can then manually upload that CSV into a Google Spreadsheet. It's slow and you have to do it manually each time, but it works. You do need a premium Trello subscription to download your Trello board to a CSV.

    How to Export Trello to Sheets Manually

    1. Click to the right hand settings dropdown and click "Print and export."

    trello to google sheets manually1

    1. Open Print and export and click "Export as CSV."

    trello to google sheets manually2

    1. Head to sheets.new and open up a new Google Sheet Click "File" and then "Import" to start the CSV import process.

    google sheets new file

    1. Choose the CSV you just exported from Trello and import it into Google Sheets!

    trello to google sheets manually3

    Can Trello export to other Google Docs formats?

    Yup!

    1. Keep a log of every Trello task you complete in a Google Drive.
    2. Add new Trello Cards to a Google Spreadsheet.
    3. Publish new Google Calendar events to Trello.

    Connect Trello to other Services with IFTTT

  • join today button

You may also like