Split multiple email addresses in one cell into separate rows
In short: Finds every address in a cell, whether separated by semicolons, commas, spaces or line breaks, and gives one row per address with the other columns copied, one column per address, or the first address only. Limit: It finds address-shaped text; it can't tell you which mailboxes exist.
To split multiple email addresses in one cell, paste the column or upload the CSV here and choose One row per address. Every address in the cell, separated by semicolons, commas, spaces or line breaks, gets its own row with the other columns copied. You can also get one column per address (email_1, email_2) or keep only the first.
Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. See pricing
Sample result
A cell with sales@northwind.example; jane.doe@northwind.example became two rows.
- Cells with 2+
- 3 cells
- Rows in
- 5
- Fullest cell
- 3 addresses
What this means for you
The other columns are copied to each new row, so the file imports cleanly.
- Splits on ; , spaces and line breaks
- Reads Name <address> and mailto:
- One row or one column per address
- Other columns copied to each row
- Split
- Excel
- CSV
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
How do I split several email addresses in a cell into rows?
- Paste the column, or the whole sheet copied from Excel or Google Sheets, or upload the CSV. The column with the most addresses is found automatically.
- Choose the layout: one row per address (the other columns are copied to each row), one column per address, or the first address only.
- Leave Drop an address already used on an earlier row ticked to remove repeats across rows.
- Press Split the addresses, check the preview and download the CSV, or copy the addresses one per line.
Example
- You enter
- A 5-row CSV whose emails column holds
sales@northwind.example; jane.doe@northwind.example,Sam Lee <sam@contoso.example>, ops@contoso.example, sam@contoso.example, one address, an empty cell and three addresses on separate lines. - You get
- With One row per address: 9 rows out, 8 unique addresses, company and website copied to each row. 3 cells held 2 or more, the fullest held 3, and the repeated
sam@contoso.exampleis kept once. - Limits
- Runs in your browser with no row cap; an uploaded file can be up to 25 MB.
How do I split multiple email addresses in one cell in Excel?
In Excel 365, =TEXTSPLIT(A2,";") splits a cell into columns, and =TEXTSPLIT(A2,,";") into rows. That works for one separator in one cell. Real exports mix separators (a@x.com; b@y.com, c@z.com), put a name around the address (Sam Lee <sam@acme.com>) or break lines inside the cell, and you need the other columns copied to each new row.
For a whole sheet, Excel's Power Query has Split Column, By Delimiter, with Advanced options, Split into Rows, which copies the other columns. This tool does the same in one step for any mix of separators, and reads only the addresses, so names and stray text drop out.
How do I split emails in one cell in Google Sheets?
=SPLIT(A2,";") splits one cell into columns; wrap it in TRANSPOSE for rows, and =FLATTEN(SPLIT(A2:A,";")) turns a whole column into one list. Like TEXTSPLIT, it splits on the characters you give and keeps the spaces and names around each address.
To keep the company or contact name next to each address, paste the whole range here instead and download the One row per address CSV.
Why do some cells have more than one email address?
Because many sources store all of a contact's addresses in one field: website scrapers list every address found on a page, CRMs export secondary emails into the same column, and forms let people type two addresses. Email platforms such as Mailchimp and most cold email tools expect exactly one address per row, so these rows are rejected or imported with only the first address.
Cells with several addresses often include role inboxes such as info@ or sales@ next to a person. After splitting, the role-based email filter can take those out.
Is this faster than TEXTSPLIT or Power Query?
| This tool | TEXTSPLIT / SPLIT | Power Query | |
|---|---|---|---|
| Mixed separators (; , space, line break) | Yes | List each one | One delimiter per step |
| Name <address> cells | Address only | Keeps the name | Keeps the name |
| Other columns copied to new rows | Yes | No | Yes |
| Repeats across rows | Optional | No | Remove Duplicates step |
Who uses this tool, and for what?
- Cold emailers
- Turn a scraped lead sheet where one cell lists every address on a website into one lead per row for Instantly or Smartlead.
- CRM admins
- Split the secondary-email field of a HubSpot or Salesforce export into rows before a re-import.
- Event organisers
- Fix registration exports where one person typed two addresses into one field.
- Agencies
- Normalise a client's spreadsheet into one address per row before you quote or verify it.
What can’t this tool tell you?
- It finds address-shaped text; it can't tell you which mailboxes exist.
- Text around an address in the same cell (a name, a note) is dropped from that cell.
- Only the column with the most addresses is split; other columns are copied as they are.
- An address with a typo stays as typed; run the typo checker after splitting.
Common questions
- How do I separate multiple emails in one cell?
- Paste the column here and choose One row per address. Each address gets its own row with the other columns copied. In Excel 365, TEXTSPLIT does it for one cell and one separator.
- How do I split a cell into multiple rows in Excel?
- Use Power Query: Split Column, By Delimiter, then Advanced options, Split into Rows. In Excel 365, =TEXTSPLIT(A2,,";") splits one cell into rows.
- Can I put each email in its own column instead?
- Yes. Choose One column per address and the output has email_1, email_2 and so on, as many columns as the fullest cell needs.
- Does it keep the name if a cell says Sam Lee <sam@acme.com>?
- It keeps the address and drops the text around it. The other columns of the row, such as a name column, are kept.
- Is my file uploaded?
- No. It is read and split in your browser and nothing is sent anywhere unless you choose to check the addresses afterwards.
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? Starter at $9/mo covers 2,500 emails a month, cancel anytime
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.