Skip to content
Contacts

Import one object

Last updated: November 2, 2022

Applies to:

All products and plans

You can import files to create and update HubSpot records in bulk. This article explains how to import a single type of record, also known as an object.

When importing a single object, you can create or update the following objects: contacts, companies, deals, tickets, products, and defined custom objects. You can also import to create new calls and tasks.

You can also import and associate records across multiple objects and import activities in HubSpot. If you have data in another system and want to set up a two-way sync, learn how to connect and use HubSpot data sync rather than importing.

Before you get started

Before you start an import, set up your import file and confirm you have all the required fields for your single object import.

Import records

To bulk create or update one object (e.g., contacts):

  • Navigate to your records:
    • Contacts: In your HubSpot account, navigate to Contacts > Contacts.
    • Companies: In your HubSpot account, navigate to Contacts > Companies.
    • Deals: In your HubSpot account, navigate to Sales > Deals.
    • Tickets: In your HubSpot account, navigate to Service > Tickets.
    • Custom objects: In your HubSpot account, navigate to Contacts > [Custom object]. If your account has more than one custom object, hover over Custom Objects, then select the custom object you want to view.
  • In the upper right, click Import.
  • Click Start an import.
  • Select File from computer, then click Next or press Enter.
  • Select One file, then click Next or press Enter.
  • Select One object, then click Next or press Enter.
  • Select the object or activity in your import file.
  • Click choose a file and in the dialog box, then select your import file.
upload-your-files-import
  • If you're importing data in a language other than your default language, click the dropdown menu and select the language of your file's column headers. Selecting the correct language enables HubSpot to better match your column headers to existing default properties. If there is no match in your selected language, HubSpot will search for an English property to match.
  • In the bottom right, click Next or press Enter.
  • On the Map columns in your file to [object] properties screen, HubSpot will map the columns in your file to your selected object's properties based on the header, the header language, and the property name.

mapping-page-comparison

  • You'll see a preview of the first three rows from your spreadsheet in the Preview Information column.
    • If there are no errors detected in the first three rows of a column, there will be a success checkmark in the Mapped column.
    • If certain errors are detected in the first three rows of a column, there will be an exclamation exclamation icon in the Mapped column. Hover over the icon to view the error, and click Fix import errors to learn how you can resolve the error.
  • If any columns do not map to an existing property, click the dropdown menu in the HubSpot Property column. In the dropdown menu, you can opt to do one of the following:
    • To map the column to an existing property, search for and select an existing property.
    • To set up a new custom property, click Create a new property, then set up your new property in the right panel. The data in the column will now be mapped to this new custom property.
  • To skip importing data from an individual row, click the dropdown menu in Import as column, then select Don't import column.
  • To skip importing data from all unmapped columns, select the Don't import data in unmapped columns checkbox in the bottom right.
  • If you're using the Record ID to update or avoid duplicate records, click the dropdown menu in the Import as column, then select Record ID. Existing records will be updated by the import based on the Record ID. If a row in your file doesn't contain a value for Record ID, a new record will be created.

select-record-id-mapping-page

Please note: if you're using an existing contact's secondary email in HubSpot as their unique identifier, the secondary email will not replace the primary email as long as you do not include the Record ID column in your file. If you include both the secondary email and Record ID as columns in your file, the secondary email will replace the primary email when imported.


  • If you’re using Email or Company domain name to deduplicate your contact or company records:
    • To prevent the import from overwriting records’ individual properties, select the Don’t overwrite existing value checkbox if you don’t want to update records that have an existing value for that property.
    • To prevent the import from overwriting all properties included in the import, select the checkbox at the top of the table. 
    • With the checkbox selected, the import will not update that property for any records that have the value. Any new records or existing records with no value for that property will be updated.

dont-overwrite-existing-value-import

  • Once all columns are mapped to a property or set to Don't import column, click Next or press Enter.
  • On the details screen:
    • Enter an Import name.
    • If you're importing contacts:
    • If you're importing a file with a date property, use the Date format dropdown menu to confirm how the date values in your spreadsheet are formatted.
    • If you're importing a file with a number property, use the Number format dropdown menu to confirm which country's number format to use for your data.
  • Once you've set the options for your import, click Finish import in the bottom right.

You can view, analyze, and complete actions with your previous imports. Learn how to create a list, review import errors, or view and delete imported records.

Was this article helpful?
This form is used for documentation feedback only. Learn how to get help with HubSpot.