CRM Deal Import - Automatically Associate with Contacts

We need the ability to automatically associate deals with contacts/companies during the import process.


We have thousands of deals that have been completed for the current year.  Our service is provided on an annual basis.  We need the ability to create new deals that incorporate some properties from our completed deals in the prior year.  It appears this is easy, as we can export our completed deals, make the necessary changes in Excel, and them re-import into HubSpot.


However, there is not currently the ability to automatically associate the imported deals with their contacts/companies.  Doing this manually in not a viable option due to the high number of deals.  

HubSpot updates
73 Replies
Esteemed Contributor

Hi there,


At this time it is not possible to associate Contacts and Deals during a CSV import into Hubspot. You would have to import them separately, and then manually associate them in Hubspot after. 


One option is to use API to import the data, so that you can retain the relationships between your records. We offer this as part of our standard data migrations. You can check out how this will work with a free sample here:




HubSpot Product Team
HubSpot Product Team
updated to: In Planning

We are planning several improvements to importing in HubSpot. One of the big ones is making it possible to associate contacts, companies, deals and activities (notes, emails, calls, meetings, tasks) to each other during import. This functionality is currenlty possible through HubSpot's APIs, but we want to make it easier for everyone to doas part of our import flow.

Occasional Contributor



Is there any update with this request? We need to associate thousands of contacts to deals.

Regular Contributor


New Contributor

What is the status of this?? I've been asking for this simple update for the better part of 2 years now and was told in June of 2016 that it would be finished by the end of the year... Here we are, mid 2017 and still nothing.. Smiley Sad


For a company that imports hundreds of deals a day for their team to call on, manually adding them on every deal is crazy and cuts our production in half. Not to mention it prevents us from being able to automate workflows, call our Evangelist first (we have no way of knowing until we manually add them) or take advantage of the call queue.


Please, please PLEASE with a cherry on top let's make this happen! Please Smiley Happy

Bruamico Occasional Contributor | Platinum Partner
Occasional Contributor | Platinum Partner

 Hi! This feature is extremely important! The same with excel spreadsheets, we need to be able to import deals and associate them with companies and contacts contained in the data. The same with deal creation, sales reps should be able to add deal, company and contacts import in the same screen.

New Member

I'm evaluating different CRM options. I have more than 1,000 contacts to import. If there's not a way to automatically associate them with companies that will be a deal breaker... 

Regular Contributor

One more tool to consider is data2crm, the service offers automatical CRM data import using API, so there is no need to manual data export/import. Feel free to mail me for more info.


Regards, Ivan

New Contributor

This has been and continues to be one of my greatest frustrations as a Sales User in HubSpot. This should be pretty basic considering each deal does have an associated Deal ID. 


We also have thousands of deals that we can easily update via a spreadsheet, but then have to painstakingly update those manually back into HubSpot b/c they can't handle basic de-duplication on an import. Painful!

Regular Contributor

I was hoping to start doing some important analysis of customer relationships, including tracking how much they're spending over time and how often they're coming back for more. However, I cannot until I can import deals directly associated with each customer.


I hope this will be implemented soon. Not only is Import2 priced well out of my budget, it doesn't support FreshBooks, my current invoicing system.