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

  1. Paste your CSV

    Paste or type it into the box, or press Try an example.

  2. Pick a column and a test

    For example city equals London, or age greater than 40.

  3. 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.

Related tools