Troubleshoot import errors
Last updated
Was this helpful?
Last updated
Was this helpful?
When into HubSpot, you may encounter errors. You can download an error file or view the error details to ensure that the or correct issues in Salesforce.
In your HubSpot account, .
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.
The import file contained an invalid value that does not match an existing option in an .
The import will still create or update a record, but the will not contain a value.
Once you've identified the incorrect value by comparing your import file against , update your import file with the correct value and re-import the file or 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., ). 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.
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.
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.
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 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.
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.
Update your import file with the correct deal stage and re-import, or to HubSpot.
The import file contained a value for a 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 in the affected record directly.
Update your import file with the correct value and reimport, or in the affected record directly.
Search for the specific Company Domain Name value in your to find the duplicate companies. or delete one of them, then re-import the file.
The import file contained an 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 again, and update your import file with the correct object ID.
Update your import file by replacing the name of the owner with their email address and re-import the file, or in the affected record directly.
During the import, the checkbox to update existing records using object IDs was selected. However, the 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 .
In your HubSpot account, .