Skip to main content

CSV Filter

Filter CSV rows by column conditions

Filter a CSV down to just the rows you need without opening a spreadsheet or writing a script. Upload or paste the file, build one or more conditions against any column, and download only the matching rows.

Conditions cover the comparisons real filtering needs: equals and not equals, contains and does not contain, starts with and ends with, greater than and less than, is empty and is not empty, plus a regular-expression match for anything more specific. Multiple conditions combine with AND when every rule must hold, or OR when any one is enough.

The matching row count updates as you edit the rules, so you can tell immediately whether a filter is too strict before exporting. Everything runs locally, which makes this usable on exports containing customer or financial data.

Files stay on this deviceRuns entirely in your browserFree — no signup

Drop your file here or browse from your device

Accepts CSV, TSV, TXT. Maximum input: 10 MiB. Files above this hard limit are rejected before local processing.

How to Use

  1. Upload your CSV file or paste CSV data
  2. Add a condition: pick a column, an operator, and a value
  3. Add more conditions and choose whether they combine with AND or OR
  4. Check the matching rows in the preview, then download the filtered CSV

Features

  • Multiple filter conditions across any columns
  • Combine rules with AND or OR logic
  • Operators: equals, not equals, contains, not contains, starts with, ends with
  • Numeric comparison with greater than and less than
  • Empty and not-empty checks for finding gaps in data
  • Case-insensitive regular-expression matching
  • Live matching row count and preview before you export
  • Runs entirely in your browser — no upload

Use Cases

  • Pull one region, status, or category out of a large export
  • Find rows with missing values before an import
  • Extract records above or below a numeric threshold
  • Isolate rows matching a pattern such as a code or ID format
  • Trim a large file to a relevant subset before sharing it
  • Build a working list without writing a spreadsheet formula

Frequently Asked Questions

What filter operators are available?

Equals, not equals, contains, does not contain, starts with, ends with, greater than, less than, is empty, is not empty, and a regular-expression match.

Can I apply more than one filter at once?

Yes. Add as many conditions as you need and choose AND, where every condition must match, or OR, where any single match is enough.

How does regex matching work?

Enter a standard regular expression and it is tested against the cell value, case-insensitively. An invalid pattern simply matches nothing rather than breaking the filter.

Are greater than and less than numeric or alphabetical?

They compare numerically when both values parse as numbers. Mixed or non-numeric columns will not compare the way you expect, so check the preview.

Does filtering change my original file?

No. The source file on your computer is untouched; the download is a new CSV containing only the matching rows.

How do I find rows with missing data?

Use the is empty operator on the column in question. It is the fastest way to spot gaps before an import that will reject incomplete records.

Is there a row limit?

Filtering runs locally, so the practical limit is your device memory rather than a server cap. Very large files may be worth splitting first.