Importing from another DB using Excel. I am importing Companies, Contacts and Notes. Import limited to two files. When I import Companies and Contacts, they associate properly, and all is good except I have no notes. When I import Companies and Notes, the subsequent import of Contacts does not associate with associated company. I see no import for notes only.
Yes, each record in HubSpot gets a record ID. This ID can be exported and used to identify contacts which do not have any other identifier. It should appear by default in an export of company records.
Add your notes to the exported file (as per the sample file I shared in an earlier post). During the import process, you can now tell HubSpot to update the existing records in HubSpot by ID:
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. (This unique identifier could be the company Name, as long as you follow the steps below.) 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
Yes, each record in HubSpot gets a record ID. This ID can be exported and used to identify contacts which do not have any other identifier. It should appear by default in an export of company records.
Add your notes to the exported file (as per the sample file I shared in an earlier post). During the import process, you can now tell HubSpot to update the existing records in HubSpot by ID:
Hope this helps!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
This has gotten a little complicated. I have Contacts, Companies and Notes. Many companies have no domain name. Is there a way to associate contacts and companies by company name?
If not, If I import companies first and then export and insert company IDs into the Contacts file, can I associate contacts to companies by company ID?
Yes it is, please see the fourth bullet point, "Companies and notes sample spreadsheet", in this chapter of the knowledge base post. During the import process, select File from computer > One file > Multiple objects > Contacts + Notes.
Best regards
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
I uploaded Companies and Notes in the format to which you referred. Some note loaded properly, but a large number of them were rejected for invalid domain name. The domain name in the error message was not the domain name in the input, and seems to be the name of a contact. Contact names were not in the import file, but the did appear in notes unrelated to the company in question.
I am wondering if commas in the notes field are a problem.
That would be unusual – I haven't encountered any "incorrect" error messages in the import tool so far. Could you share a screenshot of a line of a line in the import file and the corresponding error message, pixelating the domain name?
Sorry, I can not post the file. It is not my data, and some of the connections are sensitive.
However, I found the problem. It was my own dumb error - I imported the wrong file.
One more question. I still need to import the notes that were in error. Many do not have domain names on the HubSpot database. Is there a way I can import the notes without creating duplicate company records for those without domain names?
PS. I REALLY appreciate your taking time to help me.