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 Microsoft Excel fields
- Other Microsoft Excel limitations
- Other Excel integration considerations
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.
Other Microsoft Excel limitations
- Comments: Since Excel doesn't have comments, it's not possible to map comments from another tool into Excel.
- 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.
- Connecting Excel without a Business plan: Due to a limitation with Microsoft's API, you may experience issues trying to sync your Excel workbooks if you don't have a Microsoft Business plan.
- Syncing workbooks stored on Home plans: Due to a limitation with Microsoft's API, you might be unable to sync Excel workbooks stored in OneDrive if you use a Home Microsoft 365 plan.
Other Excel integration considerations
Syncing Excel and Wrike
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.
Manually deleting a synced 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, those manually added Excel rows won't be synced to the originals via Unito.