# Hubspot ZOHO import notes issue

**URL:** <https://community.hubspot.com/t/hubspot-zoho-import-notes-issue/18184>\
**Category:** CRM\
**Tags:** contacts\
**Created:** [January 17, 2020, 5:00pm UTC](https://community.hubspot.com/t/hubspot-zoho-import-notes-issue/18184 "2020-01-17T17:00:43Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![GDT](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/gdt/32/88643_2.png) [@GDT](https://community.hubspot.com/u/GDT)\
**Post date:** [January 17, 2020, 5:00pm UTC](https://community.hubspot.com/t/hubspot-zoho-import-notes-issue/18184/1 "2020-01-17T17:00:43Z")

</div>

I am migrating from Zoho to Hubspot.

I have successfully imported both contacts and accounts via CSV upload.

Howeve, I am having issues importing ‘notes’ previously associated to each contact in ZOHO. Issue is, the ZOHO extrat only includes a ‘contact’ account number (ie ZH\_234323) and does not include contact name or email address (asked for my Hubspot import tool) for each note. I did include the contact account number when importing contacts. Can someone please advise me as to how I can imort contact’s ‘notes’ using the contact account number to match up elements.

Thank you.

---

<div class="post-metadata">

**Author:** ![louischausse](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/louischausse/32/18067_2.png) [@louischausse](https://community.hubspot.com/u/louischausse)\
**Post date:** [January 17, 2020, 6:44pm UTC](https://community.hubspot.com/t/hubspot-zoho-import-notes-issue/18184/2 "2020-01-17T18:44:54Z")

</div>

Hi @GDT

Congratulations on moving to HubSpot. I’m sure you will enjoy it!

With your Zoho contacts export file, you should have a column with the Zoho ID for each contact.

You can create an import file using that file and your notes export file. It takes a bit of work within Excel but having a matching field in both files; you should be able to figure something out.

Don’t forget to mark my reply as a solution if you are satisfied. If not, do not hesitate to ask me anything!

---

<div class="post-metadata">

**Author:** ![GDT](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/gdt/32/88643_2.png) [@GDT](https://community.hubspot.com/u/GDT)\
**Post date:** [January 17, 2020, 7:06pm UTC](https://community.hubspot.com/t/hubspot-zoho-import-notes-issue/18184/3 "2020-01-17T19:06:48Z")

</div>

Hi @louischausse

Thanks so much for the feedback!

I actually do have the Zoho ID for each contact in the notes excel file. However, Hubspot isn’t letting me use this element to make a match. How do I designate the Zoho ID as the unique identifier?

Here’s what I see on the Hubspot import tool:

 ![Screen Shot 2020-01-17 at 2.04.11 PM.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/2/a/2aea53e6453d2c8b3894bbd8f5e6d62a98b8553c.png)

---

<div class="post-metadata">

**Author:** ![louischausse](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/louischausse/32/18067_2.png) [@louischausse](https://community.hubspot.com/u/louischausse)\
**Post date:** [January 17, 2020, 10:23pm UTC](https://community.hubspot.com/t/hubspot-zoho-import-notes-issue/18184/4 "2020-01-17T22:23:54Z")

</div>

Did you try to import both files at the same time with this method:

> **[Import records for multiple objects](https://knowledge.hubspot.com/import-and-export/import-objects)**
>
> Import records for multiple objects in HubSpot using one or more files. Create and update records and automatically associate related data.

?

Don’t forget to mark my reply as a solution if you are satisfied. If not, do not hesitate to ask me anything!

---

<div class="post-metadata">

**Author:** ![GDT](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/gdt/32/88643_2.png) [@GDT](https://community.hubspot.com/u/GDT)\
**Post date:** [January 20, 2020, 2:28pm UTC](https://community.hubspot.com/t/hubspot-zoho-import-notes-issue/18184/5 "2020-01-20T14:28:21Z")

</div>

Hi @louischausse I used that method of imort for the first two .csv files I imported - Contacts and Accounts. I used the Zoho generated number to link of the two files… and it worked perfectly. Now, I’m attempting to import a 3rd file ‘notes’ and hubspot is not allowing me to use the ‘contacts’ zoho number to marry up the two files.

---

<div class="post-metadata">

**Author:** ![louischausse](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/louischausse/32/18067_2.png) [@louischausse](https://community.hubspot.com/u/louischausse)\
**Post date:** [January 22, 2020, 12:51am UTC](https://community.hubspot.com/t/hubspot-zoho-import-notes-issue/18184/6 "2020-01-22T00:51:39Z")

</div>

Hi @GDT

Are you importing the 3rd file alone or with at least another file like you did in the first import?

---

<div class="post-metadata">

**Author:** ![GDT](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/gdt/32/88643_2.png) [@GDT](https://community.hubspot.com/u/GDT)\
**Post date:** [January 22, 2020, 3:48pm UTC](https://community.hubspot.com/t/hubspot-zoho-import-notes-issue/18184/7 "2020-01-22T15:48:13Z")

</div>

Hi @louischausse

Thanks again for getting to me. It really is very appreciated.

To answer your question, this 3rd file is being imorted alone as there were only 3 files to import. The first two (accounts and contacts) were imported using the method mentioned in your previous response. Should I consider reimporting the contacts with the associated notes? Or would this created duplicate contacts?

---

<div class="post-metadata">

**Author:** ![louischausse](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/louischausse/32/18067_2.png) [@louischausse](https://community.hubspot.com/u/louischausse)\
**Post date:** [January 22, 2020, 5:03pm UTC](https://community.hubspot.com/t/hubspot-zoho-import-notes-issue/18184/8 "2020-01-22T17:03:55Z")

</div>

Yes, that’s exactly what I would try. HubSpot will not create a new contact if it recognizes the same email address. (More about this here) [https://community.hubspot.com/t5/CRM/Export-then-re-import-to-bulk-edit/m-p/177685/highlight/true#M107520](https://community.hubspot.com/t5/CRM/Export-then-re-import-to-bulk-edit/m-p/177685/highlight/true#M107520)).

So, it is important you import a contact file with an “email address column”.

Finally, you would have to select the Zoho id as a common column header

Don’t forget to mark my reply as a solution if you are satisfied. If not, do not hesitate to ask me anything!

---

<div class="post-metadata">

**Author:** ![GDT](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/gdt/32/88643_2.png) [@GDT](https://community.hubspot.com/u/GDT)\
**Post date:** [January 22, 2020, 5:14pm UTC](https://community.hubspot.com/t/hubspot-zoho-import-notes-issue/18184/9 "2020-01-22T17:14:28Z")

</div>

Okay.

Tried that.

When I get to the ‘notes’ section, it doesn’t let me tag the Contact ID. I was able to tag contact ID on contact import page.

please see image.

 ![Screen Shot 2020-01-22 at 12.12.15 PM.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/0/1/011c8934ba3922db34e99a55442b0ac7c31c6b70.png)

---

<div class="post-metadata">

**Author:** ![louischausse](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/louischausse/32/18067_2.png) [@louischausse](https://community.hubspot.com/u/louischausse)\
**Post date:** [January 22, 2020, 6:12pm UTC](https://community.hubspot.com/t/hubspot-zoho-import-notes-issue/18184/10 "2020-01-22T18:12:50Z")

</div>

This is normal. Contact ID is a contact property not a Note property.

Select “Don’t import column” and you should be good to go

Don’t forget to mark my reply as a solution if you are satisfied. If not, do not hesitate to ask me anything!

---

<div class="post-metadata">

**Author:** ![GDT](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/gdt/32/88643_2.png) [@GDT](https://community.hubspot.com/u/GDT)\
**Post date:** [January 22, 2020, 9:24pm UTC](https://community.hubspot.com/t/hubspot-zoho-import-notes-issue/18184/11 "2020-01-22T21:24:56Z")

</div>

@louischausse looks like it worked!

Thank you so much.
