\n
#017 · Sort Filter & Search Tool

Filter Excel Rows

Keep spreadsheet rows that match text in any cell and export the matching records to a new Excel workbook.

Office File Tool

Local browser processing
row
rows
Ad space

How to use this office tool

  1. Upload a file and choose the worksheet.
  2. Select Query in the option field, then enter the search text when prompted.
  3. Run the filter, review match counts, and download the matching rows.

What this tool does

Searches the selected worksheet using a text query, supports case-sensitive or case-insensitive matching, and keeps the header.

Keep row when at least one cell contains the filter text; always retain the configured header row.

Enter the filter query in the output-format field after selecting Query. Blank queries are rejected.

Supported formats

Accepts XLSX, XLS, CSV, and TSV. Matching rows are exported as XLSX.

InputOutput
XLSX, XLS, CSV, TSV (as applicable)New XLSX file

Tips for better results

  • Use a distinctive phrase to reduce accidental matches.
  • Enable case sensitivity only when capitalization carries meaning.
  • For exact column rules, verify the output before replacing any source workflow.

FAQ

Does the Excel row filter search every column?

Yes. A row matches when the query occurs in at least one parsed cell.

Is text filtering case sensitive?

It is case-insensitive by default; the Preserve formulas checkbox is repurposed as the case-sensitive option on this page.

Is the header row included in filtered output?

Yes. The configured header row is retained even when it does not contain the query.

Can the filter use regular expressions?

No. This tool uses literal contains matching to avoid unexpected regular-expression behavior.

What happens when no rows match?

The tool reports zero matches and does not create a misleading empty download.

Processing limits

LimitValue
File size25 MB
PreviewUp to 100 rows × 12 columns

Browse more office tools

Office tool hubs