Skip to content
Contacts

Troubleshoot import errors

Last updated: May 14, 2021

Applies to:

All products and plans

When importing records into HubSpot, you may encounter errors. Below, learn how to download an error file, view error details, and correct issues in your import file or Salesforce.

Before starting an import or fixing a file with errors, learn the relevant terms and requirements for importing into HubSpot.

Download an error file

  • 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 More 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 affected object under Object type, the reason for the error under Reason, and the details of the object with the error in the subsequent columns.

Resolve an import file error

The following is an alphabetized list of error codes with details for the error and possible steps for resolution. In some cases, records with errors will be imported and can be corrected either in HubSpot, or by correcting the import file and reimporting. In other cases, records will not import and the import file will need to be corrected before reimporting.

Please note: the error codes in your file will contain capital letters and underscore characters, but are listed in normal text within this article. For example, the error will appear as AMBIGUOUS_ENUMERATION_OPTION in the file, but you will find it as Ambiguous enumeration option in the table below.

Error code What the error means Steps to resolve the error

 

Ambiguous enumeration option

The same record matches more than one of the existing options defined for an enumeration property. This applies to multi-select, dropdown select, radio select, and checkbox type properties.

The affected records were imported, but the enumeration property does not contain a value.

 
Identify the incorrect value by comparing your import file against the property in HubSpot. Update the value in your import file to match only one existing option, then re-import the file. You can also manually update the property value in the affected records.
 
If your records should match multiple options, learn how to format your file to correctly import data to multiple checkbox properties.

 

Could not find owner

The import file contains a record owner that does not match a user in HubSpot.

The affected records were imported, but the Owner field does not contain a value.

Update the data in the Owner column of your import file to include the first and last name or email of a user in your account. If the person you want to assign the record to is not yet a user in the account, add them as a user, then re-import with their name or email as it appears in the account.

 

Could not parse date

The import file contains a date value that does not match the format you selected during the import process.

The affected records were imported, but the date property does not contain a value.

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

 

Could not parse number

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

The affected records were imported, but the number property does not contain a value.

Update your import file with the correct numerical value and re-import, or manually update the property value in the affected records.

 

Could not parse row

The import file contains a row with data that cannot be processed.

If it's a required property, the records were not imported. If it's not a required property, the records were imported, but that property does not contain a value.

Verify that your data value matches the correct format for the property you are importing, fix any mistakes, then re-import the file. You can also manually update the property value in the affected records.

 

Could not parse term

The import file contains a value for a time period that does not match an accepted term format.

The affected records were still imported, but the term property does not contain a value. 

Update the term values in your file to be either a whole number of months or in ISO8601 Duration Format (e.g. a period of time of three years, six months, four days would be P3Y6M4D), then re-import the file. You can also manually update the property value in the affected records.

 

Duplicate alternate ID

The same alternate ID was used multiple times within your files.

Your data was imported but there may be duplicates of the same record in HubSpot. If you were trying to associate, your records were not associated.

 
Choose a different column header to act as your alternate ID, then re-import the files.
  • To avoid duplicates, use Email for contacts, Company domain name for companies, or [Object] ID for any object. 
  • To associate records, use Email, Company domain name, [Object] ID, or choose a one-to-many property where one value is unique for the many records associated with it (e.g. Company name as the one, which will be associated with many contacts who work at the same company.) Refer to the sample import files for further guidance.
If you have multiple companies that use the same domain, consider manually creating parent and child companies.

 

Duplicate association ID

The association ID you chose to associate your records is not unique.

The records were imported but were not associated.

Choose a different column header to act as the common column between your two files. For best results, choose a one-to-many property where one value is unique for the many records associated with it (e.g. Company name as the one, which will be associated with many contacts who work at the same company.) Refer to the sample import files for further guidance. Once you’ve selected a new association ID, re-import your files.

 

Duplicate object ID

The same [object] ID was used multiple times within your files.

The affected records were not updated or associated in HubSpot.

