Hola! ¡Tenemos nuestra Comunidad en Español!

Add notes during CSV contact upload....seeking advice

SOLVE
Regular Contributor

With my initial Excel import of about 800 contacts, I have a notes field with info that I want to bring into HubSpot. 

 

What’s the best way to preserve these notes? Should I create a custom field in properties?  Would I then be able to map my Excel notes to this field when importing?

 

I would only be using this once, to preserve the history, but then I’d rely on the regular notes feed based on my activity.

 

Thanks for the assistance as this new guy sets things up.

 

Kirk

Reply
0 Upvotes
3 Accepted solutions

Accepted Solutions
Community Thought Leader

This quick video will walk you through it @KirkB.

- see [MFJLabs VIDEO] HubSpot Import Notes (test-1910)

 

Help answer your question? If so, remember to accept this solution now.

 

Best,
Frank

Author the Perfect HubSpot Series


hubspot-solutions-signature-mfrankjohnson-v05.png

MFrankJohnson.com | Connect on LinkedIn

Help find posts quickly ... accept this solution now.

HubSpot Smart Pages

hubspot-solutions-signature-pricing-options-v01.png

Community Thought Leader

You are correct @KirkB. Late last year HubSpot updated their import feature to allow 'Associated Objects'. We no longer need a temporary 'notes' property to house our historical notes.

 

Hope that helps.

HubSpot Smart Pages

hubspot-solutions-signature-pricing-options-v01.png

Reply
0 Upvotes
Regular Contributor

I am good to go then Frank! Thanks very much for this assist!

8 Replies
Community Thought Leader

This quick video will walk you through it @KirkB.

- see [MFJLabs VIDEO] HubSpot Import Notes (test-1910)

 

Help answer your question? If so, remember to accept this solution now.

 

Best,
Frank

Author the Perfect HubSpot Series


hubspot-solutions-signature-mfrankjohnson-v05.png

MFrankJohnson.com | Connect on LinkedIn

Help find posts quickly ... accept this solution now.

HubSpot Smart Pages

hubspot-solutions-signature-pricing-options-v01.png

Regular Contributor

Frank,

 

Excellent video, thank you!  It appears from your video that I can have my notes added diretly to the feed under each contact.  

 

So I will not need have the field in Properties called "Notes" then?

 

Your solution is much better than what I was coming up with. Let me know and I'll delete the notes property and do it your way.

 

Thanks!

Reply
0 Upvotes
Community Thought Leader

You are correct @KirkB. Late last year HubSpot updated their import feature to allow 'Associated Objects'. We no longer need a temporary 'notes' property to house our historical notes.

 

Hope that helps.

HubSpot Smart Pages

hubspot-solutions-signature-pricing-options-v01.png

Reply
0 Upvotes
Regular Contributor

I am good to go then Frank! Thanks very much for this assist!

Highlighted
Regular Contributor

Frank,

 

I am actually reviewing you video now. What I don't understand is that you import the second spreadsheet called notes.  I have only 1 spreadsheet that has in each row all the contact information including company name AND the notes.

 

How should I create the second spreadsheet with the notes? And how will the system know how to match the notes in the second spreadsheet to the contacts in the first spreadsheet?

 

Thanks again for your assistance.

 

Kirk

Reply
0 Upvotes
Community Thought Leader

Sorry @KirkB. It's not you. It's me! haha Got interrupted while doing that video and forgot to add this xplainer image. (head shaking)mfjlabs-screenshot-hubspot-import-notes-separate-csv-files.png

 

 

 

Have a great weekend.

 

-ps

Maybe just import a note for one contact to see how it works before you ramp up to all 800. There's no 'undo' command, so ... wanna get it right the 1st time.

HubSpot Smart Pages

hubspot-solutions-signature-pricing-options-v01.png

Reply
0 Upvotes
Regular Contributor

Hi,

 

I have a notes column in my Excel spreadsheet; each row (contact) it's own notes in there with word-wrap. Probably 40% of my 800+ rows have some form of notes.

 

I created a propery in Contacts called "Notes-Pre HubSpot". 

 

The intent is to simply bring along historical notes so I don't lose them.

Reply
0 Upvotes
Regular Contributor

Each contact has a notes field. Approx 40% have actual text in the field.  Hoping the property I added will allow me to map correctly.