Microsoft Excel
      Back to home
      1. Help Center
      2. Integration Documentation
      3. Microsoft Excel

      Limitations of Unito's Microsoft Excel Integration

      Here's a breakdown of what Unito's Excel integration can't do yet — and a few other considerations.

      Unito's Excel integration is designed with flexibility in mind to help you get the most out of your spreadsheets. You've seen what Unito can do for Excel users, so this article will cover what it can't do — yet.

      What does this article cover?

      Unsupported fields

      • Rich text: That means bold and italic text won't sync over.
      • Attachments: Not currently supported for this integration.
      • Hyperlinks: These are considered rich text, so they're not supported by this integration. Note: If you try to sync a hyperlink from one spreadsheet to another, the link might get deleted in the destination spreadsheet.

      Unsupported mappings

      • Comments: Since Excel doesn't have comments, it's not possible to map comments from another tool into Excel.

      Limitations of Unito's Excel Integration

      • Excel Desktop: Unito doesn't support desktop versions of Excel.
      • Documents: Unito can only sync documents stored in Excel Online. If they're stored anywhere else — like dropbox or box.com — you won't be able to sync them with Unito.
      • Live sync: Due to limitations in Excel’s API, there can be a bit of a delay in sending information over once created in Excel. If your row is taking a bit longer to sync, try manually saving your spreadsheet.
      • Syncing via forms or automations: Unito can only sync rows or updates that are added to work items manually. The platform won't sync data to a spreadsheet via forms or automation rules outside of Unito's. 
      • Syncing workbooks that use desktop-only features: A limitation in Excel's API means that workbooks and spreadsheets that use features only available in the desktop version of Excel can't be synced with Unito. 
      • Custom fields: In order to properly sync custom fields from another tool, they have to be identical to the data in Excel. So if a dropdown in Asana has an option called Editorial, that same option in Excel has to be called Editorial as well.
      • Subtasks: Since Excel spreadsheets don't have a work item hierarchy the way some tools do, you won't be able to sync subtasks and other sub-items (e.g. Trello checklists and Asana subtasks) to Excel.
      • Updating cells in header rows: If you need to update the cells in your header row, you'll have to update the field mappings in Unito to match. Otherwise, your flow will stop syncing any cells in a column with an updated header.
      • Finding your Excel workbook: Unito won't be able to connect to files through your Quick Access folder. Instead, navigate to My Files to select the workbook.

      Note for Wrike Sync Users: Using Safari to access Wrike Sync and connect Excel may result in unexpected behavior or errors. We recommend using an alternative browser such as Chrome or Firefox for the best experience.

      Other Excel integration considerations

      Installation instructions

      To use this integration, you’ll need to install the Unito add-in for Excel. Add-ins let you do more with your spreadsheets, and you need to install this for Unito to work.

      1. Start by going to the top of 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

      Before you start syncing your spreadsheet to other tools, you’ll want to open the Unito add-in through the home menu.

      How to use the Unito add-in for Excel

      Once the Unito add-in is installed, you can access it at any time.

      1. Select Home
      2. Click the ellipsis (three dots) on the right-hand side of the ribbon and select Open Unito.
        1. Note: you'll need to be using a single-line ribbon. If you're using the classic ribbon, expand your window first until you see the Open Unito button.Accessing the Unito add-in for Excel
      3. Now, select Insert Two Columns Into This Sheet.

      Unito will automatically add columns called UnitoID and Last Modified.

      Your synced spreadsheet(s) must include UnitoID as the first column and Last Modified as the last or your data will stop syncing with Unito. You can hide them, but don't modify or delete those columns.

      Additional considerations:

      • Freeze the first row to avoid interrupting your flow. If you change any titles in your header row, you'll need to update your mapped fields in Unito. 

      • Only columns in between UnitoID and Last Modified will sync with Unito. So you can add additional columns if you wish, they just won't be synced. 


      What happens if I manually delete a synced Microsoft Excel row?

      If someone with access to your synced Microsoft Excel spreadsheet chooses to delete a destination row, you'll likely encounter problems with your Unito flow.

      This often goes unnoticed at first if that person later manually re-adds the deleted spreadsheet rows. If that's the case, unfortunately those manually added Excel rows won't be synced to the originals via Unito.

      Got feedback? Submit a Unito feature request to let us know what you'd like to see in the next update to our Excel integration.