Update your import file so that there is only one row with that [object] ID. Keep the row with the most up-to-date information that you want included in HubSpot. Once you’ve removed duplicates, re-import the files.

 

Duplicate row content

HubSpot detected that the import file contains duplicate records.

The import did not create a new record.

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

 

Duplicate unique property value

The same unique value was used multiple times within your files.

Your data was imported but there may be duplicates of the same record in HubSpot. If you were trying to associate, your records were not associated.

 
Choose a different column header to act as your unique value, then re-import the files.
  • To avoid duplicates, use Email for contacts, Company domain name for companies, or [Object] ID for any object. 
  • To associate records, use Email, Company domain name, [Object] ID, or choose a one-to-many property where one value is unique for the many records associated with it (e.g. Company name as the one, which will be associated with many contacts who work at the same company.) Refer to the sample import files for further guidance. 
If you have multiple companies that use the same domain, consider manually creating parent and child companies.

 

Failed to create association

HubSpot is unable to associate your records in their current format.

The records were imported but were not associated.

Verify that you have met the file requirements for associating your records. If importing in one file, you may need to add a unique identifier for each object. If importing in two files, you may need to select a different common column to properly associate. Make the changes to your files and re-import, or manually associate your records.

 

Failed to opt out contact

HubSpot was unable to opt-out certain contacts in the opt-out file. 

Confirm you have an Email value for all contacts on your opt-out list. If any are missing emails, add their email address to the file to properly opt-out the contact from receiving emails. You can also manually create contacts and opt them out from the contact record.

 

Failed to process object with empty property values

Your file contains empty values for multiple columns and HubSpot was unable to process the record.

Your data in that row was not imported.

Fill in the missing property values of your import file, then re-import the file.

 

Failed validation of Email, Deal/Ticket stage, or Deal/Ticket pipeline

 
The import file contains an email address that does not conform to the format of a typical email address (e.g., name@domain.com) or a value for the Deal Stage, Deal Pipeline, Ticket Status, or Ticket Pipeline property that does not match an existing stage, status, or pipeline name in HubSpot.
 
The import did not create or update the records.
 
 
For contacts, update your import file with the correct email, then re-import the file.
 
For deals or tickets, update your import file with the correct stage, status, and pipeline name, or add the custom deal stage or ticket status to HubSpot. Once you’re done, re-import the file.

 

File not found

The file you selected was not found.

Your data was not imported.

Verify that you have saved your file to your computer and that it is the correct file type. Once you’ve done that, re-upload the file.

 

GDPR blacklisted email

The import file contains one or more emails that have been blocked from communication due to GDPR.

These contacts were not imported.

The import file will still import your other contacts, but you can not add the blocked contacts via import. You can add these contacts manually, but they will be automatically opted-out of marketing communication.

 

Incorrect number of columns

The import file contains at least one column without a header.

The data in columns without headers was not imported.

Confirm whether or not the data in the columns should be imported, add appropriate headers or remove the columns, then re-import the file.

 

Invalid alternate ID

The import file contains an invalid value imported as an email address, domain name, or [object] ID. 

The import did not create or update the record.

Update your import file with the correct email, domain name, or [object] ID value, then re-import the file.

 

Invalid association identifier

The import file does not contain a proper unique value to associate your records.

The data was imported, but the resulting records were not associated in HubSpot.

Update your import file to include a valid association identifier (e.g. Email for contacts, Company domain name for companies, or [object] IDs), then re-import the file. Learn how to set up your files properly to import and associate multiple objects.

 

Invalid enumeration option

The import file contains a value that does not match an existing option in an enumeration property. This applies to multi-select, dropdown select, radio select, and checkbox type properties.

The affected records were still imported, but the enumeration property does not contain a value.

Identify the incorrect value by comparing your import file against the property in HubSpot. You can choose to update the value in your import file to match an existing option, or add the value as a custom option to your property. Once you’re done, re-import the file or manually update the property value in the affected records.

 

Invalid file type

The import file is the incorrect file type for importing into HubSpot.

