Featured image displaying the logos of Trello and Microsoft Excel in Unito's guide to setting up a simple Two-Way Sync.

How to Sync Trello Cards with Microsoft Excel for faster reporting

Published in Use cases on , last updated .

This step-by-step guide will show you how to import data from specific boards in Trello with Microsoft Excel spreadsheets automatically. To do this, we’ll connect Trello and Excel Online to Unito in order to facilitate and expedite the automated integration that turns new Trello cards into spreadsheet rows whenever new cards are created based on parameters set in Unito.

This automated workflow doesn’t require an IT department or coding knowledge to setup since Unito is designed with a point-and-click interface so anyone can integrate Trello and Excel relatively easily.

It can save you hours of manual input for any type of project report you have in mind so you don’t have to import cards manually. Instead Unito will import cards automatically with two-way live updates whenever changes occur in connected Trello boards or Excel online spreadsheets.

Syncing Trello cards to Microsoft Excel with Unito enables you to automatically:

  • Populate a spreadsheet with Trello card details, including: title, member, label, due date, status, description footer, checklist, and custom fields.
  • Create new cards in Trello based on Microsoft Excel rows with specified fields.

Put another way, your Microsoft Excel rows will become Trello cards and your columns will become fields.

Here’s what our synced spreadsheet looks like with data populated from our demo Trello cards:

Why connect Trello to Excel with Unito?

This automated two-way flow will help you save time that would otherwise be spent copy-pasting key Trello data to or from your Excel sheet. Beyond that the use cases depend on your role and specific reporting needs.

Import Trello cards to Excel files for any reporting or project management use case

The specific use case we’ll demonstrate in our demo below will show you how to review tasks assigned to freelance contractors in Trello from Excel, but it can be easily modified to suit any use case including reporting or project management.

Unito will sync the fields of your Trello cards, including custom fields, into specific columns in your spreadsheet. So you need to decide in advance which columns should contain your card titles, descriptions, lists, labels, due dates, etc. All of these are considered fields in Unito that can be synced to any column you choose.

Examples of Unito use cases for this Trello Excel integration:

  • Improved project management workflows with a simplified Trello review process in Excel to review due dates, blockers, progress and other Trello activity
  • Build a report for stakeholders
  • Share Trello updates with other teams using a simplified, yet flexible Excel spreadsheet

Unito’s Trello Excel integration enables you to take advantage of the flexibility of JSON and the analytical capabilities of pivot tables to seamlessly sync and analyze Trello data from Excel spreadsheets to drive decision-making and enhance productivity.

By connecting Trello data to Microsoft Excel spreadsheets with Unito, you also eliminate the need to jump back and forth between tabs to double-check your data since everything will be automatically kept up-to-date in real-time. As your team updates cards in Trello, your spreadsheet will update itself through Unito.

Here’s a demo of Unito’s Microsoft Excel integration with Asana

Although Asana’s interface differs from Trello, the same steps and principles apply to syncing tasks to Excel sheets with Unito.

Before we sync Trello cards to Microsoft Excel:

  • Ensure your business has an account in both Trello and Excel with the right permissions to access and modify data in each tool.
  • Read Unito’s integration overviews of Trello and Microsoft Excel to better understand the capabilities and limitations of each.
  • Install the Unito add-in for Microsoft Excel (explained below).
  • Create a header row in your spreadsheet with titles you’ll link to Trello card fields. If you need help getting started, you can use this free Microsoft Excel template we’ve designed.

Add Unito to your Trello Board (optional)

This step is for users who wish to add Unito as a Power-Up to an existing or new board in Trello. You can skip this process if you’ve already installed Unito or you’ve logged in directly to our app. Otherwise, click here if you need help adding Unito as a Trello Power-Up.

Add a header row to your spreadsheet

Unito syncs fields between Trello and Microsoft Excel spreadsheets based on the first row of your spreadsheet. A simple way to do this is to name each column after the fields you’re syncing from Trello (e.g., title, member, description, etc.).

