CSV Filter
Keep only the CSV rows where a column contains, equals, starts with, ends with or matches a value, or is above or below a number.
Processed on your device. Files are not uploaded
How to filter the rows of a CSV file
Paste your CSV
Paste or type it into the box, or press Try an example.
Pick a column and a test
For example city equals London, or age greater than 40.
Copy or download
Save the rows that match.
Worked example
This is what CSV Filter gives for its own sample values. Open the tool above and change anything to try your own.
CSV
name,team,city,age Ada,Platform,London,36 Linus,Kernel,Helsinki,54 Grace,Compilers,New York,85 Ada,Platform,London,36 Alan,Research,London,41
- Delimiter
- Detect automatically
- Column (name or number)
- city
- Keep rows where the column
- equals
- Value
- London
Filtered CSV
name,team,city,age Ada,Platform,London,36 Ada,Platform,London,36 Alan,Research,London,41
About CSV Filter
Keep only the CSV rows that match a test on one column: equals, contains, starts with, ends with, matches a pattern, is above or below a number, or is empty or not empty.
FAQs
Is matching case-sensitive?
No.
Can I use a regular expression?
Yes. Choose matches the pattern.
Can I test the pattern first?
Use Regex Tester.