ConvertCSV

Extract Tools

Extract Domains from CSV

List the unique domains behind email addresses and URLs in CSV cells, with counts. Runs locally in your browser — nothing is uploaded for processing.

Input

Paste CSV or upload a file

Options

No extra options — run on your CSV input.

Output Preview

Result

Run the tool to preview output here.

Extract Domains from CSV

Extract Domains reduces every email address and web link in a CSV to its host name, drops a leading www., and counts how often each host appears. A column of thousands of contact emails and profile links becomes a short alphabetical list such as acme.io with a count of 412, which is far easier to scan for account overlap than the raw addresses.

Each cell is read for http and https links and for email addresses. The results from both sources are merged into one tally, sorted alphabetically.

Key features

  • Domains from email addresses and http(s) links
  • Leading www. removed and names lowercased
  • Unique, alphabetically sorted list
  • Count per domain

About the CSV to CSV format

The output has two columns, domain and count. A domain is the lowercase host of a link, or the text after the @ in an address. The count is the number of matches, not the number of rows, so a person whose email and profile link both point at acme.io adds two to the total. Hosts that are IP addresses, names without a dot such as localhost, and text without an http or https prefix are skipped.

How it works

The scanner first lifts every http or https link out of a cell and parses its host with the browser's URL parser. The text that remains is searched for email addresses, and the part after the @ is kept as the domain. Both sources feed one tally, so repeated hosts add up across the whole sheet.

Common use cases

  • Counting which companies appear most often in a lead list before assigning territories
  • Auditing the third-party domains a set of landing pages links out to
  • Reviewing which mail providers dominate a subscriber export before a deliverability check

How to use this tool

  1. Put the export in the text box, or select the file with Click to upload.
  2. Click Extract.
  3. Read the domain and count columns, then copy the list into a sheet if you want to sort or chart it.

Example

Leads with email and website (input)

name,email,website
Ana,ana@acme.io,https://www.acme.io/about
Ben,ben@northwind.com,
Chi,chi@acme.io,http://shop.northwind.com/cart

Domains with counts (output)

domain,count
acme.io,3
northwind.com,1
shop.northwind.com,1

Tips for best results

  • Sort by count, then read the bottom of the list. Typos such as gmial.com tend to show up as single-count domains next to the real provider.
  • Use Extract Emails or Extract URLs instead when you need the full addresses or links rather than their hosts.

Common errors and how to fix them

The output table is empty.
No http or https link and no email address was found in the data cells. Check that links include the scheme, and remember that the header row is not scanned.
A website in a cell is missing from the list.
Schemeless hosts such as www.example.com are skipped, because only http and https links are read. Add http:// to those cells before extracting, since the converter does not guess the scheme.

Best practices

  • Deduplicate the email addresses first if you need the number of people rather than the number of mentions.
  • Keep the count column when you sort, so you can tell a heavy domain from a single stray address.

Frequently asked questions

Is the count the number of unique people?

No. It counts matches. One person with an address and a profile link on the same domain adds two. Deduplicate the addresses first if you need people.

Why are IP-address links missing from the list?

Hosts written as IP addresses are not registered domain names, so they are skipped on purpose. Use Extract IP Addresses to list them.

For more background on data formats and conversion workflows, read our format guides.