How to use this office tool
- Choose a spreadsheet and worksheet.
- Select a column, operator, comparison value, and case setting.
- Preview matching rows and download the reusable JSON rule.
#249 · Sort Filter & Search Tool
Saved Filter Rule Builder
Create a reusable JSON filter-rule file from spreadsheet columns, operators, values, case settings, and AND/OR logic, with a live match preview.
Office File Tool
One spreadsheetrow
rows
Ad space
What this tool does
The builder validates each rule against the selected sheet, previews matching rows, and downloads a portable JSON definition plus column metadata.
Column + operator + comparison value → validated rule set → JSON file
The JSON stores rules rather than modifying Excel AutoFilter settings. Apply it in your own workflow or rebuild the filter here later.
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 operators can a saved filter rule use?
The builder supports contains, equals, starts with, ends with, greater than, less than, is blank, and is not blank.
Does the JSON file filter Excel automatically?
No. It stores a portable rule definition and a preview count rather than changing Excel AutoFilter settings.
Can rules ignore letter case?
Yes. Text comparisons can be evaluated case-insensitively.
What happens if the selected column is missing?
The builder blocks processing until a valid worksheet column is selected.
Are spreadsheet values uploaded to save the rule?
No. The rule and preview are created locally in your browser.
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