When importing records into HubSpot, you may encounter errors. You can download an error file or view the error details to ensure that the import file was set up correctly or correct issues in Salesforce.
The following is a list of error codes, details for the error, and possible steps for resolution.
The import file contained an invalid value that does not match an existing option in an enumeration property.
The import will still create or update a record, but the enumeration property will not contain a value.
Once you've identified the incorrect value by comparing your import file against the property in HubSpot, update your import file with the correct value and re-import the file or update the property value in the affected record directly.
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.
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 re-import, or add the deal stage to HubSpot.
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, or update the property value in the affected record directly.
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, or update the property value in the affected record directly.
HubSpot detected that 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 import file contained data appears in a column without a header. The data under columns without headers will not be imported.
Once you confirmed that the data in the column should be imported, add an appropriate header to the import file and re-import.
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 specific Company Domain Name value in your companies home to find the duplicate companies. Merge the company records or delete one of them, then re-import the file.
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 import file contained an invalid record ID that does not match any existing record in your HubSpot account. The import cannot update the record, as the data does not match any existing record.
Check the ID again, and update your import file with the correct object ID.
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.
During the import, the checkbox to update existing records using object IDs was selected. However, the object ID listed in the file did not match an existing ID in HubSpot.
Ensure that the object IDs are correct. If you're not updating existing objects in HubSpot, do not select the checkbox during the import process.
The right panel will show a description of the error, along with resolution information. You'll also see a list of records affected by the error. Click a record link to access the record and make changes as needed.