Missing Data Checker
Count and chart missing values per variable and find incomplete rows in a dataset.
Blank cells always count as missing. Add codes such as -99 or 999 if your dataset uses them.
Missing data report
Processing and privacy
Processing varies by tool. Check the instructions for local processing, server requests, external services and any file or request limits before entering sensitive information.
Read the privacy policyShare this tool
Found it useful? Send it to a friend or teammate.
Rate this tool
0.0
0 ratings
- 5 stars 0
- 4 stars 0
- 3 stars 0
- 2 stars 0
- 1 star 0
Clear instructions
Find steps, examples and limitations below.
Use online
Open the tool in a supported web browser.
Free to use
No sign-up required. Tool-specific limits may apply.
How to use the Missing Data Checker
Count and chart missing values per variable and find incomplete rows in a dataset.
- 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.
Example and practical tips
In a 16-row dataset, BMI is missing for 2 people (12.5%) and only 12 rows (75%) are complete cases.
Frequently asked questions
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.
Practical guides
-
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.
Report an issue
Something broken or not quite right? Tell us and we will look into it.