Are you running into issues while importing contacts into HubSpot? You've come to the right place.
HubSpot success starts with clean data. But that's sometimes easier said than done, especially when you have dozens, hundreds or thousands of contacts to process.
Use this guide to identify and troubleshoot import errors when adding contacts to HubSpot. We've divided our guide into a few of the most common errors you'll run across. Just click to pinpoint and pluck out the pesky problem like a pro.
Skip to a section:
➤ Pro Tip: There are a lot of possible import errors. Copy the exact name of the error you're seeing in HubSpot and Ctrl-F (or Command-F for Mac users) to find it on this page without scrolling.
There are errors that appear most often during the import stage - when you're on the "map" section of the import screen. They are any of the following:
For all of these errors, the fix is the same: look for an exclamation mark icon next to the error, and hover over it until a box appears. Then select "Fix import errors" and you'll be walked through how to troubleshoot the specific error.
These errors indicate an alignment issue between the import file (like a spreadsheet) and properties in the HubSpot database. In most cases, this is a result of a spelling error or a blank cell.
There are a few additional "invalid" errors that you might encounter after the mapping stage, which are any of the following.
What it is: The import file contains an invalid value imported as an email address, domain name, or record ID. The import did not create or update the record.
How to fix it: Update your import file with the correct email, domain name, or record ID value, then re-import the file.
What it is: 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.
How to fix it: Update your import file to include a valid association identifier (e.g. Email for contacts, Company domain name for companies, or record IDs), then re-import the file. Learn how to set up your files properly to import and associate multiple objects.
What it is: 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.
How to fix it: 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.
What it is: A required property in the import file contains an invalid value. The data in that row was not imported.
How to fix it: 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.
Similar to "could not" errors, "failed to" errors often point to missing or misspelled data.
What it is: HubSpot is unable to associate your records in their current format. The records were imported but were not associated.
How to fix it: 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.
What it is: HubSpot was unable to opt-out certain contacts in the opt-out file.
How to fix it: 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.
What it is: Your file contains empty values for multiple columns and HubSpot was unable to process the record. Your data in that row was not imported.
How to fix it: Fill in the missing property values of your import file, then re-import the file.
What it is: 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.
How to fix it: 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.
Most duplicate and multiple errors need to be fixed in order to avoid incorrect associations and messy data.
What it is: 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.
How to fix it: Choose a different column header to act as your alternate ID, then re-import the files.
What it is: The association ID you chose to associate your records is not unique.
How to fix it: 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.
What it is: The same record ID was used multiple times within your files. The affected records were not updated or associated in HubSpot.
How to fix it: Update your import file so that there is only one row with that record 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.
What it is: HubSpot detected that the import file contains duplicate records. The import did not create a new record.
How to fix it: Remove the duplicate in your import file and re-import.
What it is: 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.
How to fix it: Choose a different column header to act as your unique value, then re-import the files.
What it is: 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.
How to fix it: CSearch 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.
What it is: 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.
How to fix it: 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.
Some errors may need to be fixed at the file level and will be flagged during the import phase.
What it is: The file you selected was not found. Your data was not imported.
How to fix it: 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.
What it is: The import file contains at least one column without a header. The data in columns without headers was not imported.
How to fix it: Confirm whether or not the data in the columns should be imported, add appropriate headers or remove the columns, then re-import the file.
What it is: The import file is the incorrect file type for importing into HubSpot. Your data was not imported.
How to fix it: Convert your file to a .csv, .xls, or .xlsx file, then re-import. Review additional file requirements for importing into HubSpot.
What it is: The import file contains more than one sheet. Your data was not imported.
How to fix it: Remove any additional sheets from your import file, then re-import. Review additional file requirements for importing into HubSpot.
What it is: The import file is not a valid spreadsheet file. Your data was not imported.
How to fix it: Convert your file to a .csv, .xls, or .xlsx file, then re-import. Review additional file requirements for importing into HubSpot.
What it is: 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.
How to fix it: Confirm that your file is smaller than 150 MB, 1,000 columns, and 1,048,576 rows. The number of rows that you can import each day is also limited by your account's subscriptions:
These limits apply to a rolling 24-hour period and do not reset at a specific time of day. If the file is larger, separate your data into multiple files. Then, re-import over multiple days. If the file is the correct size, learn more about your HubSpot subscription and its limitations.
What it is: 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.
How to fix it: 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.
What it is: 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.
How to fix it: 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.
What it is: The import file contains a column header that does not match a HubSpot property. The data in that column was not imported.
How to fix it: 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.
What it is: The import file is missing a value for a required property. The data in that row was not imported.
How to fix it: Update your import file to include a value for the required property, then re-import the file.
What it is: The import file contains a value that doesn't meet the requirements for a property's validation rules (e.g., the value contains special characters, is too long, too short, etc). The affected records were imported, but the property doesn't contain a value.
How to fix it: View or edit the property's validation rules in your settings. Update your import file to include a value that follows the property's rules, then re-import the file. You can also manually update the property value in the affected records.
What it is: During the import, the checkbox to update existing records using record IDs was selected. However, the required record IDs were not included in the files. The data was imported, but the resulting records are not associated in HubSpot.
How to fix it: Update your import file to include the record IDs, then re-import the file. You may need to export your existing records to get the correct record IDs. Learn how to set up your files properly to import and associate multiple objects.
What it is: 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.
You may also see this error if the value in your file is the property option's label rather than its internal value. This applies to enumeration property options where the label is different than the internal value.
The affected records were imported, but the enumeration property does not contain a value.
How to fix it: 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, or the option's internal value if the label is different from its internal value. Once you've updated the value, 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.
What it is: 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.
How to fix it: Verify you have the correct record ID. If you find an incorrect ID, update your import file with the correct record ID, then re-import the file.
What it is: The import file contains one or more emails that have been blocked from communication due to GDPR. These contacts were not imported.
How to fix it: 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.
What it is: HubSpot is unable to process the file due to an unknown error. Your data was not imported.
How to fix it: 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).
If you're importing from Salesforce, import errors will display differently from other import errors.
This covers all of the import errors you may run into. Of course - you could also bypass the headache and have a HubSpot expert do onboarding for you.
Plus, we are the only agency in Minnesota with a Platform Enablement Accreditation from HubSpot - sounds fancy, but it means we're top-notch in making HubSpot work within your business.
BizzyWeb is a Minneapolis-based digital marketing and web design agency that helps companies get the high-quality leads they need to grow and thrive. Our tactics include inbound marketing, SEO, advertising, web design, content creation and sales automation. We are an accredited HubSpot Platinum Partner and we offer full-service HubSpot onboarding, enablement and strategy for new and current users.
Source: Review and troubleshoot import errors - Hubspot Knowledge Base