Extract just the records and columns you need. Combine conditions, preview the matching and unmatched groups, and download the complete results locally.
Processed in your browserNo account requiredEncoding and delimiter controlsIncomplete exports are blocked
Choose a CSV file, paste data or try the sample. Nothing is uploaded.
What this tool does
Filter CSV Rows and Columns
The filter applies up to 20 text, decimal-number or ISO-date rules to every loaded CSV record. Combine rules with AND or OR, choose output columns and download either the matching records or their complement. The preview limit never limits the download.
How to use it
Open a CSV, TSV or TXT file or paste delimited data.
Choose a column, comparison and value for each filter rule.
Choose whether all or any rules must match, and select the output columns.
Apply the rules and download matched or unmatched CSV records.
Common tasks
Extract active customers or orders above a chosen amount.
Select records before or after a date in YYYY-MM-DD format.
Keep only selected columns and download records that did not match for review.
Privacy and local processing
Files and pasted text are processed on this device. The tool does not upload your data, change your original file, or fetch remote URLs. Download the result groups after reviewing the rules and preview.
Supported edge cases
Text rules preserve distinctions between identifiers such as 00123 and 123.
Numeric conditions accept plain decimal values, without thousands separators or exponents. Non-numeric cells do not match numeric rules.
Date conditions accept valid YYYY-MM-DD dates only; ambiguous or invalid dates do not match.
Quoted line breaks remain inside cells. Invalid CSV and oversized inputs block processing rather than dropping records.
Frequently asked questions
Does the download contain only the first 100 rows?
No. Only the preview is limited to 100 records. The download contains all records in the chosen group.
Can I combine multiple conditions?
Yes. Choose AND to require every condition, or OR to accept a record matching at least one condition.
Can I export rows that do not match?
Yes. The unmatched download contains all source records excluded by the combined rules, using the same selected output columns.
Can I export selected columns without removing rows?
Yes. Use a text-contains rule with an empty value, which matches every record, then select the output columns.