CSV Row Filter
Find the rows you need in a CSV file. Keep or exclude matches based on text in the columns you choose.
Filter a CSV table
- Paste a table or choose a local UTF-8 file. Set its separator and whether the first row is a header.
- Read the CSV, choose columns and add conditions. Choose whether all or any conditions must match.
- Keep or exclude the matching rows, then review and download the result.
How matches are found
Each condition uses the original column position, including when header names repeat or are blank.
Text comparisons distinguish uppercase and lowercase and keep spaces. A cell containing a space is nonempty.
Matching rows and kept rows can differ. Exclude matches keeps the remaining data rows in their original order.
Examples
Keep rows whose Status equals paid and whose Location contains Centro.
Find incomplete records by selecting Is empty for either the Email or the Order ID column.
Input and output
Use a rectangular UTF-8 table up to 5 MiB. An unquoted first record such as sep=; produces an input error because it looks like a spreadsheet separator directive.
The download uses comma-separated fields and preserves decoded text, including leading zeros and line breaks inside cells. Reopening the file here applies the input limits and separator directive rule. For example, a retained sep=; field can become the first record and be rejected when reopened here.
Local filtering
Your browser reads and filters the table on your device.
CSV row filter questions
Sources
These references describe CSV record syntax and the positional structure of tables.
- IETFrfc-editor.orgRFC 4180Section 2 explains commas, record endings, quoted fields and escaping a quote.
- W3Cw3.orgW3C tabular data modelThe rows section describes ordered cells and their correspondence with table columns.
References checked on 19 November 2026.
Related tools
JSON to CSV Converter
Convert flat JSON records to delimited text with first-seen columns, original number spellings and explicit empty-value rules.
Open tool — JSON to CSV ConverterCSV Column Editor
Select, reorder and rename columns from a local CSV table.
Open tool — CSV Column EditorCSV Delimiter Converter
Convert CSV separators, preview real columns and spot import problems. Works locally with CSV, TSV and text; values remain unchanged.
Open tool — CSV Delimiter ConverterCompare Two CSV Files
Match rows by a key column and find added, removed and changed records.
Open tool — Compare Two CSV FilesCSV Duplicate Finder & Remover
Find exact duplicate CSV rows or repeated IDs. Review conflicting values, keep original data and download retained, removed and unresolved records.
Open tool — CSV Duplicate Finder & RemoverCSV Merger
Combine rows from several CSV files by exact column name. Preview alignment and download CSV with a merge report.
Open tool — CSV MergerCSV to JSON Converter
Convert CSV text or UTF-8 files to JSON objects or arrays, keeping cells as strings without guessing data types.
Open tool — CSV to JSON ConverterCSV Splitter
Split a CSV by rows or exact file size. Keep headers and download each part.
Open tool — CSV Splitter