How to Turn a Website Column Into Clean Domains (for Email Finding, Matching and Suppression)
Strip the URL down to the registrable domain, and set aside the rows that aren't a company website. "https://www.Acme.com/about?utm_source=x" becomes acme.com, "shop.acme.co.uk/sale" becomes acme.co.uk (not co.uk), and LinkedIn pages, myshopify.com stores, IP addresses and names typed into the website field get flagged instead of turned into fake domains. Then check the domains accept email before you build addresses on them.
Sources, read 2 November 2026: the Public Suffix List, the community list (started by Mozilla) of endings like com and co.uk under which people register names. Our extract domain from URL tool uses a shorter built-in list of the common two-part endings, not the full list.
Why you need the domain, not the URL
- Finding work emails: email finders and pattern tools take a domain. See the email format finder.
- Matching: deduplicating against customers or existing leads works on domain, because the same company appears as acme.com, www.acme.com/contact and Acme.com/.
- Suppression: blocking a competitor, a customer or a do-not-contact company is a domain rule in most sequencers.
How to do it
- Export the list with its website column. Apollo, Clay, Sales Navigator scrapes and Google Maps exports all carry one, under names like Website, Company Website or URL.
- Paste or upload it into the extract domain from URL tool. It removes the protocol, www, path, query and UTM tags, and reduces each host to its root domain with common two-part country endings (co.uk, com.au and similar) handled. You can keep subdomains instead if you need them.
- Look at the flagged rows. Profiles (linkedin.com/company/..., facebook.com/..., linktr.ee/...), shared-hosting stores (acme.myshopify.com, wixsite.com), IP addresses and text that isn't a URL ("Acme Corp") are marked rather than converted.
- Download the CSV with a domain column added, or a unique list of domains.
- Check the domains take email. A website domain may be parked, expired, or have no mail servers. The bulk website status checker shows which sites are still up, and check if a domain accepts email explains the MX check.
Examples
| In the website column | Domain | Note |
|---|---|---|
| https://www.Acme.com/about?utm_source=x | acme.com | path and query removed |
| shop.acme.co.uk/sale | acme.co.uk | subdomain of acme.co.uk |
| blog.acme.com | acme.com | subdomain |
| jane@acme.com | acme.com | taken from an email |
| linkedin.com/company/acme | (flagged) | a profile, not the company site |
| acme.myshopify.com | (flagged) | no domain of its own |
| Acme Corp | (flagged) | a name, not a URL |
Honest limits
- Common endings only. The tool knows the usual two-part endings, not every entry on the Public Suffix List, so check results for rare country or private suffixes.
- No DNS lookup. The tool reads text. It doesn't know whether acme.com exists, redirects to a new brand, or is parked; see parked domain emails.
- The website may not be the email domain. Some companies send from a different domain than their site, especially after a rebrand or acquisition. The email to domain extractor shows the real email domains from addresses you already have.
- A domain isn't a contact. You still need a person and a verified address.
Where SimpleVerifier fits
The domain tool is free and runs in your browser. When you have addresses, upload them on the verify page to check each mailbox; the first 100 checks are free with a Google sign-in. Pro is $39 a month with the first 100,000 checks a month at full speed, then slower, never cut off. See pricing.
Common questions
How do I extract the domain from a URL in Google Sheets or Excel?
A REGEXEXTRACT formula can pull the host from a URL, but it won't remove subdomains correctly for country endings like co.uk or com.au, and it won't tell you which rows are social profiles. A tool that knows the two-part endings and flags profile and hosted-store rows handles both.
What is a root domain?
The part someone actually registered: acme.com, or acme.co.uk under the co.uk suffix. The Public Suffix List, a Mozilla-initiated community list, defines suffixes like com and co.uk under which names can be registered, and the root domain is one label above that.
Should I keep subdomains?
For finding work email, usually not: people at shop.acme.com have @acme.com addresses. Keep them when the subdomain is a separate business, such as a regional office with its own mail setup.
Can I find emails for a myshopify.com or wixsite.com website?
Not from the domain. Those are shared hosting addresses, so the store has no domain of its own to build an address on. Look for a contact email on the store page instead.
Check your list before you send
Real mailbox checks over SMTP, and nothing is sent to the address. Sign in with Google and your first 100 email checks are free, no card. Plans for bigger lists are on the pricing page.