How to use Data Quality Rule Checker
- Paste CSV or TSV, or choose a delimited file. Check the delimiter and whether the first row contains column names.
- Build column rules with the controls or write one rule per advanced text line, such as email required or age range 0 120. Use a 1-based column number when a heading contains spaces.
- Run the checks and review per-rule failure counts. A unique rule ignores empty cells; add required when blanks must fail too.
- Download failing-rows.csv to see each failed source row and all its failure reasons. Correct the source data and check it again; this tool does not repair rows automatically.
Example: Data Quality Rule Checker
Find the rows with a repeated email, a missing name or an age outside the range.
Options
- CSV or TSV text
- Paste the table to check, or leave this empty and choose a file. Values are kept exactly as they appear in the text.
- Rules, one per line
- Write a column, a rule and any values: email required, order_id unique, age range 0 120, name length 2 60, code pattern ^[A-Z]{2}\d{4}$. A column is named by its heading or its 1-based position, so a heading holding a space is given by position. A line starting with # is a comment.
- Protect spreadsheet formulas in the download
- The rule checking CSV export can prefix formula-like source text, including after leading whitespace. This changes the stored text; review the downloaded cells before using them.
Supported inputs and limits
- Files up to 20 MiB or pasted text up to 20,000,000 characters, with at most 100,000 rows, 500 columns and 2,000,000 cells.
- Up to 100 rules and 2,000,000 row-rule checks; the failure download is bounded to 32 MiB.
- Supported rules check required values, exact nonempty uniqueness, numeric ranges, text lengths and bounded patterns without executing code.
- Pattern length, nesting, states, repetition and cell-length budgets apply; unsupported regex features are refused.
- CSV formula prefixes can change exported text.
More details
The report includes every failed row accepted within those limits.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
Why a failing row report beats a pass or fail count
A count tells you that something is wrong but not which record to open. Writing the original row next to the rules it broke keeps the failing records together, so the fix can be made in the source system and the file checked again.
Questions about Data Quality Rule Checker
Which pattern features are supported?
Use literals, character classes, groups, alternatives and the listed repeat operators. Backreferences, lookarounds and anchors inside a pattern are refused. A bounded state machine checks the supported subset and stops when the shared work budget is exhausted.
Can I check a column whose heading holds a space?
Yes, by position. A rule line splits on spaces, so name the column with its 1-based number such as 3 instead of the heading with a space inside it.
What is written into the download?
Every row that failed at least one rule, with the source row number and a failed_rules cell listing each broken rule and the reason, followed by the row's own columns in their original order.
How are empty cells treated by range and length?
A range rule fails an empty cell because there is no number to compare, and a length rule counts zero characters and fails unless the lower bound is zero.