CSV Missing Value Inspector

Count empty and whitespace-only CSV cells separately for each column.

CSV stays in this browser. Input is not uploaded.

Comma-separated CSV with 1-200 unique nonempty headers, up to 10,000 data rows and 200,000 characters. Every record must have the same cell count as the header.

Distinguish empty fields from whitespace

Paste CSV and choose Inspect missing cells. The report provides separate counts for exactly empty strings and nonempty cells containing only whitespace, one row per column. It does not replace values or drop records.

Example: visually similar missing values

The loaded example has an empty note for Ada, a single-space note for Lin, and an empty name on the third data row. The report shows name: one empty and zero whitespace-only cells; note: one empty and one whitespace-only cell. These categories do not overlap.

Missingness is a dataset policy

The tool uses exact empty strings and JavaScript whitespace trimming for its two categories. Literal strings such as NA, null, N/A and zero are ordinary nonmissing text. A field may be semantically missing even when this report counts it as present; choose a domain-specific policy before cleaning it.

Quoted empty fields count as empty after CSV parsing. Quoted whitespace counts as whitespace-only. A structurally short record is a parsing error, not a missing-cell report: each row must have the same cell count as the header. Header-only input produces zero counts for every column.

Review before changing data

The readable table contains every supported column. A JSON download preserves the report: column identifies the header, empty is the exactly-empty count, and whitespace is the whitespace-only count. No original data-cell contents are included in that report.

Use CSV Empty Column Remover only after deciding whether an all-blank column should be removed. CSV Statistics Calculator requires its own explicit choice before skipping unsupported values.

CSV input limits

Use at most 200,000 characters, 200 unique nonempty headers and 10,000 data records. Quoted commas, quotes and multiline cells follow the shared CSV parser. Output is capped at two million characters. Editing input or options clears old results and download links; no source file is modified.