Filter Excel Rows
Keep only the rows that match your conditions - equals, contains, greater than, and more - combine several, and download the result. No formulas, no upload.
Drop your file here or click to upload
Supports .xlsx, .xls, .xlsm, .xlsb, .csv · up to 50MB · or paste a file from your clipboard
How a Row Is Tested
Each condition names a column, an operator, and usually a value. Every data row is tested against every condition, and the Match all / Match any selector decides what to do with the results: AND keeps a row only when all conditions pass, OR keeps it when at least one does. There is no bracketing, so a mixed rule such as "A and (B or C)" has to be run as two passes. Your header row is never tested - it is copied straight through to the top of the result while First row is a header stays ticked.
| Region | Amount | Status | Region equals West AND Amount greater than 1000 |
|---|---|---|---|
| West | 1200 | paid | kept |
| West | 640 | paid | dropped - amount too low |
| east | 2400 | open | dropped - wrong region |
The Twelve Operators
equals and does not equal compare as numbers when both sides read as numbers, and as text otherwise. contains, does not contain, starts with, and ends with are always text tests. greater than, greater than or equal, less than, and less than or equal are numeric when both sides are numbers and fall back to alphabetical order when they are not. is empty and is not empty take no value and treat a cell of nothing but spaces as empty. All text comparison ignores letter case.
What Counts as a Number
A plain numeral, and nothing else. 1000 and -4.5 are numbers; 1,000, $1,200, and 45% are text, because the separators and symbols are part of the value. If a numeric-looking comparison keeps returning nothing, that is nearly always why - either your typed value has a separator in it, or the column arrived from an export with the numbers stored as text. Dates are a related case: they arrive as the serial number Excel stores, so filter on 45292 rather than 2024-01-01, or add a plain text date column to filter on instead.
Edge Cases
Leaving the value box empty changes the meaning of an operator rather than disabling it: contains nothing matches every row, while equals nothing matches only blank cells. Only the first sheet of the workbook is read. The row counter above the preview is live, so you can watch it as you tune a threshold; the preview itself shows the first 20 rows and the download contains all of them. That download is written as values in a single sheet, so number formats and any formulas in the source become plain results.
How to Filter Rows
- Upload the file - .xlsx, .xls, .xlsm, .xlsb, or .csv, read in your browser.
- Add your first condition - column, operator, value.
- Add more and choose AND or OR - the row count updates as you go.
- Download Matching Rows - a new workbook of the survivors, header included.
When a Different Tool Fits Better
If you want one file per value of a column rather than one filter at a time, Split Excel by Column Value does the whole split in one pass. If the goal is really an ordering with a light filter on top, Sort and Filter Excel adds multi-level sorting and a search-everything box. When the filter has to stay live inside the workbook, the FILTER function generator writes the formula. And if you are cutting columns rather than rows, use Excel Column Extractor.
Frequently Asked Questions
A value typed with a thousands separator is not a number to this tool. Comparisons are numeric only when the cell and your value both read as plain numbers, so type 1000 rather than 1,000, and remember that a cell holding $1,200 as text is not numeric either.
It falls back to alphabetical order rather than refusing. 'greater than m' keeps every value that sorts after m. That is occasionally useful for splitting a name list, and a trap if you expected a numeric column and one row contains text.
No. Every text comparison lowercases both sides, so contains 'west' matches West and WEST. There is no case-sensitive mode.
Use is not empty, which needs no value. A cell counts as empty when it is blank or holds only spaces, so a stray space does not sneak a row through as populated.
No. Only the first sheet of the uploaded file is read, and the download contains just the matching rows from it. Split the workbook first if the data you want is on a later sheet.