AnyTool
Your files never leave your device. All processing happens locally in your browser.

How do I check a CSV for missing required fields?

Paste your CSV into AnyTool's Required Field Completeness Checker. It computes a completeness score per column (fill rate, empty count, distinct values) and an overall score, lets you mark columns as required, and lists the exact rows where a required field is blank — treating NA/NULL/None/-/nil as empty. Export a per-column report or just the offending rows. Everything runs in your browser — nothing is uploaded.

  • Per-column fill rate, empty count and distinct values
  • Mark columns required; list the exact rows missing them
  • Treats NA / NULL / None / - as empty
  • Export the report or offending rows — 100% in your browser

What is

Required field completeness

Required field completeness measures whether every mandatory column in a dataset has a value in every row. Incomplete required fields are a leading cause of import failures. A completeness checker reports fill rates per column and flags rows missing a required value. Client-side checking does this in the browser with no upload.

File Tools

Related terms

data completenessmissing valuesrequired fieldsfill ratedata quality

How to Check Required Field Completeness

Score completeness and flag missing required values in your browser.

20 secWeb browser
  1. 1

    Paste CSV

    Paste your data with a header row. Completeness is scored live.

  2. 2

    Mark required

    Toggle the columns that must always be filled.

  3. 3

    Export

    Download the per-column report or the rows missing a required value.

Result: A completeness report and the list of incomplete rows

Frequently Asked Questions

A blank cell, plus common placeholders like NA, N/A, NULL, None, nil and a lone dash.

You can rely on those defaults so a column full of "N/A" is correctly reported as incomplete rather than filled.

Yes — it lists the exact row numbers and lets you download just those offending rows.

Mark any columns as required and the tool flags every row that leaves one of them blank.

No — all profiling runs in your browser; nothing leaves your device.

There is no row cap or signup, unlike server-based data-quality services.

Detailed Explanation

Methodology

How the Required Field Completeness Checker Works

AnyTool scores completeness entirely in the browser. The CSV is parsed with PapaParse and rectangularised, then each column is profiled for fill rate, empty count and distinct values, treating common placeholders (NA, N/A, NULL, None, nil, a lone dash) as empty alongside blank cells. You mark which columns are required; the tool then reports an overall completeness percentage, the number of fully-complete rows, and the exact rows where a required column is blank. Per-column metrics export as a CSV report, and the rows violating a required field export separately for fixing. Nothing is uploaded.

  • Runs client-side — the dataset is never uploaded
  • Per-column fill rate, empty and distinct counts
  • Placeholder values (NA/NULL/None/-) treated as empty
  • Mark required columns; list the exact offending rows
  • Export per-column report or offending rows as CSV
  • No CDN, no backend, no row cap or signup
Privacy & Security

Privacy vs Server-based Quality Tools

Many data-quality services upload your file to profile it. AnyTool computes completeness locally, so the data never leaves the browser, there is no row cap, and it works offline after first load. Because placeholder tokens are treated as empty, a column full of "N/A" is correctly reported as incomplete rather than appearing filled.

Completeness checking: AnyTool vs typical tools
CapabilityAnyToolTypical tools
Data handlingIn your browserOften uploaded
Empty detectionBlanks + NA/NULL/NoneOften blanks only
Required flaggingPer column + rowsVaries
Row limitNoneOften capped
ExportReport + offending rowsVaries

AnyTool is a privacy-first client-side completeness checker — profiling runs locally and nothing is uploaded.