Skip to content

How to Use Missing Data Checker

Check a CSV dataset for missing values: count and percentage per variable, complete cases and incomplete rows, with custom missing codes like -99.

About this tool

Count and chart missing values per variable and find incomplete rows in a dataset.

How to use Missing Data Checker

  1. Upload or paste your dataset.
  2. Add any codes your data uses for missing values, such as -99 or 999.
  3. Sort variables by missingness and download the report.

Worked example

In a 16-row dataset, BMI is missing for 2 people (12.5%) and only 12 rows (75%) are complete cases.

What counts as missing?

Blank cells always count. By default NA, N/A, NaN, null, None, “.”, “-”, “?” and #N/A count too, and you can edit the list.

How much missing data is too much?

There is no fixed cut-off, but more than 5–10% on a key variable deserves attention and possibly multiple imputation.

Put this guide into practice

  • Missing Data Checker — Count and chart missing values per variable and find incomplete rows in a dataset.

Explore Research & Academic Tools · More practical guides

Accessibility Menu

Personalize your experience. Open with Ctrl+U (Option+U on Mac). Preferences stay in this browser when storage is available.

Move / Hide Widget

Restore at any time with Ctrl+U (Option+U on Mac).

Accessibility statement and help