Data Validator
Check every row against rules before it reaches your report.
Define rules per column — required, numeric range, date range, email, phone, regex, allowed list — and get a report of every violation with its row and column. Export the failures, or download a workbook with invalid cells flagged.
- Price
- Free
- Your files
- Never uploaded
- Runs
- In your browser
or drag it here
.xlsx, .xls, .csv · up to 50 MB · processed locally, never uploaded
Excel and spreadsheet files only. Export from Google Sheets as .xlsx or .csv.
Files stay on your device
What it does well
- Nine rule types including regex and cross-column comparison
- Rule sets saved to your account and reusable on the next file
- Violation report as XLSX or CSV with row references
How to use Data Validator
- 1
Upload the file and let the column types be detected.
- 2
Add or adjust a validation rule for each column that matters.
- 3
Run the check and browse violations grouped by rule.
- 4
Export the violation report or the flagged workbook.
Watch a walkthrough
Common problems and fixes
Valid dates are reported as invalid.
The column is stored as text. Set the expected format explicitly on the rule, or run the Date Formatter first.
Thousands of violations from one rule.
The rule is probably too strict — a required rule on an optional column, for instance. Check the sample values shown next to the rule.
Frequently asked questions
More clean & format tools
Remove duplicates, trim whitespace, fix inconsistent dates and numbers, split or merge columns, and validate data quality before it reaches your reports.
Browse Clean & Format