Missing Data Analyzer

Report missing cells per column and rows with any missing values.

FreeNo accountOn your device

Runs in your browser. How to verify

Loading tool…

About this tool

Drop a CSV and see, for every column, how many cells are empty and what percentage that is. You also get the total missing cells, how many rows have any gap, and the index of each incomplete row.

How to use

1
Step 1
Paste CSV text or drop a file.
2
Step 2
Press Process.
3
Step 3
Review the columns with gaps and the incomplete row indexes.

How it works

A cell is treated as missing when it is empty. For each column the tool reports present and missing counts and the missing percentage. Row indexes are zero-based positions among the data rows, not counting the header.

Worked example

One blank cell

Input
region,product,units,revenue ... East,Gadget,,45 ... (7 data rows)
Output
totalMissingCells 1 rowsWithAnyMissing 1 units: missing 1 (14.29%), present 6 incompleteRowIndexes: [5]
Walkthrough
Row index 5 is the sixth data row, the one with the empty units cell.

Limitations

  • Only empty cells are missing. Placeholders such as NA, N/A, null or -- are treated as real text.
  • It reports gaps but does not fill or drop them.

Questions

How do I find missing values in a CSV?
Drop the file and press Process. Each column shows its missing count.
Does it detect NA or null strings?
No. Only empty cells count as missing.
Are row numbers zero-based?
Yes. Index 0 is the first data row below the header.
Can it fill the gaps?
No, it only analyzes.

Features

  • Missing per column
  • Incomplete row indexes
  • Runs in your browser

Related resources

Guides and videos from around the web—opens on YouTube or the publisher’s site.

  • SQL Tutorial - Full Database Course

    freeCodeCamp.org

    SQL and tabular data sit next to CSV/JSON data tools.

    Watch on YouTube
  • Learn JSON - Full Crash Course

    freeCodeCamp.org

    JSON is a primary interchange format for data utilities.

    Watch on YouTube