DoItAl

Data utility

CSV Filter & Extract Rows

Filter CSV rows by one or more column conditions, preview kept and excluded records, and download both outputs privately in your browser.

Browser-local • No upload

1. Add CSV or delimited data

Drop a CSV or TSV file here

or choose a file from this device

or paste data

2. Confirm input structure

Delimiter

—

Data rows

—

Columns

—

Input size

—

UTF-8 text up to 10 MB. Processing is memory-based on this device; previews show at most 50 rows while downloads include the complete result.

3. Build filter conditions

Filtering selects rows only. It does not clean values, combine datasets, or create one file per group.

Match logic
Action

Condition 1

Empty means exactly empty. Whitespace is preserved. Numeric rules accept plain finite numbers and do not guess locale formats.

4. Review kept and excluded rows

The two outputs are complementary, preserve source order, and make the filter reversible.

Add data and valid conditions to preview both outputs.

Continue with

Filter rows without changing their values

CSV Filter & Extract Rows selects complete records using explicit text, number, or empty-value conditions. Combine up to ten rules with AND or OR, then keep matching rows or remove them. Source row order, column order, leading zeros, long identifiers, quoted delimiters, and embedded newlines remain intact in the exported CSV.

Kept and excluded outputs make filtering reversible

The review shows both sides of the operation before download. The kept and excluded datasets are complementary, so every source row belongs to exactly one output. An empty cell means exactly empty; spaces are not silently trimmed. Numeric rules skip non-numeric cells and report the count rather than guessing.

Choose the adjacent CSV tool by job

CSV Cleaner changes values or structure, removes duplicates, and resolves messy headers. CSV Merge & Join combines datasets. CSV Split & Partition creates multiple files by size, count, or exact group value. This filter tool only selects or removes rows using conditions.

Private, bounded browser processing

Input data and comparison values stay in this browser. V1 accepts one file up to 10 MB, renders at most 50 preview rows, and includes every processed row in downloads. Pro batches accept up to ten files and 30 MB combined. This is a memory-based workflow, not a multi-gigabyte streaming engine.

What this tool does

Selects or removes complete records using up to ten text, numeric, or empty-cell conditions and previews both kept and excluded rows.

How to use it

  1. Open or paste a CSV/TSV and select the relevant columns.
  2. Add conditions, choose AND or OR, and choose keep or remove.
  3. Review both partitions and download the kept, excluded, or both outputs.

Worked example

AND rules ‘status equals paid’ and ‘amount greater than 100’ keep only rows satisfying both. OR keeps rows satisfying either. Numeric conditions skip non-numeric cells instead of guessing.

Processing and explanation

Filtering preserves cell text, column order, and source row order. Kept and excluded outputs are complementary: every row belongs to one partition. An empty cell is exactly empty, not a space-only value.

Limits and common mistakes

Single input up to 10 MB, 10 conditions, and 50-row previews. Filtering does not clean values, combine tables, or change column layouts.

Privacy and your input

Condition values and table content remain local and never enter URLs or analytics.

Frequently asked questions

Can excluded rows be recovered?
Download the excluded partition before clearing the input; the original file is also unchanged.
Does an empty rule match spaces?
No. Spaces are not silently trimmed into empty values.

Material content update: