Primary email picker: one best address per contact from several email columns
In short: Reads every email column and every address in a cell, ranks them (at the company's website, other company address, personal mailbox, role inbox) and adds primary_email and other_emails columns. Limit: It ranks by the kind of address; it can't tell which one the person still reads.
A primary email picker chooses one address per contact when an export has several: Email, Secondary Email, Personal Email, or two addresses in one cell. Upload the CSV and each row's addresses are ranked: at the company's website domain first, then another company address, then a personal mailbox, then a role inbox such as info@. You get a primary_email column with the rest kept in other_emails.
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
5 contacts, 8 addresses: one primary_email each, company address first.
- Primary picked
- 4 of 5
- Company address
- 3
- Personal mailbox
- 1
What this means for you
The rest stay in other_emails as a fallback if the primary bounces.
- Several columns or one cell
- Company, personal, role ranked
- primary_email column added
- Others kept as fallback
- Apollo
- ZoomInfo
- CSV
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
One address per contact. Does it deliver?
- The top-ranked address can belong to someone who left; the next one in other_emails is the fallback.
- Upload the primaries at /verify for a live mailbox check, then swap the ones that bounce.
- The first 100 email checks are free with a Google sign-in, no card.
How do I pick one email per contact from a CSV with several?
- Upload or paste the CSV from Apollo, ZoomInfo, HubSpot or a merged list. Every column of addresses is found, and cells with several addresses are split.
- Tick Prefer personal mailboxes for a consumer list; leave it off for B2B.
- Press Pick one per contact. A website column, if there is one, ranks addresses at the company's own domain first.
- Download the CSV with primary_email, primary_type and other_emails columns, and point your sequencer at primary_email.
Example
- You enter
- A 5-row CSV with email, secondary_email, personal_email and website: Jane with
info@,jane.doe@and a Gmail address at northwind.example; Sam with an old-domain and a current-domain address; Ana with only an Outlook.com address; Tom with two addresses in one cell; Kim with none. - You get
- Jane:
[email protected](at the website's domain), withinfo@and Gmail in other_emails. Sam:[email protected]. Ana: her Outlook.com address (personal). Tom:[email protected]. Kim: no address. - Limits
- Runs in your browser with no row cap; an uploaded file can be up to 25 MB.
Which email should I use when a lead has several?
For B2B, the address at the company's own domain: it's the one tied to the job you're writing about. When there's a website column, an address at that site's domain ranks first; any other company address comes next, then a personal mailbox at Gmail, Outlook.com or Yahoo, and a role inbox such as info@ or sales@ last, because it reaches a team rather than the person. Ties go to the leftmost column, which is usually the main Email field. See what to do when a lead has multiple email addresses.
For a consumer list the personal mailbox is often the one people read, so Prefer personal mailboxes ranks it first.
Which columns are read?
Every column whose header says email (Email, Work Email, Secondary Email, Personal Email, Email 2) and any other column where addresses make up a fair share of the cells. Status and confidence columns such as Email Status are skipped. Cells with several addresses separated by semicolons, commas or spaces are split, as the split multiple emails in a cell tool does.
Is this faster than COALESCE or IF formulas in a sheet?
| This tool | Spreadsheet formula | |
|---|---|---|
| First non-blank column | Yes | =IF(A2<>"",A2,B2) |
| Company over personal over role | Ranked | A nested formula per rule |
| Several addresses in one cell | Split | SPLIT plus more columns |
| The other addresses kept | other_emails column | By hand |
Who uses this tool, and for what?
- Cold emailers
- Turn a lead export with three email columns into one column a sequencer can send to.
- Sales ops
- Merge CRM contacts from several sources and keep one primary address per person.
- Marketers
- Pick the personal address for consumer campaigns and the work one for B2B.
What can’t this tool tell you?
- It ranks by the kind of address; it can't tell which one the person still reads.
- A company that uses a different domain for email than for its website ranks as another company address, not first.
- Free mailbox providers are recognised from a fixed list.
Common questions
- How do I choose between work and personal email for a lead?
- For B2B outreach, use the work address at the company's domain. For consumer lists, the personal mailbox is often better. This tool ranks them either way, with role inboxes last.
- Is a role address like info@ ever picked?
- Only when it's the contact's only address. It's labelled Role address so you can set those rows aside.
- What happens to the other addresses?
- They're kept in an other_emails column, in rank order, so you have a fallback if the primary bounces.
- Does it work with Apollo's Email, Secondary Email and Tertiary Email?
- Yes. Every email column is read left to right, and Email Status-style columns are ignored.
- Is the file uploaded?
- No. It runs in your browser. Only the optional mailbox check at the end sends the primary addresses, after you press the button and sign in.
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
Plans from $9 a month, 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.