Extract emails from Excel, Google Sheets or CSV
Upload an Excel workbook (.xlsx, .xls), an .ods sheet or a CSV, or paste cells copied from a spreadsheet. The tool reads every cell on every sheet, pulls out each address, even from cells like Jane Doe <jane@acme.com>, and returns each one once with the sheet and column it came from. The file never leaves your browser.
Sample result
2 unique emails found in 1 sheet, the first in the Email column at cell B2.
- Unique emails
- 2
- Duplicates merged
- 1
- First found
- Leads › Email (B), B2
What this means for you
Get every address out of a spreadsheet, even ones in notes, without copying cells by hand.
- Every sheet and every cell is read
- Shows the sheet, column and cell found in
- Deduplicated with a count per address
- Pasted cells from a spreadsheet work too
- Excel
- Extract
- CSV
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
How do I extract emails from an Excel file?
- Upload the workbook, or copy the cells in Excel or Google Sheets and paste them into the box. Files can be up to 25 MB.
- Press Extract emails. Every sheet is read, including hidden ones, and every text cell is scanned.
- Check "Found in" to see which columns the addresses came from. Addresses found in a notes column are often contacts you didn't mean to export.
- Download the CSV, copy one address per line, or copy a semicolon-separated list to paste into Outlook's To or Bcc field.
Example
- You enter
- A workbook with a Leads sheet:
jane@acme.examplein the Email column twice andsam@yourcompany.examplein a Notes cell. - You get
- 2 unique addresses with 1 duplicate merged: jane@acme.example first found at B2 in Leads › Email (B), and sam@yourcompany.example at C4 in Leads › Notes (C).
- Limits
- Reads xlsx, xls, ods and CSV in your browser; an uploaded file can be up to 25 MB.
How do I extract email addresses from an Excel spreadsheet?
Upload the file above and press Extract emails; you get every address in the workbook, once each, with the sheet and column it came from. If your sheet has one clean email column, copying it works too. Real spreadsheets rarely do. CRM exports put "Jane Doe" <jane@acme.com> in one cell, event sign-ups have two addresses separated by a semicolon, and old contact sheets hide addresses in notes, CC columns and second tabs. Formulas like Excel's TEXTAFTER only handle one shape at a time.
This tool scans every text cell instead. It finds anything shaped like an address, checks the syntax with the same rules as our bulk syntax checker, lowercases it, and merges repeats so each address appears once with a count.
Is there a formula to extract an email address from an Excel cell?
Yes, for one cell shape at a time. For a single tidy column in Excel for Microsoft 365, =TEXTBEFORE(TEXTAFTER(A2,"<"),">") pulls the address out of a Name <address> cell. Google Sheets, and recent Excel for Microsoft 365 builds that include REGEXEXTRACT, can use =REGEXEXTRACT(A2,"[A-Za-z0-9._%+'-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}"). It returns the first address in a cell only, so a cell with two addresses loses one.
Formulas also leave you to deduplicate. Excel's Remove Duplicates ignores case but not stray spaces, so jane@acme.com and jane@acme.com with a trailing space stay as two rows. If your list is already one address per row, remove duplicate emails handles case, spaces and Gmail dots for you.
Can it extract emails from hyperlinks and hidden sheets?
Yes. In .xlsx and .ods files it reads text cells, inline strings, the text results of formulas and mailto: links, and records the sheet and cell of each address. Numbers and dates are skipped because an address is never one. Values produced by formulas that point at other files can be stale; if a column looks empty, copy it and use Paste Values first.
Legacy .xls files use a binary format. The tool scans them as text, which finds the addresses but not their sheet or column, and can miss an address split across two internal records in a very large file. Saving as .xlsx gives the full result. Password-protected workbooks are encrypted and can't be read until the password is removed.
Should I verify the emails before importing them?
Yes, if the file is more than a few weeks old or was typed by hand. A spreadsheet is a snapshot. People change jobs, companies rename domains, and any address typed by hand can have a typo. B2B contact data decays steadily, so the older the file, the more of these addresses will hard bounce. Importing them into Mailchimp, HubSpot or an outreach tool and sending is how you find out the expensive way. Verifying first is how you find out before your sender reputation pays for it. Our guide to verifying emails in Excel walks through the full clean-up.
Is this faster than an Excel formula?
For one clean column a formula is fine. For a real export, the differences add up:
| This tool | Excel or Sheets formula | |
|---|---|---|
| Several addresses in one cell | Each extracted separately | First match only |
Name <email> and mailto: cells | Handled | One formula per shape |
| Every sheet, including hidden ones | Yes, in one pass | One sheet at a time |
| Duplicates and stray spaces | Merged automatically | Remove Duplicates misses trailing spaces |
| Where each address came from | Sheet and column shown | Not tracked |
Google Sheets formula for the first address in a cell: =REGEXEXTRACT(A2,"[A-Za-z0-9._%+'-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}").
Who uses this tool, and for what?
- Cold emailers
- Pull every address out of a scraped or purchased lead sheet, including the ones buried in notes and second tabs, before it goes into Instantly or Smartlead, then verify what is left.
- Agencies
- Clients send contact lists in every shape: one tab per event, names and addresses in one cell, CC columns. Extract once and hand back a single deduplicated CSV with the source column of each address.
- Recruiters
- Turn an ATS or job-fair export into a clean list, and use "Copy for Outlook" to paste candidates into Bcc without exposing anyone's address.
- SaaS teams
- Merge sign-up exports from different tools into one list, then check it with remove duplicate emails and the list health check before a product announcement.
What can’t this tool tell you?
- It finds text shaped like an email address. It cannot tell you the mailbox still exists; that needs an SMTP mailbox check.
- Legacy
.xlsfiles are scanned as text, so you get the addresses but not their sheet and column. - Password-protected workbooks are encrypted and can't be read until you remove the password in Excel.
- Formula results that depend on other, unopened files can be stale. Paste Values first if a column looks empty.
Common questions
- How do I extract multiple email addresses from one Excel cell?
- Upload the file here: a cell like "jane@acme.com; sam@acme.com" gives two separate addresses. In Excel itself, Data > Text to Columns with a semicolon delimiter splits the cell, or TEXTSPLIT(A2,";") does it with a formula in Excel for Microsoft 365, but you then have to trim spaces and deduplicate yourself.
- How do I export email addresses from Excel to Gmail?
- Extract and deduplicate them here, download the CSV, then import it in Google Contacts (Import > select file). For a one-off message, copy them one per line and paste into the To or Bcc field; Gmail accepts a list separated by commas or new lines.
- How do I extract email addresses from an Excel file?
- Upload the .xlsx or .xls file above and press Extract emails. Every cell on every sheet is scanned, each address is pulled out once, and you can download them as CSV or copy them. In Excel itself, a formula such as TEXTAFTER or REGEXEXTRACT works only for one cell shape at a time.
- Can it pull an email out of a cell with a name in it?
- Yes. Cells like "Jane Doe <jane@acme.com>", "mailto:jane@acme.com" or two addresses separated by a semicolon or comma all work. Each address is extracted on its own and lowercased.
- How do I export emails from Excel to Outlook?
- Extract them here, then use "Copy for Outlook" to copy every address as one semicolon-separated list. Paste it into Outlook's To, Cc or Bcc field. For large sends, use Bcc or a mailing tool so recipients don't see each other's addresses.
- Does it read every sheet in the workbook?
- Yes, including hidden sheets. The results show which sheet and column each address came from, so you can spot addresses from a tab you didn't mean to include.
- Is my spreadsheet uploaded anywhere?
- No. The file is opened with your browser's own built-in decompression and read on your device. Nothing is sent to our servers.
- Does extracting an address mean it works?
- No. It means the text is a well-formed address. Whether the mailbox still exists can only be answered by the mail server that hosts it, through a mailbox check, which this free tool doesn't do.
Sources
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? $9 one-time covers 2,500 emails, no subscription
One plan, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.