Filter CSV Cells
Return data in a CSV file that matches a pattern. Runs entirely in your browser, so your data never leaves your device.
0 chars · 0 lines
Output
The result appears here as you type.
How to use Filter CSV Cells
- 1. Paste the CSV. Drop your rows into the input pane. Filtering works on whole records: a row stays or goes based on whether any of its cells matches your pattern.
- 2. Write the pattern. Enter plain text in Pattern for a simple substring match, or tick Regular expression to use full regex syntax like ^lon.*$ or \d{4}. Case-sensitive controls whether letter case matters.
- 3. Choose keep or drop. By default rows with a matching cell are kept, like grep. Tick Keep non-matching rows to invert that, like grep -v, and tick First row is header (always kept) to protect your column names either way.
- 4. Copy the filtered rows. The output pane holds only the rows that survived. Copy them into a new file, a spreadsheet or the next tool in your cleanup chain.
When to use Filter CSV Cells
Filter CSV Cells is grep for tabular data: keep or discard rows based on whether their cells match a substring or a regular expression. It saves you from loading a whole file into pandas or a spreadsheet just to pull out the records that mention one thing.
- Extracting one region's records. A global sales file needs to become a London-only file for a regional manager. Filter on the city name and copy out just those rows, header included.
- Pulling error rows from a report. A batch job's result CSV mixes successes and failures. Filtering for the word FAILED isolates the problem records so you can retry or investigate only those.
- Removing rows by regex. Test accounts all have emails matching @example\.com. Turn on the regular expression and keep-non-matching options together to strip every synthetic user from a production export.
- Narrowing a file before sharing. A colleague needs only rows referencing one project code from a large timesheet export. Filter down to those records instead of sending the entire file.
Examples
Keep the rows that mention a city
Input
name,city Ada,London Grace,NYC
Output
name,city Ada,London
About the Filter CSV Cells tool
Filter CSV Cells runs as plain JavaScript in your browser tab, with no server behind it. Return data in a CSV file that matches a pattern. Whatever you put in stays on your device from start to finish.
The tool is part of EditSafely's CSV Tools section, 133 single-purpose utilities built around the same idea: open the page, get the result, keep your data to yourself.
You can shape the output with 5 settings, including Pattern, Regular expression, Case-sensitive and Keep non-matching rows, and the result refreshes the moment you change one. A worked example further down the page shows exactly what the tool produces for a real input.
That local-first design has practical benefits beyond privacy. The tool keeps working on a flaky connection once the page has loaded, results are instant because nothing round-trips to a server, and it is safe to use with confidential material.
Frequently asked questions
Does Filter CSV Cells cost anything?
Yes, it is completely free. All 2,658 tools on EditSafely work without an account, a subscription or usage limits.
Is it safe to paste sensitive or confidential data?
No data leaves your device. The whole tool is JavaScript that runs inside your browser tab, so there is no upload, no server-side processing and no log of what you did. If you disconnect from the internet after the page loads, it keeps working.
How much text can I process at once?
There is no fixed limit. Because the work happens on your own device rather than on a shared server, the practical ceiling is your machine's memory, which comfortably handles inputs far larger than typical online tools allow.
Do I need to sign up or install anything?
Nothing to install and no account needed. Open the page in any up-to-date browser, including on a phone or tablet, and the tool is ready.
How do I use the result?
The output panel has a one-click copy button, and you can keep refining the input while you work; the result updates in place as you type.