Why should I import my existing leads into HubSpot?
When leads are in your HubSpot account you can:
- Re-engage your leads - Segment your leads so you can send them targeted communications via email and lead nurturing workflows, automating the process of turning leads into customers
- Collect lead intelligence - Receive lead revisit alerts, see when your imported leads view your site, and get social media information so you can make more effective sales calls
- Clean up your list - HubSpot automatically de-duplicates your contacts based on the contact's email address, so your contact will only ever appear in a list once. You can then use those lists to create lead nurturing campaigns to determine which of your leads are most qualified to become customers
Importing your existing leads will not only provide your marketing team with a database of all of your existing contacts, but also equip your sales team with unique lead intelligence, as well as help you automate the process of driving leads further along the sales cycle. This action will result in a faster ROI from HubSpot than if you were to delay importing your leads.
Navigate to Contacts
In your HubSpot Marketing Basic, Professional, or Enterprise account, navigate to Contacts > Contacts.
In your HubSpot Marketing Free or Starter account, navigate to Contacts.
ImportClick Import in the upper-right hand corner.
Start a new import
Now you're on the imports dashboard. Click Start a new import in the top right to begin setting up your import.
Select your import type
To import a .csv file, select A .csv file. On the next screen, select Contacts.
Choose the .csv file you wish to import by clicking Select a file or by dragging the file into the window. Once the file is selected, click Upload.
Before uploading your spreadsheet, please keep in mind the following:
- The file must be in .csv file format.
- Each column should correspond to a HubSpot property and must contain a header row to indicate the property into which you are importing data (First Name, Last Name, Email, etc.).
- Unless you are using the HubSpot CRM, only contacts with an email address can be imported, so be sure to include Email as one of the column headers.
- To avoid issues while importing CSV files into HubSpot, please ensure that your CSV file is saved in Unicode (UTF-8) encoding.
- If you'll be importing contacts with a lifecycle stage of Customer, include a column for Close Date so that you can see when they actually became a customer of your company. Without the close date column, they will all show as becoming customers on the day that you import them into HubSpot.
For sample import files, click here.
At this point, you will be able to review the details of your import:
- Import name - the import name will be reflected in the Lists tool.
- Lifecycle stage - choose the Lifecycle Stage you wish to import your new contacts with. Please note Lifecycle stage is not designed to go backwards; for example, a contact who is already marked as a Customer cannot be set back to a Lead. If your import contains contacts in various stages, it is safest to import them as Subscribers and include a Lifecycle Stage column in your csv file to segment them into different stages in HubSpot.
- Import contacts without email addresses - check this box if you'd like to import contacts without a value for email address. If you turn this setting on, it'll still be necessary to include an email address column in your CSV import file.
- Email opt-in status for new contacts - here you can say whether or not these contacts have opted in to your marketing emails. Please note, this is an option when double opt-in is turned on.
- Also add contacts to this list (optional) - choose an existing static list, and the contacts you are importing will be added that existing list
- Default format for date properties - for any date-type properties your are importing, choose the format of the date you are importing so that data is correctly stored in HubSpot
The next step is to map the columns in your .csv file to contact properties in HubSpot. When you're ready, click Next, map your properties.
Map your properties
On the Map columns screen, you'll see the column headers from your .csv file matched up to HubSpot contact properties. HubSpot will import data for any properties that are checked.
You will see sections for Columns with matches and your Columns without matches. HubSpot tries to match the column headers based on name of the property, so if a match is not found for a column of data you wish to import, you can select an existing property from the dropdown menu.
If a matching property does not yet exist in HubSpot, you can create a new property by clicking the dropdown to Choose or create a new property and selecting Create a new property.
Once everything is mapped, click Next, confirm additional options to proceed.
The final step in importing a list is to confirm that your list is valid to respect the privacy of the contacts and to make sure you're not importing a list of people that don't have a current relationship with your business. Simply select the appropriate answers, type your initials in the box, and click on the Finish import button.
You'll then be redirected to the Import status screen where you can see the status of your import. You'll also receive an email when your list has finished importing into HubSpot. You can click on the lists link to see the static list of contacts that was created or updated from the import. If you close this window before you have a chance to navigate to your new list, you can still get there by navigating in HubSpot Marketing to Contacts > Lists.
Repeat this process for as many different .csv files as needed until you're happy with the contacts in your HubSpot contact database.