FREE BROWSER TOOL · BROWSER-ONLY PROCESSING

Missing Value Checker

Upload a CSV or paste a table to find missing values. Choose detection rules, inspect column and row summaries, and export reports without changing your source data.

  • CSV, TSV or spreadsheet paste
  • Custom missing-value rules
  • Column + row reports
Missing Value Checker example previewIllustration of the six-row example: 24 cells, 3 missing cells and 12.5 percent missing. Age, City and Score each have one missing value. This is a static preview; use the checker below to analyze your data.Missing Value CheckerDATA COMPLETENESS · EXAMPLE PREVIEWYOUR TABLEID,Age,City,ScoreA01,25,Lahore,80A02,,Karachi,0A03,30, ,N/AA04,0,Islamabad,90A05,28,NA,A06,35,Lahore,FALSEMISSING-VALUE RULES✓ Empty cells✓ Whitespace-only cellsText markers: offAnalyze dataCOMPLETENESS SUMMARY24Analyzed cells3Missing cells12.5%MissingMISSING VALUES BY COLUMNID0%Age16.67%City16.67%Score16.67%0%100%6 records · 4 columns · 3 complete rows
Example preview · Your table is processed locally in your browser.

1. Add your table

Hypothetical example data

UTF-8 text; 1 MiB, 20,000 data records, 100 columns and 100,000 cells maximum. Excel workbooks (.xlsx) are not supported; paste cells or export CSV.

Blank records and uneven rows

Default: preserve blank records. Whitespace-only records stay included. A final newline alone does not create another record.

Opt-in only. Inserted cells count as “Absent field.” Original values are preserved. Otherwise uneven rows block analysis.

2. Choose missing-value rules

Empty cells always count as missing.

Markers are off by default. NA can be a valid code; enable it only when it means missing in your data.

Custom markers and matching

Exact whole-cell matches only. Trimming never changes original values. Zero, FALSE, No, Unknown and -999 remain present unless you explicitly add them as markers.

Columns included in analysis

Uncheck fields to remove them from completeness calculations, without deleting their data.

Reset restores the default example and rules. The checker processes data in this browser and does not upload or save it. Shared page assets may make normal network requests.

3. Inspect missing data

Loading example…

DATA CLEANING · DATA COMPLETENESS GUIDE

Find missing data and understand your results

Check where values are missing, how much of each column is affected, and which records need review. Use this guide to interpret the checker’s rules, percentages and reports before making changes to your data.

Key takeaways

Rules define missingness

Empty cells count as missing. Enable text markers only when they mean missing in your source.

Keep the scope visible

Percentages depend on included records and selected columns. Display filters do not change totals.

Present does not mean valid

Zero and FALSE remain present by default, even when a value needs a separate validity check.

Inspect before changing data

Patterns can guide investigation. They do not choose a deletion or imputation method.

What is a missing value?

A missing value is a field for which the intended observation is unavailable or has not been recorded. In a survey, an unanswered age question may produce an empty cell. In a sales export, a failed lookup may produce the text NULL. A question that does not apply to a respondent may also be blank, but that blank has a different explanation.

This missing value checker applies the rules you choose. It measures data completeness; it does not decide whether a recorded value is accurate, plausible or suitable for analysis. Start with the source documentation, or use the Data Dictionary Generator to record each field’s meaning and missing-value codes.

How to check missing values in CSV or pasted data

  1. Upload a UTF-8 CSV or TSV file, or paste a rectangular table from Excel or Google Sheets. Choose the correct delimiter; spreadsheet paste normally uses tabs.
  2. Check whether the first record contains headings. Preview the import and confirm that values appear under the correct columns. A comma inside a quoted address should remain part of one field.
  3. Review missing-value rules. Empty cells are always missing here; whitespace-only detection is enabled initially. Text markers require an explicit choice.
  4. Select the columns relevant to your analysis, then choose Analyze data. Inspect column counts before reviewing individual incomplete records.
  5. Download the reports and analysis settings so another person can reproduce your choices. Keep an unchanged copy of the source file.

Uneven rows stop analysis by default. Correct the CSV if a delimiter or quotation mark is wrong. If shorter records genuinely omit fields, normalization can add absent cells and retain extra fields as additional columns. It cannot determine where an accidentally omitted separator belonged.

Blank cells, whitespace and text markers

An empty cell has no characters. A whitespace-only cell contains spaces, tabs or line breaks that may look blank on screen. This checker distinguishes those reasons while counting each missing cell once. Trimming is used only for detection; it does not rewrite the table.

CSV has no universal, typed null value. The characters NULL, NaN and None are text until an application interprets them. Here they count as missing only when enabled. An NA code might be a legitimate region label, so the default rules leave it present. Marker matching uses the whole cell: enabling NA does not flag Canada.

Other programs use different conventions. For example, pandas documents that isna() does not itself classify empty strings as missing. Import settings can affect what reaches that function. Document your rules when comparing counts between tools.

Missing percentages by row and column

Use the denominator for the question
Overall missing % = missing cells ÷ (included rows × selected columns) × 100
Column missing % = missing cells in column ÷ included rows × 100
Row missing % = missing selected cells in row ÷ selected columns × 100

Headers never enter these denominators. Complete rows have no missing cells across the selected columns. Excluding an optional notes column can therefore increase the complete-row count without changing any source value. Explorer filters do not change these totals.

Worked missing-value example

