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.
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.
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.