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.
File import errors
- In your HubSpot account, navigate to your contacts, companies, deals, tickets, or products.
- In the upper right, click Import.
- Hover over a file import with 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.
Invalid Enumeration Option
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. When the file has been re-imported the record will be updated with any new values.
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 re-import, or 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, 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, or update the property value in the affected record directly.
Duplicate Row content
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.
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.
Once you confirmed that the data in the column should be imported, add an appropriate header to the import file and re-import.
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 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.
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.
Unknown bad request
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.
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.
Invalid Object ID
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.
Salesforce import errors
- In your HubSpot account, navigate to your contacts, companies, deals, tickets, or products.
- In the upper right, click Import.
- Hover over the Salesforce import that has errors, then click View import errors.
- In the Import Errors table, hover over an error and click View details to see more information.
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.