Tips, Tricks & Best Practices

PeytonBirch
Member

Map columns in your file to contact properties

SOLVE

New to CRM trying to set it up. In the Map Columshowbox ns and having difficult tie to decide wahr to add to each one there's so many. Do I have to click on everyone. Is there a standard form to click to just add emails and all the others stuff as you go. Was looking more of a spreed sheet style. SO confused. Any idesas. Just want simple notes a tracker for lead a yes or no column. The basic for email phusps tracking one#'s company name they work for

Thank you for the help

0 Upvotes
1 Accepted solution
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Map columns in your file to contact properties

SOLVE

Hi @PeytonBirch,

 

You don't have to map all columns from your import file to HubSpot contact properties. If you're not planning to filter and segment by or report on something, you can also choose to not import columns.

 

This knowledge base article might be helpful for you. It has descriptions for all default contact properties: https://knowledge.hubspot.com/contacts/hubspots-default-contact-properties

 

Regarding a notes field, you'd have to create a custom property (type: single line text). There isn't a default property for this. In a similar fashion, you could also create a yes/no column (type: radio select). For the phone number and company name, you should find default properties called with the exact same names: Phone number and Company name.

 

If you notice at a later point that you do an additional column, you can update existing contacts by importing just that column and an email column. (HubSpot uses the email address as a unique identifier.)

 

Best regards!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

View solution in original post

1 Reply 1
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Map columns in your file to contact properties

SOLVE

Hi @PeytonBirch,

 

You don't have to map all columns from your import file to HubSpot contact properties. If you're not planning to filter and segment by or report on something, you can also choose to not import columns.

 

This knowledge base article might be helpful for you. It has descriptions for all default contact properties: https://knowledge.hubspot.com/contacts/hubspots-default-contact-properties

 

Regarding a notes field, you'd have to create a custom property (type: single line text). There isn't a default property for this. In a similar fashion, you could also create a yes/no column (type: radio select). For the phone number and company name, you should find default properties called with the exact same names: Phone number and Company name.

 

If you notice at a later point that you do an additional column, you can update existing contacts by importing just that column and an email column. (HubSpot uses the email address as a unique identifier.)

 

Best regards!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.