Category: Developer tools
CSV Row Filter
Keep only the CSV rows that match text or a pattern
Paste CSV data and keep only the rows where one column, or the whole row, matches a piece of text or a regular expression, with an option to invert the match. Runs entirely in your browser.
1 row(s) matched.
name,role,team,active Ada Lovelace,Engineer,Blue,true
Everything on this page is processed in your browser. Nothing is uploaded.
What this tool does
Cutting a large export down to the rows that matter is usually a search, not a sort: rows where a status column says "failed", or an email column matches a domain. This tool parses comma, semicolon or tab separated CSV, tests either one named or numbered column or the whole row against plain text or a regular expression, and rebuilds a CSV of just the rows that matched, or, with Invert on, the rows that did not.
How to use it
- Paste your CSV data into the input box, or load the example.
- Optionally set a column to filter, by 1-based position or by header name.
- Enter the text or pattern to match, and copy the filtered CSV.
Privacy
This tool runs entirely in your browser. Your input is never uploaded, stored or shared — closing the tab removes it.
Frequently asked questions
- Is my CSV data uploaded anywhere?
- No. Parsing and filtering happen in JavaScript running in the page, so spreadsheet exports never leave your device.
- What happens if I leave the column blank?
- Every column of each row is joined and tested together, so the match text or pattern can span the whole row rather than one field.
- Can I use a regular expression instead of plain text?
- Yes, switch Match mode to Regex; an invalid pattern is reported under the field rather than breaking the output.