Email columns to rows: one row for every address
In short: Upload a list that keeps addresses in separate columns, such as Work email and Personal email. Every address becomes its own row with the other columns copied, a column says which one it came from, and repeats for the same contact are dropped. Limit: It rearranges addresses; it cannot tell which one the person reads.
Upload a list where each contact has addresses in more than one column, such as Email 1, Email 2 and Personal email. The tool finds the address columns, lets you change them, and writes one row for every address with the contact's other columns copied. A new column says which column each address came from, and the same address twice for one contact is kept once.
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. Check your list free nowSee pricing
Sample result
Four contacts become four rows: two for the first, one each for the next two, none for the last.
- Rows out
- 4 rows
- With several addresses
- 1
- With none
- 1
What this means for you
Every address now sits in the Email column, so a check covers the second and third addresses too.
- Address columns found for you
- Other columns copied
- Source column named
- Repeats kept once
- Emails
- Columns
- CSV
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
A second or third address needs checking as much as the first.
- Copy the Email column from the file you just made, or use the check button under the result.
- Upload or paste it at /verify. Every address gets a live mailbox check, and the first 100 email checks are free with a Google sign-in, no card.
How do I turn several email columns into rows?
- Upload the list (.xlsx or CSV), or paste the cells with the header row first.
- Check the columns ticked as holding addresses, and tick or untick any that were missed or wrongly chosen.
- Read the counts: rows out, contacts with several addresses, and contacts with no address (dropped).
- Download the CSV and verify the Email column, so every address is checked and not only the first.
Example
- You enter
- Four contacts with Work email, Personal email and Other email columns: one with two addresses, one with one, one whose Personal and Other email columns hold the same address, and one with none.
- You get
- Four rows out: two for the first contact, one each for the next two. The repeated address is kept once, the contact with no address is dropped, and each row names the column its address came from.
- Limits
- Runs in your browser; nothing is uploaded. Files up to 25 MB.
What does the output look like?
Every column that is not an address column is copied to each new row, followed by an Email column holding one address and a column called Email column that names the column the address came from. A contact with three addresses becomes three rows with the same name and company. A contact with none is dropped and counted. Addresses are lower-cased, and a cell holding several addresses separated by semicolons, commas or spaces gives one row per address.
Why make one row per address?
Verification tools and most import files read one email column. An address that sits in a second or third column is never checked, and its bounce shows up later. One row per address lets you check them all, then keep the working ones. To pick a single best address for each contact instead, use the primary email picker.
How are repeats handled?
If the same address appears in two columns of one contact's row, it is kept once, in the first column. The same address on two different contacts is kept on both rows, since it may belong to a shared mailbox; remove it with the duplicate email remover if you want it once.
Who uses this tool, and for what?
- Sales ops
- Flatten a CRM export with Email, Email 2 and Personal email before a verification run.
- Cold email senders
- Test every address a data provider returned for a person, not only the first.
- Agencies
- Prepare a client's multi-column contact sheet for a one-column sequencer import.
What can’t this tool tell you?
- It rearranges addresses; it cannot tell which one the person reads.
- A column of phone numbers or notes that happens to hold an address is treated as an address column if ticked.
- A contact with no address is dropped, not kept as an empty row.
- Header names are copied as they are, so rename them first if the importer is strict.
Common questions
- Which columns does it choose?
- A column is chosen if at least half of its filled cells hold an address, or if its header mentions email and it holds at least one. You can change the choice before downloading.
- What if one cell has two addresses?
- Each address gets its own row. Separators of semicolons, commas, spaces and line breaks are read.
- Does it check whether the addresses exist?
- No. It only rearranges the file. Use the check button under the result, or upload the file at /verify.
- Are rows with no address kept?
- No. They are dropped and counted, so you can see how many contacts had none.
- Is my list uploaded to SimpleVerifier?
- No. The file is read and rewritten in your browser.
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.