Data Quality

Data Completeness Calculator

Completeness per column against a threshold, with empty, whitespace and N/A counted apart.

Loading the tool…

Processing happens locally in your browser. What you paste or load is processed by this page and is not uploaded to a server. Nothing is stored unless you use a control that says it stores something, and you can clear anything this site has kept from the privacy page.

How to use this tool

  1. Paste the CSV, or upload the file.
  2. Set the target completeness your team actually requires — 95% is a starting point, not a standard.
  3. Add any placeholder your systems use for missing data to the null token list.
  4. Select Measure completeness, and read the last column: anything marked below target is a decision you owe someone.

What completeness calculator does

Completeness is the first quality dimension anyone measures and the easiest to measure wrongly, because a cell can be empty in more than one way. A blank, a cell holding two spaces and a cell holding the word N/A are all missing to a human and all different to a computer, and a count that treats only the blank as missing overstates the figure every time.

This counts the three kinds separately and reports each column against a target you name up front. Naming the target first is the difference between a report and a decision: a percentage on its own invites you to decide afterwards whether 91% was acceptable, which is how a column that was never going to work reaches production.

Frequently asked questions

Yes, and it is counted in its own column so you can see how much of the gap it accounts for. The list of values treated this way is an option you can edit, because every organisation has its own set and a figure computed against the wrong list is wrong in a direction nobody notices.

An empty cell has nothing in it. A whitespace-only cell has spaces or tabs, which look identical in a spreadsheet and behave completely differently in a database — one is NULL and the other is a non-empty string that will not match anything. Both are counted as missing here and reported separately so you know which fix you need.

It depends entirely on the column. A customer email that is 90% complete is usually a serious problem; an optional second address line at 20% is fine. The tool takes one number because it has to take something, so set it for the columns that matter and read the rest with judgement.

No. It is read and measured in your browser. Nothing is sent to a server, nothing is stored, and closing the tab is all it takes to be rid of it.