App Tutorial

Easy Steps to Import Contacts into HubSpot CRM

Jason Gong
App automation expert
Apps used
April 15, 2024

Importing contacts into HubSpot is simple and enhances your CRM's effectiveness. Follow these steps for a smooth import:

  • Prepare your import files correctly, ensuring they meet HubSpot's format requirements.
  • Navigate to HubSpot's Import & Export settings, select your file, and specify your import preferences.
  • Map your file columns to the corresponding HubSpot properties, adjusting mappings as needed.

Automate your contact import process with Bardeen to save time and ensure accuracy. Learn more at

How to Import Contacts into HubSpot

Importing contacts into HubSpot is a straightforward process that can significantly enhance your CRM's effectiveness. Whether you're migrating from another CRM or ESP, or simply updating your database, HubSpot provides a flexible import tool to help you add or update data in bulk. This guide will walk you through the steps to import contacts into HubSpot, including preparation of your import files, the import process itself, and some tips for importing contacts from Excel.

Alternatively, you can automate the contact import process into HubSpot using Bardeen. This can save you time and ensure accuracy. Download Bardeen to streamline your workflow.

Preparing Your Import Files

Before initiating the import process, it's crucial to prepare your import files correctly to ensure a smooth and error-free import. HubSpot supports .csv, .xlsx, or .xls file formats for import. Your file must have only one sheet and include a header row where each column header corresponds to a property in HubSpot. The file should contain less than 1000 columns and be UTF-8 encoded, especially if it includes foreign language characters. For date-time properties in an Excel file, ensure cells are in Number format. Additionally, the file must adhere to specific property formatting requirements, such as email addresses, phone numbers, and date formats.

Each row in your import file should represent one contact record, and each column should represent a contact property, such as First Name, Last Name, and Email Address. It's also important to include a unique identifier, such as an email address or a HubSpot-generated Record ID, to avoid creating duplicate records or to associate different records correctly.

Importing Contacts into HubSpot CRM

To import contacts into HubSpot CRM, you must have Import and Edit permissions for the object record you're importing into HubSpot. Navigate to your HubSpot account and click on the settings icon in the main navigation bar. In the left sidebar menu, go to Import & Export and click Go to import. On the Imports page, click Start an import and select File from computer, then follow the prompts to select the number of files and objects/activities. Choose your import file and specify how to import your data, whether to create and update records/activities, create new records/activities only, or update existing records/activities only.

During the import process, you'll have the opportunity to map the columns in your file to the corresponding HubSpot properties. HubSpot will attempt to automatically map columns based on the header, the header language, and the property name. You can also manually adjust the mappings, create new custom properties, or skip importing data from specific columns.

How to Import Contacts into HubSpot from Excel

When importing contacts from an Excel file, ensure your file meets the HubSpot import requirements mentioned earlier. Open your Excel file and review the contacts' details, sorting them based on property values if necessary. Save your Excel file in .csv, .xlsx, or .xls format and follow the general import steps outlined above. Remember to format date-time properties in Excel using the Number format and adhere to HubSpot's property formatting requirements to ensure a successful import.

By following these steps, you can efficiently import contacts into HubSpot from Excel or any other source, keeping your CRM database up-to-date and enhancing your marketing, sales, and service efforts.

Read more about AI CRM automations for HubSpot and how they can supercharge your app on our blog: AI CRM Automations for HubSpot.

Automate Your HubSpot Contact Imports with Bardeen

Importing contacts into HubSpot can be manually done following the detailed steps above, or you can automate the process using Bardeen. Automating this task can save time, reduce manual errors, and ensure your HubSpot CRM is always updated with the latest contacts. Bardeen's playbooks can automate various tasks related to importing and managing contacts in HubSpot, making your workflow more efficient.

  1. Copy all HubSpot contacts to Coda: This playbook streamlines the process of syncing your HubSpot contacts to a Coda table, perfect for sales teams needing to access contact data across different platforms.
  2. Copy all HubSpot contacts to Airtable: Easily transfer your HubSpot contacts to Airtable, facilitating better data management and collaboration within teams.
  3. Copy all HubSpot contacts to Google Sheets: Automate the copying of HubSpot contacts into Google Sheets for easier access and analysis.

Other answers for HubSpot

How to Add HubSpot Certification to LinkedIn

Learn how to manually add your HubSpot certification to LinkedIn by updating the Licenses & Certifications section, showcasing your achievements.

Read more
Log LinkedIn Messages in HubSpot

Learn how to log LinkedIn messages in HubSpot using third-party tools like Hublead for improved CRM efficiency and sales processes.

Read more
How to Create an Email Sequence in HubSpot

Learn how to create a HubSpot email sequence with this step-by-step guide, including setup, adding emails, tasks, and utilizing templates for marketing success.

Read more
Understanding Lead Conversion in HubSpot

Learn how to measure lead to customer conversion in HubSpot using conversion rates, CRM tracking, and custom reports for effective sales and marketing strategies.

Read more
Comprehensive Guide to Linking HubSpot to LinkedIn

Learn how to link HubSpot to LinkedIn, including Sales Navigator, to enhance CRM capabilities, streamline lead management, and optimize sales strategies.

Read more
Integrating LinkedIn with HubSpot

Learn how to integrate LinkedIn Sales Navigator with HubSpot for enhanced CRM capabilities, including step-by-step instructions for a seamless setup.

Read more
how does bardeen work?

Your proactive teammate — doing the busywork to save you time

Integrate your apps and websites

Use data and events in one app to automate another. Bardeen supports an increasing library of powerful integrations.

Perform tasks & actions

Bardeen completes tasks in apps and websites you use for work, so you don't have to - filling forms, sending messages, or even crafting detailed reports.

Combine it all to create workflows

Workflows are a series of actions triggered by you or a change in a connected app. They automate repetitive tasks you normally perform manually - saving you time.

get bardeen

Don't just connect your apps, automate them.

200,000+ users and counting use Bardeen to eliminate repetitive tasks

Effortless setup
AI powered workflows
Free to use
Reading time
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
By clicking “Accept”, you agree to the storing of cookies. View our Privacy Policy for more information.