Import contacts, companies, deals, tickets, products, or notes
Import files to create or update contacts, companies, deals, tickets, or products in HubSpot. You can also import and associate notes to objects.
Please note: in order to comply with Google's OAuth app requirements, the ability to import contacts directly from Gmail was removed on May 1, 2019. You can use PieSync to import contacts from Gmail into HubSpot.
You can import objects to HubSpot in the following ways:
Please note: to import notes and associate them to an object's record, either import notes in a single file with multiple object types or associate notes to an object by importing two files. You cannot import a single file with only notes as they have to be associated to a new or existing object.
Before you get started
Before you start an import, learn how to set up your import file to confirm you have all the required fields for your import type.
Import one file with one object type
Follow these steps when your file contains only one object type (e.g., the file contains only contacts).
Ensure that your import file is already set up correctly.
In your HubSpot account, navigate to your contacts, companies, deals, tickets, or products.
In the upper right, click Import.
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 type in your import file.
Click choose a file and in the dialog box, select your import file. Select the checkbox if you're using the object ID to deduplicate your contacts, companies, deals, tickets, or products. In the bottom right, click Next.
On the Map columns in your file to contact properties screen, HubSpot will match the columns in your file to your selected object type'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. You can do opt to do one of the following:
Select an existing property to map the column to.
Click Create a new property to set up a new custom property in the right panel. The data in the column will now be mapped to this new custom property.
Select Don't import column to skip importing this column from your spreadsheet.
If you're not intending to import any data in the unmatched columns, you can select the Don't import data in unmatched columns checkbox to skip these columns.
Once all columns are mapped or you've opted not to import data in the unmatched columns, click Next.
On the details screen, enter an Import name.
If you're importing a file with only contacts, select the Create a list of contacts from this import checkbox to automatically create a list when the contacts are imported.
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've turned on General Data Protection Regulation (GDPR) functionality in your account, use the Set the legal basis for processing a contact's data dropdown menu to select a lawful basis of processing.
Once you've set the options for your import, click Finish import in the bottom right.
You can view, analyze, and create lists with your previous imports.
Import one file with multiple object types
Follow these steps when your single file contains more than one type of object (e.g., the file contains contacts, deals and notes). Currently, you cannot import products through this method.
Ensure that your import file is already set up correctly.
In your HubSpot account, navigate to your contacts, companies, deals, or tickets.
In the upper right, click Import.
Click Start an import.
Select File from computer, then in the bottom right, click Next.
Select One file, and click Next.
Select Multiple objects, and click Next.
Select the types of objects in your import file. Then, click Next.
Click choose a file, then select your import file. If you're using the object ID to deduplicate your contact, company, deal, or ticket records, select the Update existing records using “Object ID” exported from HubSpot checkbox.
Click Next.
On the Map columns in your file to contact properties screen, HubSpot will automatically match the columns in your file to properties in your selected objects. 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:
If you want to match the column to a new custom property, select the object then click Create a new property. In the right panel, set up your custom property.
If you don't want to import this column, select Don't import column.
If you don't want to import any columns without a matching property, select the Don't import data in unmatched columns checkbox.
Please note: when importing a note, there are two fields you must include in the import file: activity date and note body. The values for these fields are not stored in a property, but they are included in the note engagement on the record's timeline.
After you've mapped all of the columns from your file, 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.
If you've turned on General Data Protection Regulation (GDPR) functionality in your account and your import includes contact records, use the Set the legal basis for processing a contact's data dropdown menu to select a lawful basis of processing.
Once you've set the options for your import, click Finish import in the bottom right.
You can view, analyze, and create lists with your previous imports.
Import two files for association
Follow these steps when you have your data in two different files and would like to associate the objects between the files.
Please note: products currently cannot be associated through imports.
Ensure that your import files are set up correctly, and you've included a column with the same header in both files for association.
In your HubSpot account, navigate to contacts, companies, deals, or tickets. If you want to import and associate notes, navigate to the object you’ll be adding notes to.
Click Import.
Click Start an import.
Select File from computer, then click Next.
Select Multiple objects with associations, then click Next.
Select the two objects or an object and notes to associate via import, then click Next.
For each object type, click choose a file, then select your import file. If you're using object ID to deduplicate either or both of your files, select the corresponding Update existing [object] using "[Object] ID" exported from HubSpot checkbox.
Click Next.
Specify the common column you're using in the files to associate your data:
To specify the column header for the common field in both of your spreadsheets, click the Common column headers found in your files dropdown menu.
The common column is the unique key that associates objects, but only belongs to one object. To specify which object has a unique value for the common column, click the Which object is [header] the unique key for? dropdown menu and select the object. This matters when there are many-to-one associations (e.g., many deals associated to one contact).
Click Next.
Click Next.
On the Map columns in your file to contact properties screen, HubSpot will automatically match the columns in your file to the selected objects' properties in HubSpot. 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:
If you want to map the column to an existing property, select an existing property.
If you want to set up a new custom property, click Create a new property.
If you want to exclude a column from your spreadsheet from importing, select Don't import column.
If you want to skip any columns without a match, select the Don't import data in unmatched columns checkbox to skip any columns without a match.
Click Next, then map the columns in the second spreadsheet.
Once you've mapped the columns in both of your files to properties in HubSpot, click Next.
Please note: if you're importing contacts or companies with the object ID the Email or Company domain name property will not be mapped. It is not required that you import the column you've used as the unique identifier for your records.
On the Details screen, enter an import name.
If you've turned on General Data Protection Regulation (GDPR) functionality in your account and you're importing contacts, use the Set the legal basis for processing a contact's data dropdown menu to select a lawful basis of processing.
Click Finish import.
You can view, analyze, and create lists with your previous imports.
Last updated