Null Value Mapper — Free & Online Missing-Data Heatmap

This tool turns a pasted CSV into a missing-data heatmap. Every empty cell shows as a dark square, every filled cell as a light dot, and a summary table reports how many values are missing in each column and what percentage that is. You can also list extra tokens that count as missing in your data, such as NA, N/A, or a dash. The point is to see the shape of missingness before you decide what to do about it. A column missing five percent of its values at random is a different problem from a column missing eighty percent, or from missing values that cluster in one group of respondents.

How to use it

Paste your CSV with headers in the first row.
Add any extra missing-value tokens your file uses, separated by commas.
Click Map missing data and read the grid.
Check the per-column table: which columns lose the most data?
Look for row patterns: are the same rows missing many fields at once?

Worked example

A survey file has four columns: id, age, income, and city. After mapping, income is missing in two of four rows (50 percent) while age is missing in one (25 percent). Row 4 is missing both age and income. That pattern matters. If income is missing mostly for younger respondents, deleting every incomplete row would bias your sample toward older people. The heatmap does not fix anything by itself, but it stops you from deleting data blindly and tells you where imputation or follow-up is worth the effort.

Honest limits

This tool reads simple comma-separated values pasted in the browser. It does not handle quoted commas inside cells, very large files, or files uploaded from disk, and nothing is saved or sent anywhere — closing the page clears your data. It also cannot tell you why values are missing. Only your study design and your respondents can tell you whether missingness is random or systematic. Treat the map as a diagnostic, then choose a handling method — deletion, imputation, or modelling — with that diagnosis in mind, and report it in your methods section.

Who it is for

This tool is for researchers, students, and data analysts doing the first cleaning pass on survey or experimental data. It is most useful before analysis, when a quick visual check can prevent a silent bias. If you work with sensitive data, note the privacy upside: everything runs in your browser, so your pasted values never leave your computer.

Going further

Statisticians describe three kinds of missingness, and the kind decides the fix. Data missing completely at random (MCAR) means the gaps have nothing to do with any variable: deleting incomplete rows then only costs sample size, not bias. Data missing at random (MAR) means missingness relates to observed variables — younger respondents skip income questions, for example — so deletion biases results but imputation using those observed variables can repair it. Data missing not at random (MNAR) means missingness relates to the missing value itself, such as high earners refusing to state income: no method fully fixes that, and you must say so. Your heatmap cannot distinguish the three, but it tells you where to look. Compare respondents with and without missing income on age, gender, and region. If the groups differ, MAR is plausible and deletion is unsafe. Whatever you choose, report three numbers in your methods: the percentage missing per key variable, the method you used, and how many cases were affected. Readers can forgive missing data; they cannot forgive hidden missing data. A final practical point: never overwrite your raw file with a cleaned version. Keep the raw export, the heatmap summary, and the cleaned file as three separate artifacts, so any later question about a number can be answered by walking back through the steps. If you impute values, add a flag column marking which cells were imputed, because an imputed value is an assumption, not an observation, and analyses that mix the two without distinction overstate their certainty. Reviewers increasingly check exactly this, and a flag column is the cheapest credibility you can buy.

Embed this tool on your website — free

Copy the code below to add this working tool to your own page. A small credit link stays with it — that’s all we ask.