CSV Row Filter

Keep CSV rows using an exact, contains or excludes text rule on one selected column.

Your input is processed in this browser and is not uploaded.

Comma-separated CSV only: up to 200,000 characters, 200 unique nonempty headers and 10,000 data rows.

Preserve mode keeps cell strings. Protection adds an apostrophe before cells beginning with =, +, - or @ after whitespace, including negative numbers. This changes values; review before opening in a spreadsheet.

Filter CSV records by a column value

Paste a comma-separated table with a header row. Choose a column, choose Contains, Equals or Excludes, enter a nonempty filter value, and select Run tool. The output keeps matching records in their original order and includes the header even when no records match.

Example: select a team

Load the example, choose the team column, select Equals, and enter Blue. Two Ada records remain and the Lin record is excluded. Filtering does not remove duplicates. Run CSV Deduplicator afterward if those repeated records should become one.

Rules are literal and case-sensitive

Contains keeps a record when the selected cell includes your text. Equals requires the complete cell to match. Excludes keeps records without that text. Blue and blue differ, and surrounding spaces are significant. These are text operations: entering 10 does not mean greater than ten, and regular-expression characters are treated literally. An empty filter value is rejected to avoid an ambiguous selection.

Troubleshooting an empty result

Check the selected column, spelling, capitalization and spaces. A header-only result means the CSV parsed successfully but no records matched. A parsing error instead means the input has invalid quotes, inconsistent row widths or unsupported headers. This version requires unique nonempty headers and supports up to 200 columns, 10,000 records and 200,000 characters.

Preserve export keeps original cell strings; optional spreadsheet protection prefixes formula-like values with an apostrophe, including negative numbers. Quoting and line endings are normalized. All processing remains in the browser. Changing input or any filter/export option clears the previous result and download.

Use CSV Column Selector to remove fields, or CSV to Markdown Table to prepare the selected records for documentation.