Validator

Upload a dataset to begin

Supported formats: .csv,.xlsx,.xls,.xlsm,.xlsb,.tsv

Free users: Up to 1MB per file.
Sign in to upload files up to 10MB.
Upgrade for even larger files.

AboutValidator

Check if data meets specific logical rules.Category: Transformation & Logic
Verifying an "age" column only contains numbers between 0 and 120 before importing into a databaseChecking that every row in an "email" column matches a valid email pattern before a mail mergeConfirming a "status" column only contains values from an approved list before publishing a report
The Validator tool is compatible with:.Run Data Health first for a general overview of quality issues across the whole file, then define specific rules here to enforce business logic; use Filtering afterward to isolate and remove the rows that failed validation.
You define one or more rules per column, numeric range, non-empty, regex pattern match, or membership in an allowed list, and the tool evaluates every row against them, flagging exactly which rule each failing row broke. Rather than silently rejecting bad data, it produces a per-row pass/fail report so you can decide how to handle exceptions before the file moves downstream.

Frequently Asked Questions:

What kind of rules can I check?

Logical rules you define, for example that a column must be numeric, non-empty, or fall within a specific range.

What happens to rows that fail validation?

The tool flags which rows don't meet your rules so you can review or fix them.


A gatekeeping step for teams that need to enforce data quality rules before a file is trusted downstream.