Your data was not imported.

Convert your file to a .csv, .xls, or .xlsx file, then re-import. Review additional file requirements for importing into HubSpot.

 

Invalid number size

The import file contains a numerical value that is too small or too big.

The affected rows were imported, but the number property does not contain a value.

Confirm the format requirements of your specific property or the property type, update your file to match the correct format, then re-import. You can also manually update the property value in the affected records.

 

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.

The records were not imported.

Ensure that the [object] IDs are correct. You may need to export your existing records to get the correct object IDs. If you're not updating or associating existing objects in HubSpot, do not select the checkbox during the import process.

 

Invalid required property

A required property in the import file contains an invalid value.

The data in that row was not imported.

Confirm the format requirements of your specific property or the property type, update your file to match the correct format, then re-import.

 

Invalid sheet count

The import file contains more than one sheet.

Your data was not imported.

Remove any additional sheets from your import file, then re-import. Review additional file requirements for importing into HubSpot.

Invalid spreadsheet

The import file is not a valid spreadsheet file.

Your data was not imported.

Convert your file to a .csv, .xls, or .xlsx file, then re-import. Review additional file requirements for importing into HubSpot.

 

Limit exceeded

HubSpot is unable to create the record due to a limit. Your file may be too large or you may have reached an account limit, such as reaching your max number of lists

Your data was not imported.

Confirm that your file is smaller than 150 MB, and has less than 250,000 rows and 1,000 columns. If the file is larger, separate your data into multiple files, then re-import. If the file is the correct size, learn more about your HubSpot subscription and its limitations. 

 

Multiple companies with this domain

The import file contains a Company domain name value that matches multiple companies in your HubSpot account.

The import did not update the company record.

Search for the specific Company domain name value in your companies home to find the duplicate domains. Merge the company records or delete one of them, then re-import the file.

 

Multiple owners found

The import file contains an Owner value that matches more than one user in the account. 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 affected records were imported, but the Owner property does not contain a value.

Replace the name of the owner with their email address in your import file, then re-import the file. You can also manually update the Owner property value in the affected records.

 

No object ID from association identifier

During the import, the checkbox to update existing records using [object] IDs was selected. However, the required object IDs were not included in the files.

The data was imported, but the resulting records are not associated in HubSpot.

Update your import file to include the object IDs, then re-import the file. You may need to export your existing records to get the correct object IDs. Learn how to set up your files properly to import and associate multiple objects.

 

Outside valid term range

The import file contains a value for a time period that is outside of the accepted term range.

The affected records were imported, but the term property does not contain a value. 

Update the term values in your file to be within the accepted time range (a whole number greater than or equal to 1 month), then re-import the file. You can also manually update the property value in the affected records.

 

Outside valid time range

The import file contains a value for a time period that is outside of the accepted time range.

The affected records were imported, but the time range property does not contain a value. 

Update the time range values in your file to be within the accepted time range (less than 1000 years), then re-import the file. You can also manually update the property value in the affected records.

 

Property definition not found

The import file contains a column header that does not match a HubSpot property.

The data in that column was not imported.

During the import, match your columns correctly by selecting an existing property or by creating a new property on the Map columns in your file to [object] properties page. You can also choose to skip importing unmatched columns.

 

Property value not found

The import file is missing a value for a required property.

The data in that row was not imported.

Update your import file to include a value for the required property, then re-import the file.

 

Unknown bad request

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

The import did not update the record, as the data does not match any existing record.

Verify you have the correct [object] ID. If you find an incorrect ID, update your import file with the correct [object] ID, then re-import the file.

 

Unknown error

HubSpot is unable to process the file due to an unknown error.

Your data was not imported.

Confirm that your file meets all requirements. Try to re-import after clearing your browser cache or using another browser. If you are still seeing an error, post on the Community (all users) or contact the support team (Starter, Professional, and Enterprise account only).

Salesforce import errors

salesforce-import-errors-view-details

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. 

salesforce-import-error-details