Multiple Emails in One Cell: How to Split Them Before You Verify a List

A verifier checks one address per row, so a cell holding two or three addresses must be split first. Left as it is, a cell like jane@acme.com; sales@acme.com is read as one malformed address and comes back invalid format, and neither real address gets checked. Split on the separator, put each address on its own row, remove duplicates, then verify.

This turns up in exports from scrapers, event lists and CRMs, where one contact field accumulates several addresses. See also what to do when a lead has multiple email addresses for the choice of which one to send to.

Step 1: find the separator

Look at ten rows that have more than one address. Common patterns:

What you see	Separator
a@x.com, b@y.com	Comma and space
a@x.com;b@y.com	Semicolon
a@x.com / b@y.com	Slash with spaces
a@x.com then a line break, then b@y.com	Line break inside the cell
a@x.com or b@y.com	The word "or"

Mixed separators in one file are normal. Replace them with one first.

Step 2: split in Google Sheets

1. Add a helper column next to the email column.
2. Replace every separator with a comma using SUBSTITUTE, for example =SUBSTITUTE(SUBSTITUTE(A2,";",",")," or ",",").
3. Use =SPLIT(B2, ", ") to spread the addresses across columns, or =FLATTEN(ARRAYFORMULA(SPLIT(...))) to stack them into one column.
4. Trim spaces with TRIM.

For the rest of the sheet workflow, see verifying emails in Google Sheets.

Step 3: split in Excel

1. Select the column and choose Data, Text to Columns.
2. Pick Delimited and tick the separators you found.
3. Each address lands in its own column.
4. Move them into one column, keeping the contact's other fields with each, for example with Power Query's Unpivot.

Excel details are in verifying emails in Excel. If the file is too large for Excel, split a big CSV first.

Step 4: keep the contact's other fields

Copy the name, company and any custom fields to every new row. Otherwise a split row has an address and nothing to personalise with. Add a column recording which cell position the address came from if you may need to trace it.

Step 5: remove duplicates and blanks

After splitting, the same address can appear twice. Remove blank rows and exact duplicates before verifying so you do not spend checks on repeats. Removing blank rows from a CSV covers the blanks.

Step 6: verify and read the reasons

Upload the one-address-per-row file. Valid rows say "Mailbox exists". You may also see:

• Role-based address for shared mailboxes such as info@ and sales@.
• Mailbox not found for addresses the server says do not exist.
• Accepts all addresses where a catch-all domain cannot be confirmed.

If two addresses for the same person both come back valid, pick the personal one for cold outreach. See role-based email addresses before sending to a shared one.

Plans and trial

New accounts get 100 free checks with no card, enough to test a split file. Pro is $39 a month, with the first 100,000 checks a month at full speed, then slower, never cut off. Business is $99 and Agency is $249 with 750,000 checks a month. See pricing, or start on the verify page.

The free split multiple emails in one cell tool puts each address on its own row.