# Need help with import **URL:** \ **Category:** Marketplace Apps\ **Tags:** integrations\ **Created:** [April 24, 2021, 9:15pm UTC](https://community.hubspot.com/t/need-help-with-import/36095 "2021-04-24T21:15:32Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![RJCampbell](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/rjcampbell/32/69256_2.png) [@RJCampbell](https://community.hubspot.com/u/RJCampbell)\ **Post date:** [April 24, 2021, 9:15pm UTC](https://community.hubspot.com/t/need-help-with-import/36095/1 "2021-04-24T21:15:32Z")
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. Anyone have a solution? ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [April 25, 2021, 7:40am UTC](https://community.hubspot.com/t/need-help-with-import/36095/2 "2021-04-25T07:40:22Z")
Hi @RJCampbell, You’re not the first one to be confused by this. I found the sample files linked here very useful: [Format import files](https://knowledge.hubspot.com/crm-setup/set-up-your-import-file#multiple-objects-with-associations) I recently answered a similar query here: [https://community.hubspot.com/t5/CRM/Importing-database-companies-and-contacts/td-p/428027](https://community.hubspot.com/t5/CRM/Importing-database-companies-and-contacts/td-p/428027) Could you report back if these two resources helped you solve the issue? Hope this helps! ---
**Author:** ![RJCampbell](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/rjcampbell/32/69256_2.png) [@RJCampbell](https://community.hubspot.com/u/RJCampbell)\ **Post date:** [April 26, 2021, 10:12pm UTC](https://community.hubspot.com/t/need-help-with-import/36095/3 "2021-04-26T22:12:26Z")
Do you know if it is possible to associate motes with companies father than contacts? ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [April 27, 2021, 4:04am UTC](https://community.hubspot.com/t/need-help-with-import/36095/4 "2021-04-27T04:04:50Z")
Hi @RJCampbell, Yes it is, please see the fourth bullet point, “Companies and notes sample spreadsheet”, in this [chapter of the knowledge base post](https://knowledge.hubspot.com/crm-setup/set-up-your-import-file#multiple-objects-with-associations). During the import process, select _File from computer_ \> _One file_ \> _Multiple objects_ \> _Contacts + Notes_. Best regards ---
**Author:** ![RJCampbell](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/rjcampbell/32/69256_2.png) [@RJCampbell](https://community.hubspot.com/u/RJCampbell)\ **Post date:** [April 27, 2021, 7:18pm UTC](https://community.hubspot.com/t/need-help-with-import/36095/5 "2021-04-27T19:18:38Z")
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. ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [April 28, 2021, 4:18am UTC](https://community.hubspot.com/t/need-help-with-import/36095/6 "2021-04-28T04:18:25Z")
Hi @RJCampbell, 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? I’d also recommend having a look at this older [thread on how to format the domain names](https://community.hubspot.com/t5/CMS-Development/Imports-not-recognizing-URL-domain-name/td-p/204157). Which subscription level are you on? With Starter or higher, you could reach out to HubSpot support. Best regards ---
**Author:** ![RJCampbell](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/rjcampbell/32/69256_2.png) [@RJCampbell](https://community.hubspot.com/u/RJCampbell)\ **Post date:** [April 28, 2021, 5:45pm UTC](https://community.hubspot.com/t/need-help-with-import/36095/7 "2021-04-28T17:45:38Z")
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. ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [April 29, 2021, 4:52am UTC](https://community.hubspot.com/t/need-help-with-import/36095/8 "2021-04-29T04:52:47Z")
Hi @RJCampbell, 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: ![41767iA1C0F48AB8B3CDB7.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/0/6/065f7662afa6a8196103de1e7d3eeca08b7680cf.png) Hope this helps! ---
**Author:** ![RJCampbell](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/rjcampbell/32/69256_2.png) [@RJCampbell](https://community.hubspot.com/u/RJCampbell)\ **Post date:** [April 29, 2021, 4:54pm UTC](https://community.hubspot.com/t/need-help-with-import/36095/9 "2021-04-29T16:54:36Z")
Thank you. The client is a very low budget 503b using free version. So Hubspot tech support is not available. I appreciate your help so much ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [April 29, 2021, 7:13pm UTC](https://community.hubspot.com/t/need-help-with-import/36095/10 "2021-04-29T19:13:30Z")
Sure, happy to help! ---
**Author:** ![RJCampbell](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/rjcampbell/32/69256_2.png) [@RJCampbell](https://community.hubspot.com/u/RJCampbell)\ **Post date:** [April 29, 2021, 11:38pm UTC](https://community.hubspot.com/t/need-help-with-import/36095/11 "2021-04-29T23:38:38Z")
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? ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [April 30, 2021, 4:30am UTC](https://community.hubspot.com/t/need-help-with-import/36095/12 "2021-04-30T04:30:52Z")
Hi @RJCampbell, 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](https://f.hubspotusercontent40.net/hubfs/2832391/Settings/Import-and-Export/HubSpot%20example%20-%20Companies%20and%20notes%20import%20file.xlsx).) 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!