← All postsPerson using Email Extractor on a laptop for a real ops lists task

Pull a Clean Email List Out of a Messy Text Paste

Extract unique email addresses from a pasted thread or export, handle [at] [dot] forms, sort and export to CSV, and use the list responsibly.

email extractoremail listtext cleanupremove duplicatesCSV exporttext toolsbrowser tools
4 min readText & Writing

A conference volunteer coordinator pastes a 200-line export into a document: names in angle brackets, cc lines, signatures, a billing contact in parentheses and a line about a logo file. They need every address once, in a clean list, for a confirmation note to people who registered. Email Extractor does the finding so nobody has to hunt with ctrl-F.

Paste the text and the tool lists every address it detects, shows a count of unique addresses, and lets you copy the list or download a CSV. It runs in your browser.

Extract email addresses from text

Extract email addresses from text

What it returns on a realistic paste

Here is a short sample, like a few lines of that export. One line reads From: Priya Nair <priya.nair@Northwind-Labs.com>; cc: Tom.Ellis@northwind-labs.com. Another says Reply to PRIYA.NAIR@northwind-labs.com about the booth. A billing line holds accounts@harbourtrading.co.uk, (mailto:ops@harbourtrading.co.uk). There is banner@2x.png and sprite.svg, then j.okafor [at] summitevents [dot] org, then sam@gmailcom, lee@@example.com, and a last line Dana.Wu@bright.io. with a full stop after it.

With default settings the tool returns five addresses: priya.nair@northwind-labs.com, Tom.Ellis@northwind-labs.com, accounts@harbourtrading.co.uk, ops@harbourtrading.co.uk and Dana.Wu@bright.io. Three things happened that matter. The two spellings of Priya's address were counted once, because duplicates are compared ignoring case. The trailing full stop after Dana's address and the closing bracket after ops were not included. And banner@2x.png was skipped, because names ending in file types such as png, svg, css or pdf are filtered out to stop asset names looking like contacts.

The broken ones, sam@gmailcom and lee@@example.com, never appear. The tool only recognises text shaped like a local part, an @ sign and a domain with a real ending. It does not check that a mailbox exists, so a closed account with a correct shape is listed like a working one.

Turning on the bracket option

Switch on "Also find name [at] domain [dot] com" and the sixth address, j.okafor@summitevents.org, joins the list. The option recognises [at], (at), [dot] and (dot) in any letter case, with or without spaces around them. Plain words without brackets, such as "name at domain dot com", are left alone on purpose, because turning every "at" into an @ would invent addresses from ordinary sentences.

Steps

  1. Paste the text into the large box. A thread, a copied web page, or a spreadsheet column all work.
  2. Read the counter: "6 unique emails found". It counts unique addresses, not how many times they appeared.
  3. Switch on the bracket option if people obscured their addresses that way.
  4. Turn on Lowercase if your mailing tool is picky about capitals. Sort A-Z puts the list in alphabetical order.
  5. Press Copy All for the clipboard. The Copy as comma-separated switch decides whether the copy has one address per line or a comma between addresses.
  6. Press Download CSV for a file named extracted-emails.csv with the columns email and domain, one row per address, following your sort and lowercase choices.

Reading the CSV for quick audits

Because the CSV has a domain column, you can sort in a spreadsheet and see at a glance that eight of your 40 addresses come from one company, or that a personal mailbox slipped into a list that should be corporate only. Typos in the domain, such as gmial.com, will show up as a one-off domain in the sort, which makes them easy to spot and fix by hand.

If you need to normalise something first, for instance replacing a stray semicolon pattern or a company name in the source text, Find and Replace can do it before extraction. Case Converter helps when you want display names in a particular style.

A worked cleanup pass

Suppose your export has the same person three times: once from a registration form, once from a cc line and once in an old signature, with capital letters in different places. After the pass, you have one row. Now compare the count with your registration total. If 212 people registered and the tool found 198 unique addresses, 14 people either gave no address, wrote it in a form the tool cannot read, or share a mailbox. Search the original text for "@" near names that did not make the list and fix those by hand. That reconciliation takes five minutes and prevents the "I never got the message" email later.

Mistakes to avoid

  • Trusting the count as a delivery list. Shape is not validity. Expect some bounces whatever you do.
  • Pasting text that includes addresses you were never given permission to use. The tool displays an on-screen reminder for a reason: laws such as CAN-SPAM in the United States and GDPR in Europe apply to how you use addresses, and consent matters more than how you obtained them.
  • Mixing personal addresses of attendees into a shared sheet that everybody can read. Share only what each recipient needs.
  • Forgetting the filter that drops file-type endings. If a genuine address ends in .pdf or .js, it will be skipped, which is rare but possible.
  • Expecting addresses split across lines to be rebuilt. Fix the line break first.

Where the list goes next

Many people paste the result into a mail-merge tool, a contacts import or a spreadsheet. If you need the web links from the same document, URL Extractor does the equivalent job, and the text tools category has sorting and counting helpers for what comes next.

For privacy, the pasted text stays in your browser while the tool works. Each use counts toward your 10 trial usages for the day, so paste the whole export once instead of in pieces.

This tool finds addresses and does not give legal advice on who you may contact.

Which text do you pull addresses from most often, forwarded threads, web pages or spreadsheet exports? Tell us on the contact page.

Open Email ExtractorOpen Case ConverterOpen Find & ReplaceOpen URL Extractor