SPARKPOND / FILTER CSV

Filter CSV Rows Online

Build readable conditions and preview which rows match before changing the export. View sorting stays separate from persistent filtering.

✓ Processed locally✓ No account✓ Original unchanged

LOCAL WORKSPACE

Open your data file

CSV, TSV. lub upuść je tutaj.

Download the example file ↓

Focused purpose

What this tool does

Filter CSV or TSV rows locally with equals, contains, ranges, dates, regex and AND/OR rules. Keep or remove matches and download without an account.

  • ✓ Text and numeric operators
  • ✓ Date ranges
  • ✓ Safe regular expressions
  • ✓ AND/OR groups

Workflow

How to use it

  1. 01

    Choose a column and operator.

  2. 02

    Add rules and preview matching rows.

  3. 03

    Select keep or remove, then export.

Available controls

Available options

  • Equals, differs, contains and starts with.
  • Greater, less and inclusive ranges.
  • Combine rules with AND or OR.
  • Keep matches or remove matches.

Active French customers

Example before and after

Only rows matching country FR AND status active are needed.

Before

id,country,status
1,FR,active
2,US,active
3,FR,inactive

After

id,country,status
1,FR,active

Expected result: The AND group keeps one matching row.

Download example ↓

Practical scenarios

Common use cases

Export one country or date period.

Remove test records.

Find rows that violate a naming pattern.

HONEST LIMITS

Important limitations

  • iNumeric comparison requires values that parse under the confirmed locale.
  • iRegular expressions use bounded safe patterns and reject risky constructs.

FAQ

Questions about this tool

Can I combine AND and OR?

Yes. Conditions are grouped explicitly and the preview updates before export.

Can I remove matching rows instead of keeping them?

Yes. The same rule group can keep or exclude matches.

Are regular expressions supported?

Yes, with safety limits; invalid or risky expressions return a clear error.