JSONToTable
Loading Excel Row Filter...
Please wait a moment

How to Filter Rows from an Excel File — Step by Step

Extract specific rows from any Microsoft Excel spreadsheet using column-based filter conditions and export only the matching rows to a new .xlsx file. No install, no server upload.

Step 1

Upload Your Excel File

Drag your file onto the upload zone or click to browse. The file is parsed locally usingSheetJS — no data is sent to any server. Supports .xlsx, .xls, and .csv:

•
Drag and drop: Drop any Excel file directly onto the upload zone
•
Browse files: Click Upload in the toolbar or click inside the upload zone to pick a file
•
Try sample data: Click "Sample" to load a built-in employee dataset and practice adding filter conditions right away
Step 2

Add Filter Conditions

Click "Add Filter" in the toolbar to add a condition row. For each condition, pick a column, an operator, and a value. Add multiple conditions and choose AND (all must match) or OR (any must match):

•
contains: Row includes the value anywhere in the cell (case-insensitive)
•
does not contain: Row is excluded if the cell contains the value
•
equals: Cell must exactly match the value (case-insensitive)
•
starts with: Cell must begin with the value
•
ends with: Cell must end with the value

Example: Filter where City equals "New York"

All rows (no filter):

NameCity
Lisa MartinezNew York
Linnea SmithLos Angeles
Mike JohnsonChicago
James LeeNew York

Showing 4 of 4 rows

City equals "New York":

NameCity
Lisa MartinezNew York
James LeeNew York

Showing 2 of 4 rows — only New York matches

Step 3

Export Matching Rows

Click "Export" to download a new .xlsx file containing only the rows that match all your active filter conditions. The exported file uses the same column headers as the original:

•
Only matching rows exported: The output file contains only the rows visible in the table after filtering
•
Row count shown live: The toolbar shows "X of Y rows" so you can verify the filter before exporting
•
Remove columns too: Use Excel Column Picker to trim columns before or after row filtering
•
View as table: No filters needed? Use XLSX to Table to browse the whole file as a searchable table

What is an Excel Row Filter?

An Excel row filter extracts a subset of rows from a spreadsheet based on conditions you define — for example, rows where a City column equals "New York", or where an Occupation column contains "Engineer". This is the browser-based equivalent of a Microsoft Excel AutoFilter or a SQL WHERE clause, applied without needing to open any application.

Row filtering is a fundamental step in ETL (Extract, Transform, Load) pipelines anddata cleansing workflows. Instead of writing a script or formulas, this tool lets you apply filter conditions directly on a spreadsheet and export only the matching rows to a new .xlsx file.

The tool uses SheetJS to parse yourOffice Open XML file entirely in the browser. No data is sent to a server. You can disconnect from the internet after the page loads and the tool will continue to work.

The output file is a standard .xlsx compatible with Google Sheets, LibreOffice, and Excel 2007 or later. Need to also remove unnecessary columns from the result? Combine this tool with Excel Column Picker to trim both rows and columns.

Common Use Cases

Regional Reports
Filter a national sales spreadsheet to only rows for a specific region or country before sharing with a regional manager, without sharing the full dataset.
Status Filtering
Extract only rows with a status of "Pending", "Failed", or "Overdue" from an order or task export for targeted follow-up.
Date Range Slices
Filter rows where a date column starts with "2024-" to extract a specific year's data from a multi-year master spreadsheet.
Data Cleansing
Use "does not contain" to remove rows with placeholder values like "N/A", "TBD", or "Unknown" before importing into a database or analysis tool.
Department Splits
From a company-wide HR export, filter by the Department column to create a separate file for each team without sorting or copy-pasting in Excel.
Compliance Extraction
Extract rows matching specific product codes, SKUs, or category labels from inventory or procurement exports for regulatory or audit reporting.

Multi-Condition Filter Example

You can combine multiple conditions with AND or OR logic. Here is an example of filtering employees from New York who are also engineers:

Condition 1: City equals New York
Condition 2: Occupation contains Engineer
Logic: AND — both conditions must match
NameCityOccupationSalary
Lisa MartinezNew YorkSoftware Engineer75000
Linnea SmithLos AngelesProduct Manager85000
Mike JohnsonChicagoData Analyst65000
James LeeNew YorkBackend Engineer90000
Sarah WilsonNew YorkUX Designer70000

Rows 1 and 4 match both conditions. Rows 2, 3, and 5 are excluded. The exported file contains only 2 rows.

Frequently Asked Questions

Is my data private?
Yes. All processing happens in your browser using SheetJS. No file or data is sent to a server. The tool works fully offline once the page is loaded.
Can I use multiple filter conditions?
Yes. Click "Add Filter" to add as many conditions as you need. Switch between AND (all conditions must match) and OR (any condition matches) using the toggle in the filter panel.
Are filters case-sensitive?
No. All filter operators are case-insensitive. "New York", "new york", and "NEW YORK" all produce the same result.
What if no rows match?
The table shows zero rows and the Export button is disabled. Adjust your filter values or operators to broaden the match, or check that your column selection is correct.
Can I filter numeric columns?
Yes. All cell values are compared as text. For example, filtering a Salary column with "contains 75" will match rows where the salary starts with, ends with, or contains the digits 75.
Can I combine row filtering with column trimming?
Not in a single step — but you can export the filtered rows from this tool and then open the result in Excel Column Picker to remove unwanted columns.

Related Tools

XLSX to Table

Upload an Excel file and view it as an interactive searchable table with multi-sheet support

Excel to Table

Upload an Excel (.xlsx, .xls) or CSV file and view it as a searchable, filterable HTML table instantly

Excel to JSON

Convert an Excel (.xlsx, .xls) or CSV file to JSON — array of objects or array of arrays

Excel to CSV

Upload an Excel file and convert any worksheet to CSV — copy or download the output

Excel Column Picker

Select specific columns from an Excel file, preview the result, and download a trimmed spreadsheet

CSV to Excel

Convert CSV files to Excel spreadsheets with professional formatting and styling