How to extract email addresses in Excel & Google Sheets

Quick answer: The fastest way is to copy your cells and paste them into a browser-based CSV email extractor — it finds the email column, removes duplicates and gives you a clean list without a single formula. Prefer to stay in your spreadsheet? UseTEXTAFTER in Excel or REGEXEXTRACT in Google Sheets (both below).

Method 1 — Paste it into an extractor (fastest, no formulas)

If you just want the addresses out, this takes about ten seconds and handles the messy cases — addresses mixed with names, multiple emails in one cell, or stray punctuation — that trip up formulas.

1. In Excel or Google Sheets, select the column (or the whole range) and copy it.
2. Open the CSV email extractor and paste into the box.
3. It detects your columns and auto-selects the one containing emails — or pick a column yourself from the dropdown.
4. Duplicates are removed automatically. Copy the list, or download it as TXT or CSV.

Because it runs in your browser, nothing is uploaded — safe for customer and lead lists. It also reads data copied straight from spreadsheet cells (tab-separated), so you don't need to export a .csv file first.

Method 2 — Extract emails in Excel with a formula

Use this when each cell holds text with a single address inside it, and you want the result to live in the spreadsheet.

Excel 365 / 2021: TEXTBEFORE + TEXTAFTER

There's no single "extract email" function, but if the address is one token surrounded by spaces you can isolate it. When a cell contains only the address, no formula is needed — filter or copy the column directly. For an address embedded in a sentence, Flash Fill is usually fastest: type the correct email next to the first two or three rows, then press Ctrl+E and Excel fills the pattern down.

Any Excel version: Flash Fill

1. Add a new column next to your data.
2. Type the email from the first row by hand.
3. Start typing the second, and when Excel previews the rest, press Enter — or press Ctrl+E to fill the whole column.

Flash Fill is pattern-based, so double-check the output on rows with unusual formatting.

Method 3 — Extract emails in Google Sheets with REGEXEXTRACT

Google Sheets has a proper regular-expression function, which makes this clean. In a new column next to your data (say the text is in A2):

=REGEXEXTRACT(A2, "[A-Za-z0-9._%+\-]+@[A-Za-z0-9.\-]+\.[A-Za-z]{2,}")

Drag it down the column and it returns the address from each row. If a cell has no address, the formula shows an error — wrap it inIFERROR(…, "") to leave those blank. Note thatREGEXEXTRACT returns only the first match per cell, so for cells with multiple addresses, Method 1 is the better choice.

After you've extracted: clean the list

A raw extraction usually still needs a tidy-up. Once you have the addresses, it's worth a quick pass to remove duplicates, validate the formatting(to catch typos like gmail.con), or run the whole thing through the email list cleaner to also strip role accounts like info@ and noreply@ before you import.

Working from plain text — an email thread, a web page — rather than a spreadsheet? Use the general email extractor instead.

Frequently asked questions