Hola! ¡Tenemos nuestra Comunidad en Español!

DUPLICATE ROW CONTENT

SOLVE
New Member

I am trying to import a big list of Companies (15.000) using an .xlsx file, each Company has 49 properties. For example State, and of course, this State property will repeat in more than one Company.  HubSpot cannot import these Companies because the row has the same content as one of the previous 4 rows. Of course, they have ... is not the Name or Company domain, is common property.

Reply
0 Upvotes
1 Accepted solution

Accepted Solutions
Highlighted
Regular Advisor | Silver Partner

Hi @fellipeelias 

 

We've faked a domain name to create separate branches of a company.

 

We joined State, a Dot and the Domain name (e.g. state.domain.com) in a new column in the import file. Then we mapped the new column to the Domain so it tricks HubSpot into thinking each state is a different Company (because it doesn't de-duplicate on the domain name). The only problem is that there's no relationship between those companies.

 

The only way to effectively import the data, with relationships between companies (i.e. Parent Child where "Branch" is a child of "Company") is to build a Custom Importer.

 

Have fun

Mike

 

1 Reply 1
Highlighted
Regular Advisor | Silver Partner

Hi @fellipeelias 

 

We've faked a domain name to create separate branches of a company.

 

We joined State, a Dot and the Domain name (e.g. state.domain.com) in a new column in the import file. Then we mapped the new column to the Domain so it tricks HubSpot into thinking each state is a different Company (because it doesn't de-duplicate on the domain name). The only problem is that there's no relationship between those companies.

 

The only way to effectively import the data, with relationships between companies (i.e. Parent Child where "Branch" is a child of "Company") is to build a Custom Importer.

 

Have fun

Mike