Data Quality Rule Checker

Build column rules and download every row that fails them.

On-device No sign-up Free to use

Check data rules controls

Drop your CSV file here

or choose one from your device

One UTF-8 CSV or TSV file. A chosen file replaces the pasted text for rule checking.

    ?

    Paste the table to check, or leave this empty and choose a file. Values are kept exactly as they appear in the text.

    ?

    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.

    ?

    Formula-like headings or values receive an apostrophe prefix in the CSV download. The prefix changes stored text; review the import in your spreadsheet.

    Result

    Showing an example.

    Find the rows with a repeated email, a missing name or an age outside the range.

    Four rows are checked against four rules and two fail. Row 3 repeats row 1’s email, has age 150 and lacks a name; row 4 lacks an age. failing-rows.csv starts with source_row,failed_rules,email,age,name and contains those two source rows with their failure reasons.

    Loading the tool. Your result will appear here.

    https://usefreetools.net/data-quality-rule-checker · 20 November 2026

    Was this helpful?

    How to use Data Quality Rule Checker

    1. Paste CSV or TSV, or choose a delimited file. Check the delimiter and whether the first row contains column names.
    2. 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.
    3. Run the checks and review per-rule failure counts. A unique rule ignores empty cells; add required when blanks must fail too.
    4. 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.

    You add
    Pasted text email,age,name with the rows ana@example.com,30,Ana, lee@example.com,25,Lee, ana@example.com,150, (no name) and bo@example.com,,Bo. Rules: email required, email unique, age range 0 120, name required.
    You get
    Four rows are checked against four rules and two fail. Row 3 repeats row 1’s email, has age 150 and lacks a name; row 4 lacks an age. failing-rows.csv starts with source_row,failed_rules,email,age,name and contains those two source rows with their failure reasons.

    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.

    Page updated · Project managed by Tony Hines · Report a problem with Data Quality Rule Checker

    Related reading

    All guides