Here is an example of a header row.
In the next step, we’ll show you how to use the Unito add-in to label the first and last columns of your sheet: “UnitoID” and “Last Modified”. The Unito extension does this automatically, or you can create the titles manually.

How to install the Unito add-in to Microsoft Excel

Now, go to www.office.com and open Excel Online.

  1. Then, from your spreadsheet click on File, then Get Add-ins.
  2. In the next screen click STORE and type Unito into the search box.
  3. Click Add and follow the on-screen instructions to install the Unito add-in. 

Three small screenshots showing how to find the Unito Add-In and install it for Microsoft Excel to sync spreadsheets

Follow the on-screen instructions to add Unito to your Microsoft workspace. 

Once the add-in is installed, click Insert the two columns in this sheet.

You’ll see UnitoID and Last Modified. Only columns between those two will sync with Unito. Having them columns in your table header is essential for this integration to function as intended. You can hide them, but don’t delete or modify those columns.

Step 1. Connect Trello and Microsoft Excel with Unito

  1. Now you can either go to the Unito App and click +Create Flow or continue from your Trello workspace once you’ve added the app.
  2. Click Start Here to connect your tools.
  3. Select +Add a tool to this flow in either column and connect Trello. Then click +Choose account to specify the Trello account you want to use.
  4. Pick the Trello board you want to connect to Unito.
  5. Repeat steps 3 and 4 to connect Microsoft Excel.
  6. Click Confirm.
Connect Trello and Microsoft Excel with Unito

When you’re ready, click Confirm.

Step 2: Set a flow direction between Trello and Excel

This step is where you decide whether to import cards into Excel spreadsheets, create Trello cards based on spreadsheet activity or both.

A two-way flow direction will tell Unito to automatically create new Excel rows based on your manually created Trello cards, as well as automatically create new Trello cards based manually added Excel rows. are created by Unito in your Excel file or a specific board in Trello.

Since our demo use case is about building a report in a spreadsheet to review project data, we’ll choose a one-way flow direction from Trello to Excel spreadsheets.

So in this example, Trello is our source tool and Microsoft Excel is the destination for our data import.

Set a Flow Direction between Trello and Microsoft Excel

Click Confirm when you’ve chosen a flow direction. 

Step 3: Set rules to filter data between Trello and Excel

This step determines how rows and/or Trello card data is created by Unito. The default setting will create work items (cards or rows) in your destination tool based on the source selected in step 2. Unito will only sync a new Trello card to Excel unless you remove the “creation date” condition (pictured below). This is a safeguard so you can test your flow before applying it to all your cards or projects.

If you’d like all cards in your chosen Trello board to appear in Excel spreadsheets, simply hit confirm and proceed.

Otherwise, simply Add a new trigger to establish rules for each directional flow. You could apply labels

For this demo, we’ve told the system to create a matching row in Microsoft Excel for every card in our Trello board with a label matching the names of our freelancers.

Set up rules to filter data between Trello and Excel
In this case, only Trello cards from our chosen board with at least one label for Bruce, Cheryl, and Glenda will turn into Excel rows.

NOTE: These triggers are intended to help you keep only the most relevant information in sync to avoid oversharing unnecessary details. You can customize your Trello labels to be even more precise about what kind of data is shared with Excel.

Find out more about setting rules.

Step 4: Customize field mappings to sync rows between Trello and Excel

Fields represent the details of your spreadsheet rows and Trello cards. Since you’re sending field data to a spreadsheet, you’ll only be able to sync numbers or text fields.

First, you’ll be asked whether you want to set up your field mappings from scratch or let Unito do this automatically. Since we have to name all of our fields in Excel you’ll need to choose the manual option.

This image has an empty alt attribute; its file name is Asana-master-project-mappings-method-selection.png
Your fields will be automatically mapped for two-way updates, but you can adjust them as needed. With a one-way sync between fields, only the destination field will update automatically when you make changes in the source field.

