Here's our full article covering Excel spreadsheet integrations.
If your Excel or CSV sync is failing or showing an error, work through the below checklist, in order.
The cause of sync errors is almost always one of following nine issues with the file itself.
IMPORTANT: After making any of the fixes below, go to the Integrations tab, click Manage on the Excel connection card, and click on the Manage Source tab. Scroll down to click Reset Data in order to run a full sync and ensure that your fixes are fully captured.
1. The id column header isn't exactly right
Each sheet in your workbook must have a column with the header id — lowercase, no spaces, no punctuation — in the first row. ID, Id, Deal ID, and deal_id will all cause the sync to fail.
Fix: Ensure row 1 in each integrated tab has a column labeled id.
2. The id values aren't unique
Every populated row needs a unique value in the id column. Duplicates — or blank IDs in rows that have data in other cells — will reject those rows.
Fix: Sort by the id column and check for duplicates or blanks. Give every deal a unique ID. (Though unique, we strongly recommend against using row number as an ID.)
3. Dates aren't in YYYY-MM-DD format
Any date field must display as YYYY-MM-DD. Formats like 01/15/2025, Jan 15 2025, or a raw number like 45000 (an Excel date serial) will fail.
Fix: Select the date column → right-click → Format Cells → Custom → enter yyyy-mm-dd.
4. Amounts aren't in 0000.00 number format
Any numeric amounts must be in the 0000.00 format. No commas or currency symbols.
Fix: Highlight the whole amount column → right click → Format Cells → Number → set to 2 decimal places. If values are stored as text (left-aligned with a green corner triangle), retype them or use Data → Text to Columns → Finish to convert.
5. There's a formula error somewhere
Any cell containing #DIV/0!, #REF!, #N/A, #VALUE!, #NAME?, or another #-prefixed error will halt the sync.
Fix: Press Ctrl+F, search for #, and replace each broken cell with the correct value or add an IFERROR() formula to return a null value in case of error.
6. Owner emails aren't all lowercase
QuotaPath matches deals to reps by email. Mixed-case addresses like [email protected] won't match an account whose email is stored in lowercase.
Fix: Lowercase every email in your owner column. In an empty cell in a new column, use the =LOWER() formula to change all emails, then copy → paste as values back over the original column. Ensure that your process for entering data is also changed so you don't have to do this transformation each time.
7. A tab has special characters in its name
Tab names can only contain letters, digits, spaces, underscores, and hyphens. Parentheses, slashes, brackets, emoji, ampersands, and similar characters will cause the sync to error.
Fix: Rename tabs like Deals (Q1) to Deals Q1 or Deals_Q1.
8. Two tabs have the same name
Tab names are checked case-insensitively, so Deals and deals count as duplicates and will fail.
Fix: Rename one of the duplicate tabs.
9. The data is in a pivot table or Excel Table
QuotaPath needs a flat range of rows and columns. Pivot tables and "Format as Table" tables aren't supported.
Fix:
For pivot tables: copy the underlying data and paste it onto a new tab as values, then sync that tab. Or deselect that tab from your integrated Excel objects in QuotaPath. This can be done on the Objects tab after you click Manage on your Excel connection card on the Integrations page.
For Excel Tables: click anywhere in the table → Table Design → Convert to Range.
Still stuck?
If you've worked through all nine checks and your sync still shows errors, reach out to Support through the support drop-down in the top right of your QuotaPath workspace. Please include:
Which tab(s) you're trying to sync
The exact error message shown in QuotaPath
A copy of the file or the accessible link
We'll be happy to help!