Lists, Lead Scoring & Workflows

Billsen
Contributor

Create a List From a Spreadsheet Based on a Matching Company in HubSpot?

Hi-

Here's what I am trying to do - my predecessor left a spreadsheet with a list of companies that use our competitors' products. It's literally *just* a list of company and division names. There's just that single column - nothing else.

What I want to do is create a list to send a campaign to the companies from that spreadsheet that are in our system. 

Is there a method that would allow me to upload this spreadsheet to a HubSpot, then if there is a match between a company in our system and one in the spreadsheet, then the contact(s) that works for that company gets added to the list? Can I also do this without adding all of the non-matches to my contacts?

There are about 10,000 companies in the spreadsheet, so the thought of doing this manually makes me a tad queasy...

Any ideas?

0 Upvotes
3 Replies 3
CMarritt
Contributor

Create a List From a Spreadsheet Based on a Matching Company in HubSpot?

Is there any update on this? Also having the same issue. Only thing I can think of is using VLOOKUP or some other advanced excel technique...

 

thanks

0 Upvotes
PamCotton
Community Manager
Community Manager

Create a List From a Spreadsheet Based on a Matching Company in HubSpot?

Hello @Billsen,

 

In your list, does it contains the company domain?

Você sabia que a Comunidade está disponível em outros idiomas?
Participe de conversas regionais, alterando suas configurações de idioma !


Did you know that the Community is available in other languages?
Join regional conversations by changing your language settings !




0 Upvotes
Billsen
Contributor

Create a List From a Spreadsheet Based on a Matching Company in HubSpot?

No. ALL I have is company names.

 

0 Upvotes