How it works
Parse CSV and retain rows whose selected cell equals, contains, or differs from the entered case-sensitive text.
Input definitions
- CSV with header
- Plain text; maximum 200,000 characters.
- Exact column name
- Enter the value in the labeled unit.
- Filter text (empty allowed)
- Enter the value in the labeled unit.
- Match mode
- Choose Equals / Contains / Does not equal.
A worked example
- CSV with header
- name,city,score Ada,London,10 Lin,Paris,20 Sam,London,30
- Exact column name
- city
- Filter text (empty allowed)
- London
- Match mode
- Equals
Assumptions & limits
Plain text on your device, with no remote fetch. CSV input is comma-separated with unique nonempty headers, at most 1,000 rows and 50 columns; downloads escape spreadsheet formula prefixes.
Sources & review
Maintained by AnsRio. Methods and examples use automated checks; this does not imply independent professional certification.
Method updated 2026-10-17. Content checked against the stated method and examples. Our verification approach.
Common questions
Is CSV filtering case sensitive?
Yes. Header names and text matches are exact and case sensitive. Quoted commas are parsed inside cells; the output retains the original column order.
How does Filter CSV rows by a column work?
Parse CSV and retain rows whose selected cell equals, contains, or differs from the entered case-sensitive text.
What are the limits of Filter CSV rows by a column?
Plain text on your device, with no remote fetch. CSV input is comma-separated with unique nonempty headers, at most 1,000 rows and 50 columns; downloads escape spreadsheet formula prefixes.
How do I keep the full worksheet?
Run the tool and choose Download file. The on-page table is a preview and may show only the first 20 rows; the downloaded file contains the full result. CSV downloads escape spreadsheet formula prefixes. Inputs and files are processed on your device.