CSV email column finder: which column holds the email addresses?
In short: Upload a CSV or sheet, or paste the cells, and every column is scored by how many of its cells are email addresses, whatever the header says. Download the list with the email column moved to the front. Limit: It checks the shape of each cell only and cannot say whether a mailbox exists.
Upload a CSV or .xlsx file, or paste the cells, and the tool scores every column by how many of its cells are email addresses, whatever the header says. You see the best column, the share of each column that is an address, and cells that hold an address with extra text. It works with no header row.
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
In an example sheet of four columns, Contact is the email column: 3 of 4 cells are addresses.
- Best column
- Contact
- Messy cells
- 1
- Header row
- Found
What this means for you
The header is not trusted; each column is scored by what its cells hold.
- Works with no header
- Share of each column
- Messy cells counted
- List with the column first
- CSV
- Columns
- Lead list
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Found the column, now check the mailboxes.
- Choose the column and download the list, 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 find the email column in a CSV?
- Upload the file as a CSV or .xlsx, or paste the cells. A header row is optional.
- Press Find the email column.
- Read the table: each column shows how many cells are addresses and its share of the filled cells. The best column is marked.
- Pick the column you want and download the list with it moved to the front, ready to upload for checking.
Example
- You enter
- Example sheet with the columns Name, Notes, Contact and Phone and four rows. Three Contact cells are plain addresses and one reads Cara Lin <cara@example.net>.
- You get
- Contact is the best column: 3 of its 4 cells are addresses (75%) and 1 more is an address with a name around it. Name, Notes and Phone hold no addresses.
- Limits
- Runs in your browser. It checks the shape of each cell and does not say whether a mailbox exists.
How does it pick the column?
Each column is read cell by cell. A cell counts as an address when it has the shape name@domain.ending and nothing else in it. The column with the most address cells is marked as the best one, and the table shows the share of the filled cells in every column that are addresses.
The header is not trusted. A column called Email that holds phone numbers scores zero, and a column with no name that holds addresses scores high. If the first row already holds an address, the file is treated as having no header row.
What are messy cells?
A messy cell has an @ but is not a clean address, such as Jane Doe <jane@example.com> or two addresses in one cell. They are not counted as addresses, and the table shows how many each column holds so you know the column needs cleaning first. Use the extract email from cell tool or split multiple emails in a cell to fix them.
What should I do with the column?
Download the list with the email column first, then clean it with the email list cleaner or check it for broken rows with the CSV broken row fixer. Before you import a file anywhere, read clean CSV columns before import.
Who uses this tool, and for what?
- Cold emailers
- Find the address column in a purchased or exported file before you format it for a sequencer.
- Sales ops
- Tell which of several email-like columns in a CRM export holds the main address.
- Data cleaners
- Check an unnamed or mislabelled column before an import.
What can’t this tool tell you?
- It checks the shape of each cell only and cannot say whether a mailbox exists.
- A cell with an address and extra text counts as messy, not as an address.
- Only the first sheet of a workbook is read.
- Columns with fewer than half their cells filled can still score a high share of what is there.
Common questions
- Does it need a header row?
- No. If the first row holds an address it is treated as data, and the columns are called Column 1, Column 2 and so on.
- What if two columns hold addresses?
- Both are listed with their counts. The one with more addresses is marked best, and you can choose either to move to the front.
- Does it check that the addresses are real?
- No. It only checks that a cell is shaped like an address. Whether the mailbox exists is a separate check.
- Why is my column marked as a few addresses?
- Under 40 percent of its filled cells are addresses, so the column is mixed. Look at the cells that are not addresses first.
- Does it read every row?
- Yes, every row of the file is read.
- Is my file uploaded anywhere?
- No. The file is read in your browser.
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.