Spreadsheet Data Validation Builder
Create dropdown and bounded-entry rules, then test sample values before exporting.
Adds or replaces classic worksheet data-validation rules for explicit ranges. Supported types are literal lists, whole numbers, decimals and text lengths with between bounds. Excel may permit pasted values or behave differently when protection/other validations overlap; this is not a security control.
Using Spreadsheet Data Validation Builder
Create dropdown and bounded-entry rules, then test sample values before exporting.
- Open supported source files or try the worked example. Original files are retained in browser memory and are not overwritten.
- Search and filter findings. Select a record to inspect its source evidence, then adjust the task-specific settings and explicit decisions.
- Use Preview to inspect the selected page, worksheet context or structured result. Undo/redo is available, and Save review retains decisions and exact source fingerprints.
- Use Export for the task-specific artifact or portable Excel, CSV, HTML and JSON reports. Inspect edited files in your normal PDF/spreadsheet/document reader before sharing.
Example
The worked workbook has Data, Lookup and a very-hidden Archive sheet, with numeric/text identifiers, dates, formulas, merged labels, a chart, table, comments, conditional formats, scoped names and an external-link reference. No external workbook is opened. Review the task-specific findings before choosing an export.
Questions & answers
What does this tool support?
Adds or replaces classic worksheet data-validation rules for explicit ranges. Supported types are literal lists, whole numbers, decimals and text lengths with between bounds. Excel may permit pasted values or behave differently when protection/other validations overlap; this is not a security control.
Are source files overwritten or uploaded?
Processing runs in this browser. Exports are new downloads, and original source files are retained unchanged. Public pages keep the existing approved advertising and optional analytics. Review projects contain settings, decisions and source fingerprints; keep the exact original files separately.
Can I save and reopen the review?
Yes. Save review creates a JSON project, which can be reopened with the exact original filenames and SHA-256 hashes. Generated libraries/forms can reopen without source files. There are no automatic browser drafts.
What are the practical limits?
Use up to eight files, 25 MiB each and 80 MiB total. DOCX/XLSX/EPUB packages are limited to 120 MiB expanded and 5,000 ZIP entries. XLSX workbooks support up to 60 sheets and 100,000 stored cells; rendering/comparison scans have visible per-tool page limits. Unsupported/encrypted/macro-enabled formats are not silently converted.
Related tools
A useful next step for your task.
Developer & DataExcel Workbook ExplorerFull workspaceOpen XLSX, XLS, ODS and CSV spreadsheets locally. Browse sheets, search workbook values, inspect stored formulas and export matching rows as XLSX,…
Developer & DataData Cleaning & Conversion WorkbenchFull workspaceClean and combine CSV, Excel, JSON and XML tables locally. Preview transformations, join datasets, pivot, validate, edit cells, save projects and…
Text & WritingExcel External Link InspectorTrace external workbook dependencies, formulas and destinations without opening them.
Text & WritingSpreadsheet Hidden Content FinderFind hidden sheets, rows, columns and names, then explicitly unhide selected items.
Help improve this tool
Report a problem or suggest an improvement
Describe the issue without pasting private tool input. Feedback goes to our admin inbox.