HubSpot Import Errors

How to fix it

Try these in order — the most common fix is first.

1. 1. Open the error details

   Copy steps
   1. On the Map columns screen, hover the row and click the errors link
   2. See affected column and rows
   3. Use Edit column values to correct a value; it applies to all matching rows, even past row 1,000
   Did this fix it? Yes No

2. 2. Fix owner and property errors

   Copy steps
   1. Could not find owner: use the full name or email as in HubSpot, or add/reactivate the user
   2. Multiple owners found: use the owner's email
   3. Property definition not found: map to an existing property, create one while mapping, or skip the column
   4. Invalid enumeration option: match the label or internal value, or add a custom option
   Did this fix it? Yes No

3. 3. Fix format errors

   Copy steps
   1. Could not parse date: check the date format dropdown (day/month order)
   2. Could not parse number: strip currency symbols or text
   3. Row data too large: shorten cells below 1 MB
   4. Save as .csv, .xls or .xlsx with a single sheet and a header on every column
   Did this fix it? Yes No

4. 4. Fix duplicate and association errors

   Copy steps
   1. Duplicate unique value: remove duplicates or choose a different Property to use to find existing objects
   2. Multiple companies with this domain: merge duplicates or import by Record ID
   3. Association errors: add a valid unique key such as Email, Company domain name or Record ID
   Did this fix it? Yes No

5. 5. Unknown error

   Copy steps
   1. Try another browser or clear the cache
   2. Confirm the file meets requirements
   3. If it persists, collect a HAR file and contact Support
   Did this fix it? Yes No

Symptoms

The import fails or skips rows with messages such as 'Could not find owner', 'Property definition not found' or 'Could not parse date'.

Why it happens

• Owner name or email doesn't match an active user
• Column header doesn't match a property
• Dropdown values don't match an option
• Date or number format differs from the selected format
• Duplicate unique values or several companies with one domain
• File has multiple sheets, blank headers or cells over 1 MB

This guide also covers

• hubspot import error
• hubspot could not find owner
• hubspot import contacts failed
• hubspot import property definition not found

The same problem in other apps

All not loading, error messages & connection guides →

• Pipedrive Import Errors and Skipped Rows (Pipedrive)
• Salesforce Too Many SOQL Queries: 101 Error (Salesforce)

Other HubSpot errors

• How to Cancel HubSpot Subscription
• HubSpot Marketing Contacts Overage Charge
• HubSpot Workflow Not Enrolling Contacts
• HubSpot Emails Going to Spam
• HubSpot Gmail or Outlook Inbox Disconnected
• HubSpot Form Not Showing on Website
• HubSpot Salesforce Sync Errors
• HubSpot Sequence Error: Contact Can't Be Enrolled