Filter CSV rows

Keep only the rows you need from a CSV file, such as orders from one country or amounts above a threshold, without opening a spreadsheet.

Processed on our server Free, no account needed

Drop files or a folder

    Large CSV exports are often too big to open comfortably in a spreadsheet, or you need the same subset again and again. This tool reads the file, keeps the rows that match one rule, and writes them to a new CSV with the same columns.

    How do I set the rule?

    You give three things: the column name, a comparison and a value.

    • Contains keeps rows where the column includes the text anywhere, such as gmail.com in an email column.
    • Equals keeps rows where the column matches the value exactly.
    • Greater than and less than compare numbers, such as amounts above 100 or stock below 5.

    The column name must match the header in your file, including capitals and spaces. If it does not, the tool tells you which columns it found so you can correct it.

    Is the match case sensitive?

    No. Utrecht, utrecht and UTRECHT all match each other, with contains and with equals. Equals also ignores spaces at the start and end of a cell. For greater than and less than, use a plain number with a dot as the decimal separator, such as 1250.50; cells that are not plain numbers, including 1.250,50 or €100, are left out.

    Which files work?

    CSV files with a header row, separated by commas, semicolons, tabs or pipes; the separator is detected automatically. UTF-8 files, including those Excel saves with a byte order mark, are read correctly. The output keeps all columns, the original header and the same separator as your file.

    Can I filter on more than one condition?

    One rule per run. For two conditions, run the tool twice: filter by country, then filter the result by amount. In the pipeline builder you can chain both filters as steps and run them over a folder of exports; you can try it on up to 3 files for free.

    Is it private?

    Filtering runs on our server. Your file is uploaded over an encrypted connection, processed in Germany and deleted automatically within two hours.

    How big can the file be?

    Files up to 50 MB are free without an account, within the free daily allowance of 20 jobs. Pro takes up to 500 MB.

    How to filter CSV rows

    1. Drop your .csv file onto the drop zone.
    2. Enter the column name exactly as it appears in the header.
    3. Choose contains, equals, greater than or less than, and type the value.
    4. Click Filter and download the filtered CSV.

    FAQ

    Can I remove rows instead of keeping them?

    Not directly. Filter for the rows you want to keep instead.

    Why is my filtered file empty?

    No row matched. Check the value for typos and, for numbers, the decimal separator.

    Can I also drop columns?

    Yes, with CSV Columns, before or after filtering.

    Does it change the original file?

    No. You download a new file with the matching rows.