How to use this office tool
- Choose a spreadsheet and select its worksheet.
- Enter a regular expression, choose its target column, and set matching options.
- Filter the rows, inspect the preview, and download the result.
#237 · Sort Filter & Search Tool
Spreadsheet Regular Expression Filter
Filter spreadsheet rows with a JavaScript regular expression applied to one column or the full row, then export only the matching records.
Office File Tool
One spreadsheetrow
rows
Ad space
What this tool does
The filter compiles your regular expression safely, tests rows from the selected worksheet, previews matches, and writes a new XLSX, CSV, TSV, or JSON file.
Selected cells + regular expression → matching rows → new output file
Regular expressions use JavaScript syntax. Avoid extremely complex expressions on large sheets.
Supported formats
Files are processed locally. XLSX and XLS workbooks are read with SheetJS; CSV and TSV files are parsed with delimiter-aware handling. Advanced Excel features may not be preserved in generated files.
| Format | Support |
|---|---|
| XLSX / XLS | Read workbook values and formulas |
| CSV / TSV | Read delimited rows |
| Output | New downloadable file or report |
Tips for better results
- Work from a backup when the source workbook is important.
- Keep identifiers such as ZIP codes and account codes stored as text.
- Review the bounded preview and downloaded result before replacing any business workflow.
FAQ
What regular expression syntax does the filter use?
It uses the JavaScript RegExp syntax supported by your browser, with optional case-insensitive matching.
Can I search across every column in a row?
Yes. Choose All columns to test a tab-separated text representation of the complete row.
Are column headers included in the filtered file?
Yes. The selected header row is kept even when no data row matches.
What happens if the regular expression is invalid?
Processing stops with a readable error and no download file is created.
Can formula text be searched instead of displayed values?
Enable Preserve formulas to use formula strings where they are available.
Related office tools
Processing details
| Stage | Action |
|---|---|
| Input | One spreadsheet |
| Privacy | Local browser processing |
| Result | New downloadable output |
Browse more office tools
Office tool hubsSpreadsheet ConversionConvert Excel, CSV, JSON, HTML, and other table formats.View all
Spreadsheet CleanupRemove duplicates, blanks, extra spaces, and inconsistent values.View all
Merge Split & OrganizeCombine, divide, extract, and arrange workbooks and sheets.View all
CSV & Delimited FilesView, edit, clean, validate, and convert delimited data files.View all