Filter CSV Rows
Pick a column and a condition, and keep only the rows that match. All thirteen conditions run in your browser, so your CSV never leaves your device.
- Free, no sign-up
- Files stay on your device
- Thirteen conditions
- Regex supported
- Runs on your device. Files are never uploaded.
- Free and unlimited. No sign-up, no watermark.
Filter CSV rows in three steps
No account, no email, no waiting for an upload.
- STEP 01
Add your CSV
Load a CSV, TSV or TXT file from your device.
- STEP 02
Set the rule
Name the column by header, letter or number. Choose a condition such as contains or is greater than, and type the value.
- STEP 03
Download the filtered file
Only matching rows remain, with the header kept on top.
What Filter CSV rows does, and what it doesn't
We'd rather tell you up front than surprise you after the download.
What you get
- Text conditionsContains, does not contain, is exactly, is not, starts with and ends with.
- Number and date comparisonIs greater than, at least, less than and at most compare numbers and dates properly. Otherwise they fall back to text order.
- Empty checksKeep rows where the column is empty or is not empty.
- Regular expressionsUse a pattern for advanced matches, with or without case sensitivity.
- Format keptSeparator, quoting and line endings are preserved.
Good to know
- One rule per runEach pass uses one column and one condition. For several rules, filter the result again.
- No match, no fileIf nothing matches, the tool reports it and does not create an empty file.
- CSV onlyFor Excel workbooks, convert with XLSX to CSV first, filter here, then go back with CSV to Excel.
Your spreadsheets never leave your device
The tool runs inside your browser instead of on our servers, so there is nothing to upload, store or delete afterwards.
Typical online tool upload
Your file travels over the internet, sits on someone else's computer for a while, and you wait for the upload and the download.
Mediaextractr no upload
The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.
When people use Filter CSV rows
Pull one customer segment
Keep orders where Country is India or Status is Shipped.
Find the big numbers
Keep sales above a threshold.
Extract rows with a domain
Keep emails that end with a company domain.
Remove incomplete records
Keep rows where a required column is not empty.
Mediaextractr vs typical upload tools
| MediaextractrPrivate | Typical upload tools | |
|---|---|---|
| Your file is uploaded | Never | Yes |
| Sign-up needed | No | Often, after a few files |
| Daily file limit | None | Often 1–2 free files |
| Watermark | Never | Sometimes |
| Wait for upload & download | No | Yes |
| Speed on very large files | Depends on your device | Depends on their servers |
How comparisons work
For greater than and less than, values are first read as numbers, then as dates, and only then as text. So 10 is greater than 9, and 2024-05-01 is later than 2024-04-30. Spaces around the cell are ignored.
Choosing between contains and exactly
Contains is forgiving and matches the text anywhere. Is exactly needs the whole cell to equal your value. Starts with and ends with are handy for codes and domains.
Need to do several filters? Run them one after another. To tidy the result, use Sort CSV rows or Remove duplicate CSV rows. To cut a file by category into separate files rather than filtering, Split CSV into smaller files can split by column value.
Questions, answered
How do I filter a CSV file without Excel?
Add the CSV, choose a column and condition, and download the matching rows.
Is the CSV uploaded to be filtered?
No. Filtering is done in your browser.
Can I filter by a number range?
Run it twice, once with at least a minimum and once with at most a maximum.
Is the match case sensitive?
Not by default. Tick Match case to make it so.
What happens if no rows match?
You get a message with the number of rows checked, and no file.
Does it work on Android, iOS and desktop?
Yes, in any modern browser, including mobile ones. Filtering a big CSV is smoother on a computer.