Email Extractor

Pull every email address out of a block of text, an email thread, a web page’s HTML, a CSV export or a document you have copied. The extractor finds addresses wherever they sit, including inside angle brackets, mailto: links and quotes, removes duplicates, can decode addresses written as “name [at] domain [dot] com”, and gives you a clean list to paste into a spreadsheet or an email’s To field.

How to use this tool

1. Paste the text, HTML or CSV.
2. Keep “remove duplicates” on, and decoding on if people wrote [at] and [dot].
3. Optionally keep or leave out certain domains and choose the order.
4. Choose new lines, commas or semicolons (for Outlook) and copy the list.

Formula

Address = local part @ domain, where the domain is one or more labels separated by dots and ends in a letter-only top-level domain

The local part accepts the characters RFC 5322 allows outside quotes (letters, digits and ! # $ % & ' * + / = ? ^ _ ` { | } ~ -), with single dots between them; letters can be from any script, as in internationalised email (RFC 6531). Domain labels are 1–63 characters and cannot start or end with a hyphen. A trailing full stop or bracket is never part of a match. Matches whose “domain” ends in an image or file extension, such as logo@2x.png in HTML, are skipped. Duplicates are compared without regard to case.

Example

The sample text gives 4 addresses: sales@example.com, Support@Example.com, jane.doe@news.example.org and bob@mail.example.net. SALES@example.com is dropped as a duplicate of sales@example.com, “bob [at] mail [dot] example [dot] net” is decoded, and logo@2x.png is skipped as an image file name. The domain table shows example.com twice.