Filter Excel Files Online
Filter rows in Excel files by column value, directly in your browser. Your data stays on your device.
How to filter Excel files
- Drop your file onto the upload area. It is loaded into the in-browser engine and the first 200 rows are shown.
- Pick the column to test from the Column list. It defaults to the first column in the file.
- Choose an operator: =, !=, >, <, >=, <=, LIKE, IS NULL or IS NOT NULL. Type the comparison value, unless you picked IS NULL or IS NOT NULL.
- Click Apply Filter. The tool shows how many rows match and previews the first 200 of them.
- Click Download to save the matching rows in the same format you uploaded.
Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.
Worked example
A bike-share operator wants to review only the longer trips from one morning's log, meaning rides of 30 minutes or more.
Input (Excel)
Excel workbook, first sheet (Sheet1)
| trip_id | start_station | duration_min | member |
|---|---|---|---|
| 501 | Harbour St | 12 | true |
| 502 | Park Ave | 47 | false |
| 503 | Harbour St | 31 | true |
| 504 | Mill Rd | 8 | false |
| 505 | Park Ave | 30 | true |
Settings
- Column: duration_min
- Operator: >=
- Value: 30
Result
| trip_id | start_station | duration_min | member |
|---|---|---|---|
| 502 | Park Ave | 47 | false |
| 503 | Harbour St | 31 | true |
| 505 | Park Ave | 30 | true |
duration_min is an integer column, so the value 30 is compared as a number, not as text. Three of five rows match. Trip 505 is kept because >= includes the boundary; with > it would be dropped. Matching rows keep their original order and every column is carried through unchanged.
Working with Excel files
Only the first worksheet is read. Cells are read as they are displayed, then typed. Plain numbers filter as numbers. Date cells load from their stored value, so a date shown as 3/2/26 arrives as 2026-03-02 and > compares real dates. A column formatted as currency arrives as text such as "$1,200.00", so > on it compares text, not amounts. Clear that format in Excel, or fix it with Find & Replace and Cast Column Types. Dates typed as text need Parse Dates. The header must sit in row 1. Title rows above it are read as data and can break type detection. The match count shown after filtering is the number of rows the new workbook will hold.
TRUE and FALSE cells load as a true/false column. Filter them with = and the value true or false. Formula cells are filtered on their last calculated result, so recalculate and save the workbook first if it is out of date. The download is a fresh .xlsx with one sheet named Sheet1. It holds values only, with no formatting, formulas or other sheets. Dates that loaded as real dates are written as YYYY-MM-DD text cells; others keep the text they were read as.
Frequently Asked Questions
Which sheet does the Excel filter work on?
The first sheet in the workbook. To filter another sheet, pull it out with the Excel Sheet Extractor first, then filter the result.
Is this the same as Excel's AutoFilter?
It is closer to AutoFilter plus copying the visible rows to a new workbook. Rows that fail the condition are removed from the download rather than hidden.
Can I combine several conditions, such as region = "EU" and amount > 100?
Not in one pass. The tool applies a single condition. Download the result and filter it again for the next condition, which gives the same result as AND. For OR logic or several conditions at once, use the SQL Query tool.
How does the LIKE operator work?
LIKE matches a pattern. % stands for any run of characters and _ for exactly one, so Park% matches every value starting with "Park". Without a wildcard, LIKE behaves like =. The match is case-sensitive.
Does filtering change the original file?
No. Your file is read in the browser and never modified. The matching rows are written to a new file that you download.
Related Tools
Sort Excel Files Online
Sort Excel files by any column, ascending or descending, directly in your browser.
Count Values in Excel Files Online
Group and count rows by any column in Excel files directly in your browser. Sort by frequency or value to find the most common entries — no upload required.
Aggregate Excel Files Online
Group and aggregate Excel files by any column directly in your browser. Calculate sum, average, min, max, and count for any numeric column — no upload required.
Filter CSV Files Online
Filter rows in CSV files by column value, directly in your browser. Your data stays on your device.
Filter Parquet Files Online
Filter rows in Parquet files by column value, directly in your browser. Your data stays on your device.
Filter JSON Files Online
Filter rows in JSON files by column value, directly in your browser. Your data stays on your device.
Excel Viewer Online
View and inspect Excel files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.
Convert Excel to Parquet Online
Convert Excel files to Parquet format directly in your browser. No upload required — your data never leaves your device.