La fonction de suggestion automatique permet d'affiner rapidement votre recherche en suggérant des correspondances possibles au fur et à mesure de la frappe.
Heya! Just joined Hubspot on the free account to give this CRM a whirl. 😎
I have a TON of database exports and .xlsx lists. I read a ton of tutorials and have figured I have to organize the sheet by name, company domain name, first name, last name and email. The issue is I don't have a company domain name and/or email for each entry. Right now, if I have 10 contacts under 1 company, the import is bringing in the company 10 times versus 1 time and 10 tied contacts.
Question: Any suggestions on how to import companies and contacts with minimal manual entry and no duplicates?
Bonus question: Can I import notes that are tied to each individual contact? I saw on a tutorial that requires another API but wanted to triple-check!
Since HubSpot can't automatically associate your company records with your contacts (because you're missing the company domain in the company import file), you have to make that information available in some other form. The only way (other than by company domain) that I know of would be by using a unique identifier column. Here are two import files for fictional records including such a column.
Contact file:
Company file:
Here's a quick screen recording for the import steps themselves:
(The legal basis of course should reflect the status of your records. For the purpose of this demonstration, I chose "not applicable". This post does not consitute legal advice.)
If you have a contacts file with notes, you would omit that notes column the first time around. (Here's a HubSpot example for what an import file of an object + notes should look like.) After the first import, you'd go back and re-import that contact file (HubSpot will not create additional contacts because of the email as unique identifier). This time, you select File from computer > One file > Multiple objects > Contacts + Notes.
Hope this helps!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
Since HubSpot can't automatically associate your company records with your contacts (because you're missing the company domain in the company import file), you have to make that information available in some other form. The only way (other than by company domain) that I know of would be by using a unique identifier column. Here are two import files for fictional records including such a column.
Contact file:
Company file:
Here's a quick screen recording for the import steps themselves:
(The legal basis of course should reflect the status of your records. For the purpose of this demonstration, I chose "not applicable". This post does not consitute legal advice.)
If you have a contacts file with notes, you would omit that notes column the first time around. (Here's a HubSpot example for what an import file of an object + notes should look like.) After the first import, you'd go back and re-import that contact file (HubSpot will not create additional contacts because of the email as unique identifier). This time, you select File from computer > One file > Multiple objects > Contacts + Notes.
Hope this helps!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
Thanks so much for your help! So If I am understanding you correctly...
The unique identifier is just 1 through however many companies I have, but tie the same number from the associated company to the desired contact(s), right? So start with 1 through 100 for instance in the company .xlsx and then reference the corresponding unique identifier in the contacts .xlsx?
It can be a running number but it doesn't have to be. It could be any number or string and it doesn't have to be consistent – as long as HubSpot can use it as an identifier for matching. HubSpot could also associate contacts and companies if the identifier for a company and its employees is "blueberries". (You might have a column that serves this purpose already?)
Best regards!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
For notes, you would only import one file, like this one just with contacts instead of companies. During the import process, select File from computer > One file > Multiple objects > Contacts + Notes.
Cheers!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer