# Deduplication using ‘exact’ domain name? **URL:** \ **Category:** CRM\ **Tags:** crm, how-to\ **Created:** [January 13, 2022, 7:42am UTC](https://community.hubspot.com/t/deduplication-using-exact-domain-name/49705 "2022-01-13T07:42:42Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![SCole7](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/scole7/32/9373_2.png) [@SCole7](https://community.hubspot.com/u/SCole7)\ **Post date:** [January 13, 2022, 7:42am UTC](https://community.hubspot.com/t/deduplication-using-exact-domain-name/49705/1 "2022-01-13T07:42:42Z")
Hi All, I tried to import a list of organisations using the domain name as the unique identifier so that it would ignore, and therefore not import, any records that already had that domain name in HS. When I reviewed the import list I noticed a lot of duplicate records had been created. The only reason I can think of is that the domain name must be identical. For example [https://pixl8.co.uk](https://pixl8.co.uk) vs [http://www.pixl8.co.uk](http://www.pixl8.co.uk) Is this expected behaviour or should it only look at the ‘[pixl8.co.uk](http://pixl8.co.uk)’ part? Thanks Scott ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [January 13, 2022, 12:25pm UTC](https://community.hubspot.com/t/deduplication-using-exact-domain-name/49705/2 "2022-01-13T12:25:12Z")
Hi @SCole7, HubSpot strips away the https:// or [http://www](http://www). during import, that shouldn’t be the issue. Could you find two duplicates and double check whether both have a _Company domain name_? If for some reason one of the does not have a value in there, that would explain the duplicate. (This could’ve been caused by incorrect mapping or simply omitting the _Company domain name_ column in an import.) Best regards! ---
**Author:** ![MLy1](https://avatars.discourse-cdn.com/v4/letter/m/ac8455/32.png) [@MLy1](https://community.hubspot.com/u/MLy1)\ **Post date:** [July 6, 2022, 5:21pm UTC](https://community.hubspot.com/t/deduplication-using-exact-domain-name/49705/3 "2022-07-06T17:21:02Z")
Hi @karstenkoehler, I think @SCole7 is correct with their findings. I have a large about of duplicates due to the fact that HS seem to take into consideration the “www.” factor. Is this a glitch in the system? Thank you, Mel ![MLy1_0-1657127958539.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/f/7/f78813c24e7127ffbeb7eb4c3625c431bfe4ef5d.png) ![MLy1_1-1657127985516.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/9/8/98722840771717c2a28416379c76140cba1af271.png) ---
**Author:** ![RBozeman](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/rbozeman/32/8786_2.png) [@RBozeman](https://community.hubspot.com/u/RBozeman)\ **Post date:** [October 19, 2022, 3:34pm UTC](https://community.hubspot.com/t/deduplication-using-exact-domain-name/49705/4 "2022-10-19T15:34:25Z")
Hi @SCole7, Yes you have to make sure that the Company Domian Name field is included in the CSV, so that the companies can be identified as duplicates. [Here](https://knowledge.hubspot.com/crm-setup/deduplication-of-contacts-companies-deals-tickets#deduplicate-companies-by-company-domain) is the relevant documentation on this. Also wanted to mention that [Insycle](https://app.hubspot.com/ecosystem/6303986/marketplace/apps/marketing/data-management/insycle) provides you with a lot of flexibility here. Full disclosure, I work for them as a marketer. But Insycle allows you to deduplicate companies using any field in HubSpot CRM as a matching field. So you could use fields like Company Name, for instance, to duplicate companies as well. Then, you can choose between similar matching (instead of exact) to catch companies with similar domains or names. You can also instruct Insycle what terms to ignore…so subdomains/https/extensions for domains. Or stuff like Inc/Co/LLC for company names. This let’s you catch many more duplicates in the database by looking more broadly for matches. ---
**Author:** ![DianaGomez](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dianagomez/32/48035_2.png) [@DianaGomez](https://community.hubspot.com/u/DianaGomez)\ **Post date:** [October 19, 2022, 7:33pm UTC](https://community.hubspot.com/t/deduplication-using-exact-domain-name/49705/5 "2022-10-19T19:33:16Z")
Hi @RBozeman hope you are doing well! Thanks for sharing 🙂 Best, Diana