Data tools

CSV Row Filter

Filter CSV rows with typed text, number, date, boolean, and regex rules.

Processed locally in your browser. Your input is not uploaded to our server.

Rule logic
Rule 1

Enter or load CSV data to begin.

How to use Filter CSV Rows

  1. Paste CSV or TSV records, or select a local file.
  2. Add typed column rules and choose whether all or any must match.
  3. Confirm the matching count, then download matching or non-matching rows.

Supported behavior

CSV Row Filter builds explicit rules against parsed columns while preserving original column order. Each rule selects a column, data type, operator, comparison value where needed, and case behavior for text. Text rules cover equality, containment, prefixes, suffixes, regular expressions, and empty checks; numbers support comparisons and ranges; dates support before, after, on, and range operations; booleans are handled as typed values. Multiple rules can require all matches with AND or any match with OR. Matching-row counts update in preview, and both matching and non-matching rows can be downloaded. Invalid regular expressions affect only their own rule, while ambiguous dates require an explicitly selected input format. Pasted CSV or TSV, values, and filter rules remain entirely in your browser and are never uploaded. Auto typing is convenient but cannot infer every identifier or regional date correctly, so choose Text for values such as leading-zero codes and set date interpretation deliberately.

  • Ambiguous date text cannot be compared until its parsing format is selected.
  • Rules compare cell values only and do not support joins, formulas, or cross-row aggregates.

Examples

                item,stock
Pencils,12
Paper,3
Folders,0
              

Result: Rule stock < 5 → item,stock Paper,3 Folders,0

                id,status
1,ready
2,review
3,blocked
              

Result: Rule status starts with “re” → id,status 1,ready 2,review

Common use cases

  • Select inventory rows with quantity below a reorder threshold.
  • Find records whose status begins with an approved prefix.
  • Separate events before a specified date into a review file.

Frequently asked questions

What is the difference between all and any rules?

All uses AND so every rule must pass; any uses OR so one passing rule is enough.

Can I filter numeric ranges?

Yes. Number rules include Between plus greater-than and less-than variants.

Does one bad regex stop every rule?

No. A regex error is isolated to the invalid rule and shown for correction.

Can rejected rows be saved?

Yes. Matching and non-matching records are available as separate downloads.