Contacts

Troubleshoot import errors

Last updated: April 9, 2019

When importing objects, you may encounter certain errors. You should ensure that the import file was set up correctly, including the import considerations, and that the import process was performed correctly, before following the steps below.

  • In your HubSpot account, navigate to your contacts, companies, deals, tickets, or products.
  • In the upper right, click Import.
  • Hover over the import that has errors and click the Actions dropdown menu, then select Download error file.
  • Extract the CSV file from the downloaded zip file, then open the CSV file.
  • In the file, identify the error code under the Error code header, the reason for the error under the Reason column, and the details of the object with the error in the subsequent columns.

The following is a list of error codes, details for the error, and possible steps for resolution.

Error code Details Resolution

Invalid Enumeration Option

The import file contained an invalid value that does not match an existing option in the enumeration property.

The import will still create or update a record, but the enumeration property will not contain a value.

Update your import file with the correct value and re-import the file, or update the property value in the affected record directly.

Failed Validation (Invalid Email)

The import file contained an email address that did not conform to the format of a typical email address (e.g., name@domain.com).

The import will not create a record or update an existing record. 

Update your import file with the correct email value, and re-import the file.

Failed Validation (Deal Stage or Pipeline)

The import file contained an invalid value for the Deal Stage property that does not match an existing deal stage in HubSpot.

The import will not create a record or update an existing record.

Update your import file with the correct deal stage, and then re-import the file.

Alternatively, add the deal stage to HubSpot.

Could Not Parse Number

The import file contained a value for a number property with non-numeric characters.

The import can still create or update a record, but the number property will not contain a value.

Update your import file with the correct value and re-import the file, or update the property value in the affected record directly.

Could Not Parse Date

The import file contained date values that did not match the format you selected during the import process.

The import can still create or update a record, but the date property will not contain a value.

Update your import file with the correct value and reimport the file, or update the property value in the affected record directly.

Duplicate Row content

The import file contained duplicate objects.

The import will not create a new object.

Remove the duplicate in the import file, and re-import the file.

Header and row sizes don’t match

The import file contained data appears in a column without a header.

The data under columns without headers will not be imported.

Check if such data should be imported. If so, add an appropriate header and re-import the file.

Multiple companies with this domain

The import file contained a Company Domain Name  value that matches multiple companies in your HubSpot account.

The import will not update the company record.

Search for the Company Domain Name value in your companies dashboard to find the duplicate companies.

Merge these company records, or delete one of them, before re-importing your file.

Invalid Alternate ID

The import file contained an invalid value imported as an email address.

The import will not create a new record or update an existing record.

Update your import file with the correct email value, and re-import the file.

Unknown bad request

The import file contained an invalid object ID that does not match any existing object in your HubSpot account.

The import cannot update the object, as the data does not match any existing object.

Update your import file with the correct object ID.

Multiple owners found

The import file contained an Owner value that matches more than one user. This usually occurs for names (e.g., there are two John Doe users in your HubSpot account, and the import file contained the name "John Doe").

The import can create a new record, but the Owner property will be left blank.

Update your import file by replacing the name of the owner with their email address and re-import the file, or update the property value in the affected record directly.

Free Inbound Marketing Training Learn inbound marketing techniques that range from creating content, using  social promotion, converting and nurturing leads, and all the way to marketing  to your customers. Start the course