Skip to content
Contacts

Import one object

Last updated: June 16, 2021

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:

  • Standard CRM objects: contacts, companies, deals, tickets, and defined custom objects.
  • HubSpot-defined objects: products.

You can also import and associate records across multiple objects in HubSpot. If you have data in another system and want to set up a two-way sync, learn how to connect PieSync with HubSpot 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):

  • Click Start an import.
  • Select File from computer, then click Next.
  • Select One file, then click Next.
  • Select One object, then click Next.
  • Select the object in your import file.
  • On the Map columns in your file to [object] properties screen, HubSpot will match the columns in your file to your selected object's properties based on the header and the property name. You'll see a preview of the property values from your spreadsheet in the Preview Information column.
  • If any columns do not match an existing property, click the corresponding dropdown menu in the HubSpot Property column. You can opt to do one of the following:
search-property-import
    • To map the column to an existing property, 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 this column, select Don't import column. To skip importing data from all unmatched columns, select the Don't import data in unmatched columns checkbox in the bottom right.
  • 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 override 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.
  • On the details screen, enter an Import name.
    • 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.
  • 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.

New call-to-action