One mode for the whole list
Each condition names a column, an operator, and, except for the empty checks, a comparison value. AND keeps a row only when every condition matches. OR keeps a row when any one condition matches. The same column can appear more than once. This page does not mix AND and OR in one filter, and it does not offer parentheses. If no condition is set, Filter rows stops with an error and does not show the full table. A missing rule is not treated as “keep every row.”
The CSV viewer can search the displayed table, but its export still includes every loaded row. This page is the separate filter: the preview and the download both use the same match list. Rows that fail the rules are left out of the file you save.
Worked example
Input header Region, Product, Amount. Rows: East Desk 10, East Chair 5, West Desk n/a, west Desk 4, East Lamp with a blank amount, North Desk 10.
Use example rows applies AND with Region equals East and Amount greater than 6. The only match is East, Desk, 10. East, Chair, 5 fails the number rule. East, Lamp has a blank amount, so greater than does not match it. west is not East. West, Desk has n/a, which is not a plain number. North, Desk, 10 fails the region rule. The download for that filter is the header plus East, Desk, 10. It does not include the other five data rows.
Switch the same file to OR, with Region equals West or Amount equals 10. Amount equals is a text comparison, so the cell must be the characters 10. The matches, in file order, are East, Desk, 10; West, Desk, n/a; and North, Desk, 10. west, Desk, 4 stays out because west is not West and 4 is not 10. East, Chair, 5 and East, Lamp stay out as well. The page does not sort the matches and does not add a row that was not in the file.
Text, blanks, and numbers
Text operators are equals, does not equal, contains, does not contain, starts with, and ends with. They compare the cell text as stored. Letter case stays significant, and spaces stay part of the value. East does not equal east, and East with a trailing space does not equal East. These operators do not trim the cell or the comparison value, and they do not apply regular expressions. A blank comparison value is rejected. To test a blank cell, choose “is empty” or “is not empty.”
Is empty matches only the empty string. A cell that contains spaces is not empty. A missing cell on a short row is the empty string. Is not empty matches every other cell, including 0 and n/a.
Number operators are greater than, greater than or equal, less than, and less than or equal. A cell matches only when trimming its ends leaves a plain number: an optional plus or minus, digits, an optional decimal point, and an optional exponent such as 1e2. The exponent form 1e2 is the number 100. Words, currency symbols, percent signs, and thousands separators do not match. n/a, $5, 5%, and 1,000 fail a numeric condition. They are not counted as zero. If the comparison value itself is not a plain number, filtering stops with an error and does not pretend that nothing matched. Negative zero is compared as zero. A number that is too large to be finite, such as 1e309, does not match.
CSV and XLSX input
Paste CSV or choose a .csv, .tsv, or .txt file. The first non-empty record is the header, and the rows under it are the records. Quoted fields can contain the delimiter and doubled quotes. An unclosed quote stops the load with an error and no result table. Automatic delimiter detection looks at the header line and chooses among comma, semicolon, tab, and pipe. If the columns land in the wrong places, pick the delimiter and click Load data again. CSV text is read as UTF-8. Completely blank records are skipped before filtering, so they are neither matches nor non-matches.
An .xlsx workbook is read on this page as Office Open XML. After it loads, the worksheet list shows every sheet named in the file, with the first sheet selected. Switch sheets to filter that sheet instead. Older binary .xls workbooks are not read; save them as .xlsx or CSV first. The reader uses the value stored in the cell. A formula contributes that stored value when the file contains one, and this page does not recalculate the formula. Excel dates that were saved as serial numbers stay numbers. A text date stays text, so a number operator does not treat it as a calendar date. See Microsoft's file formats supported in Excel for the difference between .xlsx and older workbooks, and the CSV format specification, RFC 4180, for quoting.
What the download contains
The preview lists at most 12 matching rows, in the order they appear in the file. The CSV download contains the header and every match, including matches past the preview. If nothing matches, the download is the header and no data rows. That is a real result, not an error. Changing a condition, the AND/OR control, or the loaded sheet clears the previous download until you click Filter rows again, so the saved file cannot lag behind the rules on screen.
This tool does not remove duplicate rows. Remove duplicate CSV rows is a separate page. It also does not build a pivot table, calculate a new column, or sort the matches. The browser keeps the table in memory only. Refreshing or closing the tab clears it. There is no account, and the file is not sent to a server for the filter. Very large sheets still use memory on your device. Files over 10 MB, tables over 100,000 data rows, or tables over 1,000 columns stop with an error instead of a partial match list. Search volume for this page has not been verified.
Frequently asked questions
Does the download include rows that failed the filter?
No. The CSV contains the header and the matching rows only. Rows that fail the AND or OR rules are left out. The CSV viewer is different: its search changes the display, but its export still includes every loaded row.
Are text matches case sensitive?
Yes. East and east are different, and a trailing space stays part of the text. Text operators do not trim or ignore capitalization. They also do not apply regular expressions.
How do number comparisons treat blanks and words?
A numeric condition matches only when the cell is a plain number. Blank cells, n/a, currency symbols, percent signs, and thousands separators do not match. They are not treated as zero.
What if no condition is set?
Filter rows stops with an error and does not show the full table. This page does not treat a missing rule as keep every row.
Can one filter mix AND and OR?
No. One control applies to the whole list. AND means every condition must match. OR means any one condition is enough. There are no parentheses or mixed groups.
Is the spreadsheet uploaded?
No. The browser reads the file on your device. Closing the tab clears the working table unless you downloaded the CSV.