App Tutorial

Step-by-Step Guide to Import Deals into HubSpot (2024)

Jason Gong
App automation expert
Apps used
April 15, 2024

Importing deals into HubSpot involves preparing your import files in .csv, .xlsx, or .xls format, ensuring they meet specific requirements, and following a detailed process to upload and map your data to HubSpot properties. This process helps streamline your sales process by accurately reflecting all potential and ongoing transactions in your CRM.

Understanding how to correctly prepare and import your deals can significantly improve your sales management and forecasting accuracy.

For a more efficient process, consider automating your HubSpot deal imports with Bardeen to save time and reduce errors.

How to Import Deals into HubSpot

Importing deals into HubSpot can streamline your sales process and ensure that your CRM reflects all potential and ongoing transactions accurately. This guide provides a comprehensive overview of the steps and considerations for importing deals into HubSpot, including associating deals with companies and contacts.

Automate your HubSpot deal imports and more with Bardeen. Download now to optimize your sales process.

Set Up Your Import Files

Before initiating the import process, it's crucial to prepare your import files correctly. Your import file must be in .csv, .xlsx, or .xls format, contain only one sheet, and include a header row where each column header corresponds to a property in HubSpot. Ensure that your file is UTF-8 encoded, especially if it contains foreign language characters. The file should not exceed 1000 columns and must adhere to specific property requirements for successful import.

When setting up your import file, identify the CRM objects you're importing, such as contacts, companies, deals, tickets, and custom objects. Each row in your file should represent one object record, and if you're importing multiple objects in one file, each row will represent records associated with each other. Use unique identifiers like email addresses, company domain names, or Record IDs to avoid creating duplicate records and to associate different records correctly. For deals, including properties such as 'Deal name', 'Pipeline', and 'Deal stage' is essential.

Import Records and Activities

To import deals into HubSpot:

  1. Click 'Import' in the top right of any object home page in your HubSpot account, or navigate to 'Settings' > 'Import & Export' > 'Go to import'.
  2. On the 'Imports' page, click 'Start an import'.
  3. Select 'File from computer' and click 'Next'. You can also choose 'Repeat a past import' for similar future imports.
  4. Select the type of import: 'One file' for a single object or activity import, 'One file' with 'Multiple objects' for importing multiple objects and activities in one file, or 'Multiple files with associations' for importing two objects or an object and an activity in two separate files.
  5. For each object or activity, click 'choose a file' and select your import file.
  6. Choose how to import your data: 'Create and update records/activities', 'Create new records/activities only', or 'Update existing records/activities only'.
  7. Map your columns to the corresponding HubSpot properties. HubSpot will attempt to match the columns in your file to the selected object or activity's properties based on the header, the header language, and the property name.
  8. If updating existing records or avoiding duplicates while associating cross-object records, ensure you've mapped the correct unique identifier.

If you're importing deals and need to associate them with companies, include a common column in both your deal and company import files, such as 'Company name' or 'Company domain name'. This common column will serve as the link between the deals and the companies during the import process.

After mapping your columns and ensuring all required properties are included, review your import for any errors and make necessary adjustments. Once satisfied, proceed with the import. HubSpot will process your file, create new records, update existing ones, and associate deals with the corresponding companies based on the information provided in your import file.

Discover how to seamlessly integrate HubSpot with Salesforce, LinkedIn, and Slack to enhance your sales and marketing efforts.

Automate HubSpot Sales with Bardeen: A How-To Guide

Importing deals into HubSpot can significantly enhance your sales management and forecasting accuracy. While manual imports are straightforward, automating this process using Bardeen can save time and reduce errors, ensuring your sales data remains synchronized across your tech stack. Here are some powerful automations you can set up with Bardeen:

  1. Sync New HubSpot Deal to Salesforce: This automation ensures that whenever a new deal is created in HubSpot, it's automatically updated in Salesforce. It's perfect for maintaining consistent sales data across both platforms.
  2. Copy all HubSpot deals to Airtable: For organizations using Airtable to manage their sales pipeline, this automation transfers all HubSpot deal details into an Airtable base, streamlining workflow and data accessibility.
  3. Sync HubSpot Deals to Salesforce Notes: Keep your sales teams aligned by automatically creating a Salesforce note for each new deal added in HubSpot, ensuring seamless communication and tracking.

Embrace these automations to maximize efficiency and accuracy in your sales processes. Get started by downloading the Bardeen app.

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.