Unito requires headings in the first row of your sheet in order to sync properly with any other tool. From there, you can tell the system which column headers to sync with fields in Trello. The first field you’ll have to map is the Trello card title.

In our demo, we’ve given one of our columns the same name to keep things simple. Click Select a field for each tool, and find the appropriate field to map.

Choose field mappings between Trello cards and Excel
In this case our labels represent the names of our freelancers, so we’ve created an “assigned to” column in Excel and synced them. The board name, “freelance assignments” will appear as a “category” in Excel in case we wish to sync other boards later. Our Trello lists are structured by role, which we can use as a “status” in Excel if we’re producing content: copy, design, web implementation, etc.

Note: If you change a column name in a synced spreadsheet, be sure to update your flow’s field mappings in Unito or else your data will stop syncing.

Click Confirm when you’re satisfied with your field mappings to proceed.

Find out more about setting field mappings.

Step 5. Save, close, and launch your connected Trello Excel Integration!

And that’s it! Follow the remaining instructions to complete your flow and it should start syncing momentarily. Congratulations!

If you’ve followed the steps above, your flow will now create a row in Microsoft Excel whenever a new card is added in your connected Trello boards based on the rules we set in Step 3. Here’s what our synced Excel spreadsheet looked like next to our Trello board:

A Trello board synced to an Excel spreadsheet with fields highlighted for the purposes of demonstrating Unito's integration

Frequently Asked Questions about Unito’s Trello Excel Integration

Can Unito integrate Trello with Microsoft Excel?

Yes! Unito can integrate Excel spreadsheets with Trello through our standalone sync platform, or embedded in Trello with our Board Sync Power-Up. Google Sheets users can also try the new Export & Sync Power-Up to sync card data to spreadsheets quickly and efficiently.

How do I connect my Trello boards to Excel for an automated import?

The steps in the guide above outline the specific process for importing Trello data into Excel. But in brief: connect your Trello board and Excel spreadsheet to Unito, choose a one-way flow direction from Trello to Excel, set rules to filter cards based on your existing label system in Trello, make sure your Trello card fields have matching columns in Excel, and launch your Unito flow.

How do I create an Excel spreadsheet from Trello?

Unito can’t create new spreadsheets from Trello, although you can tell Unito to create new Trello boards for your 2-way integrations in the connect tool step. But you’ll have to set up a spreadsheet manually before importing Trello project data automatically with Unito. Just make sure your header row includes the names of each Trello field.

How do I power-up Microsoft Excel in Trello?

Unito’s Board Sync Power-Up enables integrating Microsoft Excel and Trello to link cards with spreadsheet rows for your reporting workflow. Unito also supports Microsoft Excel, Airtable, Notion and many other reporting and database tools.

How do I export all data from Trello to Microsoft Excel?

You can export all data from Trello to Microsoft Excel by setting up one Unito flow per Trello board with the same set of rules to sync them with your spreadsheets. The duplicate flow function makes this process faster and easier.

Can you pull reports from Trello with Unito?

Unito can sync data from Trello cards into Excel spreadsheets to populate existing data, which you can then turn into reports through pivot tables, adding your own formulas, and flexing your spreadsheet muscles! The benefit of Unito is the automatic data transfer from Trello to Excel and real-time 2-way updates as changes are made in either tool.

What can Unito and Trello sync with?

Unito can sync Trello to Microsoft Excel, Outlook, Google Sheets, Asana, Wrike, Airtable, Salesforce, GitHub, GitLab, Azure DevOps, Notion, ClickUp, Google Calendar, Jira and many others. Here’s a full list of Unito’s integrations.

What is JSON and how does it impact my Trello Excel integration with Unito?

JSON (JavaScript Object Notation) is a data interchange format that organizes data in key-value pairs, providing a standardized way to represent and transfer data. In the context of this Trello Excel integration, JSON acts as the bridge, facilitating Unito’s project data sync between boards with Excel spreadsheets.

What’s next after importing Trello data into Excel spreadsheets?