CSV Row Filter
Keeps only the rows where one column matches the condition you set.
Loading the tool…
Processing happens locally in your browser.
What you paste or load is processed by this page and is not uploaded to a server. Nothing is stored unless you use a control that says it stores something, and you can clear anything this site has kept from the privacy page.
How to use this tool
- Paste the CSV.
- Name the column, pick a condition and type the value to compare against.
- Filter the rows and download the matching subset.
What csv row filter does
This is the spreadsheet autofilter, without the spreadsheet. Choose a column, choose a comparison, type a value, and the rows that match come back as a CSV file you can carry on working with. Text comparisons are case-insensitive because that is almost always what is wanted when filtering a category or a region.
The empty and not-empty comparisons are the ones worth remembering. Finding the rows where a required field was never populated is the fastest way to size a data quality problem, and it needs no value typed at all. The greater-than and less-than comparisons read the values as numbers, so they behave sensibly on scores, amounts and counts.
Frequently asked questions
No. Contains, equals, starts with and ends with all compare case-insensitively, which is nearly always what is wanted when filtering a region or category.
Not in one pass. Run the filter, copy the result back into the input, and apply the second condition to it.
Choose the column and the "Is empty" condition, and leave the value box blank. That is the quickest way to size a completeness problem.