Excel Data Validator
Validates a spreadsheet against required-column and duplicate-row rules you define, and reports every issue found.
By The Paper Room Editorial Team — Spreadsheet Tools
Frequently asked questions
What types of validation rules can I set?▼
You can check for required fields, data type consistency (numbers, dates, emails, URLs), value ranges, unique constraints, and custom regex patterns. Rules are applied per column.
Does it fix the errors or just report them?▼
It reports errors with their exact cell location and the rule that was violated. Fixing is manual — the report gives you the information needed to correct the source data.
Can I save and reuse validation rules?▼
The current version requires setting up rules each time. For recurring validation on the same data structure, consider using a Sheet Workflow with formula-mode rules for automated checking.