Filter CSV rows by column value: keep the leads whose title, country or any column matches
In short: Upload a list, choose a column and a condition, and keep the matching rows. Several values can be given at once, and the rows you remove are saved as a second file. Limit: It matches text only, so a synonym or a misspelling is not found.
Upload a CSV or .xlsx file, or paste it with a header row. Choose a column and a condition: contains, is exactly, starts with, ends with, is blank or is not blank. List one or more values, one per line. You download the rows that match and, as a second file, the rows that do not, each with every column kept.
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 filtered on a Title containing sales keep 2 and remove 3.
- Rows kept
- 2 of 5
- Column
- Title
- Condition
- contains sales
What this means for you
The right people can still have dead mailboxes; a check shows which addresses work.
- Contains, equals, starts, ends
- Several values at once
- Blank and not-blank tests
- Kept and removed files
- Filter
- CSV
- Lead list
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Filtered the list? Check the addresses you kept before the send.
- Download the rows kept, 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 filter the rows of a CSV by a column?
- Upload the file as a CSV or .xlsx, or paste the cells with the header row first.
- Choose the column to look in and the condition, such as contains any of.
- Type the values to look for, one per line. A row matches when its cell fits any one of them.
- Download the rows kept and, if you want them, the rows removed.
Example
- You enter
- Five rows with a Title column, filtered to keep the rows where Title contains sales.
- You get
- 5 rows read, 2 kept (Ava Stone and Eli Park) and 3 removed.
- Limits
- Runs in your browser; nothing is uploaded. It matches text only and says nothing about whether a kept address exists.
How are the values matched?
Each cell is trimmed first. Matching ignores upper and lower case unless you switch on exact matching. A row matches a condition such as contains when its cell fits any one of the values you typed, so sales and director keeps both a Head of Sales and a Managing Director.
The opposite conditions, does not contain and is none of, keep the rows that fit none of the values. Is blank and is not blank test the cell only and need no values.
Which conditions should I use for a lead list?
Use contains on a title column to keep a function, is exactly one of on a country or state column for a clean match, and ends with on an email column to keep an address ending such as .de. Use is blank on a phone or name column to pull out the rows that are missing it.
For job titles by seniority, the job title seniority filter understands levels such as VP and Director. To split by every value of a column at once, use split CSV by column value.
What does it not do?
It matches text, not meaning, so engineer will not find a developer. It does not combine two conditions on different columns in one pass; filter once, then filter the kept file again. To remove addresses by their domain, use remove emails by domain. See also clean the list before a campaign.
Who uses this tool, and for what?
- Cold emailers
- Keep the leads whose title contains sales or marketing, and set the rest aside.
- Marketers
- Keep one country or state of a customer export before a regional send.
- Analysts
- Pull out the rows with a blank phone number to see how big the gap is.
What can’t this tool tell you?
- It matches text only, so a synonym or a misspelling is not found.
- One column and one condition per pass.
- Leading and trailing spaces in a cell are ignored when matching, but not changed in the download.
- Only the first sheet of a workbook is read.
Common questions
- Can I give more than one value?
- Yes. Type one value per line. A row matches when its cell fits any one of them.
- Is the match case sensitive?
- Not by default. There is a switch for exact upper and lower case.
- How do I keep the rows where a cell is empty?
- Choose the condition is blank. To keep the rows that have a value, choose is not blank.
- Can I filter on two columns?
- One column per pass. Download the rows kept, load that file again and filter on the next column.
- Does the list need an email column?
- No. Any CSV works. If it has a column of addresses, the check button under the result carries the kept rows across.
- 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.