Hypothetical data · default six-row example

Load the verified example above. The labels empty and spaces below describe cell contents; they are not literal input values.

Original values before missing-value classification
IDAgeCityScore
A0125Lahore80
A02emptyKarachi0
A0330spacesN/A
A040Islamabad90
A0528NAempty
A0635LahoreFALSE
24Analyzed cells
3Missing with default rules
12.5%Missing-cell percentage
Enable NA and N/A: Missing cells increase to 5 of 24 (20.83%). Three rows remain complete because the additional markers occur in rows already missing another value.

Reading the missingness chart and matrix

The horizontal bars show column missing percentages on a fixed 0–100% scale. Use the adjacent table for counts and reasons. The matrix shows records as rows and variables as columns, with P for present and M for missing. It shows the current row window, not a random sample.

Repeated gaps in the same fields may suggest a skipped questionnaire section, a failed import or a collection rule worth checking. The pattern table groups identical configurations and includes complete records. It lists the 15 most common patterns and states how many records the remaining patterns cover. These summaries describe where gaps occur; they do not explain their cause.

What to do before deleting or filling data

First confirm that each marker actually means missing. Then check collection instructions and the original export for import failures or legitimately inapplicable questions. Compare missingness with relevant observed groups, dates or collection methods. The exploratory data analysis guide provides a broader inspection workflow.

Choose any treatment in light of the question, study design and analysis model. Deleting every incomplete record can discard useful information; replacing every blank with zero can change the meaning of a measurement. There is no universal missing-percentage cutoff that makes a column safe or unusable. Document the chosen treatment and consider how results change under reasonable alternatives. Read how to handle missing data before making those changes.

MCAR assumes missingness is independent of observed and unobserved data values under the stated model. MAR assumes that, conditional on relevant observed information, missingness does not depend on the missing values themselves. MNAR allows that dependence to remain. MAR does not mean completely random. A heatmap cannot establish these assumptions, and observed data alone generally cannot distinguish MAR from MNAR without additional information or assumptions. See the National Research Council’s discussion of inference from incomplete data.

Methodology, limits and privacy

The parser handles quoted delimiters, escaped quotes, multiline fields, UTF-8 byte-order marks and trailing empty fields. Values stay as text, including leading-zero IDs and large identifiers. Duplicate or blank headers receive unique column IDs. Data-row numbers refer to records after the header; a quoted multiline record can span several physical file lines.

Blank records stay included unless you choose to exclude records whose fields are all empty. A final newline is a terminator, not another record. An empty physical line within the file is a record; if it has the wrong width, correct it, exclude it explicitly or normalize it. Whitespace-only records are not removed by the empty-record setting.

A separate mask records one reason per missing cell in this order: absent field, empty, whitespace only, configured marker. All selected cells contribute to summaries. Reports use full counts even though the explorer displays 40 records per page and the matrix displays at most 20 selected columns. Percentages with zero denominators are shown as not applicable.

The checker accepts up to 1 MiB of UTF-8 text, 20,000 data records, 100 columns and 100,000 imported cells. It rejects larger input rather than truncating it. JSON and Excel workbook upload are not implemented. Exports quote CSV fields and prefix formula-like values with an apostrophe; normalized absent fields export as empty strings. Exported files are therefore not byte-for-byte copies of the source.

This tool’s code processes data in browser memory, without sending datasets to a server or saving them in browser storage. The shared website may request normal page assets. Close the page or use Clear data to remove the active dataset from the checker. Review exported files before sharing them because the affected-row report contains original values.

When this tool is useful

Check completeness before your next analysis.

Review a survey export, locate gaps in a business table, or document missing-value codes before calculating statistics. Confirm that each marker means missing in your source.

CSV completeness checksIncomplete recordsColumn summariesMissing-value reports
FAQ

Missing Value Checker questions

How the free browser tool handles your data.

What does the Missing Value Checker detect?

Empty cells, optional whitespace-only cells, enabled whole-cell markers and absent fields inserted by explicit normalization. It does not validate numeric ranges or data types.

Does zero count as a missing value?

No. Zero, 0.0, FALSE and No stay present unless you explicitly add them as custom markers.

What is the difference between a blank cell and NULL?

A blank cell contains no characters. In a CSV, NULL is text; enable that marker only if your source uses it to mean missing.

Can I define my own missing-value markers?

Yes. Enter one marker per line under Custom markers and matching. You can choose case-sensitive matching and whether detection trims surrounding whitespace.

How is missing percentage calculated?

Overall missing percentage is missing cells divided by included rows times selected columns, multiplied by 100. Column percentages use included rows; row percentages use selected columns.

Can I find rows missing a particular field?

Yes. Use Inspect rows in the column report, or select Missing a selected column in the explorer. Overall totals remain unchanged.

Can I paste data from Excel or Google Sheets?

Yes. Copy the rectangular cell range, paste it and choose the Tab delimiter. Review the preview. For workbook files, export CSV first; .xlsx upload is not supported.

Does this tool delete or fill missing values?

No. It produces inspection reports. Width normalization only adds structurally absent cells to the working table; it does not estimate replacement values.

Can it identify MCAR, MAR or MNAR?

No. Those describe assumptions about the missingness process. Counts and visible patterns cannot establish them.

Is my dataset uploaded to a server?

The checker does not upload datasets. Parsing, calculations and report generation happen in this browser. Its code does not persist datasets in localStorage or IndexedDB.