Split CSV into complete and incomplete rows: keep only the rows with every required field filled
In short: Tick the columns every row must have. You get a complete file and an incomplete file that says which columns each row is missing. Placeholders like n/a count as blank. Limit: It checks that a cell is filled, not that its content is right.
Upload a CSV or .xlsx file, or paste it with a header row. Tick the columns every row must have filled, such as Email, First name and Company. Rows with all of them go in one file. Rows with a gap go in another, with a column naming what is missing. Placeholders such as n/a count as blank unless you untick that.
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
Five example rows split into 2 complete and 3 incomplete; each gap is named: First name, Email and Company, with n/a counted as blank.
- Complete rows
- 2
- Columns required
- 3
- Placeholders
- Blank
What this means for you
A filled cell is not a working mailbox; a check shows which addresses exist.
- Choose the required columns
- n/a counts as blank
- Missing column named
- Two files to download
- Required
- CSV
- Gaps
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Kept the complete rows? Check their addresses before the send.
- Download the complete rows, or use the check button under the result, which carries their addresses across.
- 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 split a CSV into rows that are complete and rows that are not?
- Upload the file as a CSV or .xlsx, or paste the cells with the header row first.
- Tick the columns every row must have filled.
- Choose whether placeholders such as n/a and - count as blank.
- Check the counts and download the complete rows, the incomplete rows or both.
Example
- You enter
- Five rows with Email, First name and Company all required: one has no first name, one has no email and one has n/a for Company.
- You get
- 2 complete rows (Ava and Eli) and 3 incomplete: ben@globex.de is missing First name, the Cara row is missing Email and dev@hooli.com is missing Company, because n/a counts as blank.
- Limits
- Runs in your browser; nothing is uploaded. It checks that a cell is filled, not that it is right.
When should I keep only complete rows?
A mail merge that uses a first name and a company writes a broken line for a row with either blank. An import to a CRM may reject rows without an email. Splitting first means the clean rows go ahead and the gaps are set aside to be filled, not lost.
To see how full each column is before deciding which to require, use the CSV fill rate checker.
What counts as blank?
A cell that is empty or holds only spaces is blank. With the placeholder option on, cells that say n/a, na, none, null, nil, unknown, tbd, a dash, a question mark or #N/A also count as blank. The text is compared after trimming and in lower case. A zero is a value, not a blank.
The option is on by default because lead exports often fill gaps with these words, and a first name of n/a would otherwise reach a person.
What does the incomplete file add?
Each incomplete row gets one extra Missing cell naming its gaps, such as First name; Company, so you can fix them in bulk or send the file back to whoever exported it. A column that is not ticked is never checked, so a gap there does not move a row. To filter by one column's value instead, use filter rows by column value.
Who uses this tool, and for what?
- Marketers
- Send a personalised campaign only to rows with a name and a company.
- CRM admins
- Set aside rows an import would reject, with the reason beside each.
- Cold emailers
- Keep only leads with every field a template needs.
What can’t this tool tell you?
- It checks that a cell is filled, not that its content is right.
- The placeholder list is fixed; other stand-ins such as a row of x are not recognised.
- A cell with a few spaces and a dash is treated as blank only when it is exactly one of the placeholders.
- Only the first sheet of a workbook is read.
Common questions
- Is a row with a blank in an unticked column complete?
- Yes. Only the ticked columns are checked, so a gap anywhere else does not move a row to the incomplete file.
- Does it check that an email is valid?
- No. It only checks that the cell is filled. The check button under the result sends the addresses of the complete rows to the verifier.
- Is 0 treated as blank?
- No. A zero, like any other value, counts as filled.
- Can I turn off the placeholder rule?
- Yes. Untick it and only empty or space-only cells count as blank.
- Do I lose the incomplete rows?
- No. They download as their own file with every column kept and a Missing column added.
- Is my file uploaded?
- No. The file is read in your browser and goes nowhere.
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.