Filter CSV rows
Filter CSV by a named column with exact, contains or not-equals text matching.
- 1Add input
- 2Adjust settings
- 3Get your result
Tool input and files are processed in this browser without being uploaded.
Before you start
Keep complete CSV records when one selected column matches your text condition. Preview both kept and excluded rows before downloading.
How to use this tool
- Paste a headered CSV, TSV or delimited table, or choose a UTF-8 file.
- Choose the input delimiter, an actual column header, a condition and comparison text. Optionally ignore letter case.
- Filter records, check the kept and excluded previews, then copy or download the complete filtered CSV.
Supported inputs and limits
Use a unique, nonempty header row and equal row widths, up to 1,000 columns and 200,000 cells. Paste up to 1 MiB or upload a UTF-8 file up to 10 MiB.
Matches are literal text, case-sensitive by default; surrounding spaces remain significant. Ignore case compares lowercased strings, without Unicode case folding or language-specific matching. Blank equals and not-equals values are supported; contains needs a nonempty value.
Files and input are processed in this browser. No account needed.
Table headers, preview cells and displayed column or filter values show at most 240 Unicode characters, followed by an ellipsis when shortened. Metadata JSON previews show the first 20,000 Unicode characters when limited; use the complete metadata JSON copy button for the full document. CSV copy and download remain complete.
Worked example
Example input
name,age Mori,3 Amy,2
Example options
{"column":"name","value":"Mori","operation":"equals"}Example output
name,age Mori,3
When something does not work
Choose the correct delimiter and a column present in this file. Check quoted cells, unique headers and consistent row widths.
Frequently asked questions
How can I check the result from Filter CSV rows?
Check the selected header, condition, kept and excluded counts, and both previews. Copy and download include all kept rows. Cell text, including formulas and leading zeros, is preserved; output uses comma-delimited CSV with normalized quoting and record endings.
What should I check before using the result?
This is one-column literal text matching, not numeric or date comparison, regular expressions or a search across all columns. The input needs unique headers and equal row widths.
Is my input sent to a server?
No. Tool input is processed in your browser, not sent to a server. Temporary workspaces stay in the same tab and are cleared by a refresh or tab closure. Save the results you need.