MakeMyStats

Tools / CSV Column Statistics

CSV Column Statistics

Drop a CSV and see per-column stats — count, distinct values, nulls, min/max, mean, median, standard deviation, and the most common values. Useful for data profiling and sanity checks.

Runs entirely in your browser

Drop a CSV or TSV file here, or click to select.

.csv, .tsv, .tab · Max 500 MB

How to use CSV Column Statistics

  1. Drop your CSV

    Drag a .csv or .tsv file onto the dropzone, or click to browse. The file is parsed in your browser by PapaParse — nothing is uploaded.

  2. Wait for the profile

    Each column is scanned once. The detected type — number, string, boolean, or empty — is shown as a badge so you can spot mis-typed columns at a glance.

  3. Read the per-column cards

    Number columns show count, nulls, distinct, min, max, mean, median, standard deviation, and sum. String and boolean columns show count, nulls, distinct, shortest and longest length.

  4. Spot the top values

    Every column lists its five most common values with a percentage bar. Useful for finding categorical buckets, dominant defaults, and unexpected outliers.

  5. Download the stats CSV

    Click Download stats CSV to save the full profile as a CSV — one row per column with every statistic. Drop it into a notebook, paste it into a doc, or commit it next to the dataset.

Frequently asked questions

Does this tool upload my CSV?
No. Every parse, transform, and download runs entirely in your browser using JavaScript and Web Workers. The file never leaves your device — there is no upload endpoint and no server-side processing.
How does it decide a column is numeric?
A column is treated as numeric only if every non-empty value parses as a finite number. One stray non-numeric value flips it to a string column — which prevents IDs and zip codes that happen to look numeric from being averaged by mistake.
Is the standard deviation sample or population?
Sample standard deviation (Bessel's correction — divide by n-1). Use sum, mean, and count from the same row if you need to compute the population variant or a different statistic offline.
Why do percentages in the top-values list not add up to 100?
Top-five only — the long tail of less-frequent values is omitted. The percentages are computed against the column's non-null count, not the total row count.
How big a CSV can it profile?
MakeMyStats uses streaming parsers (PapaParse worker mode for CSV, SheetJS for Excel) and virtualized rendering (react-window) so the UI stays responsive on multi-hundred-megabyte files. The hard ceiling is your browser's memory budget — usually 1–2 GB on desktop.
CSV Viewer

View and explore CSV files with sorting, filtering, and column type detection. Handles 100k+ rows.

CSV Filter & Transform

Build a visual filter pipeline with AND/OR logic, pick columns, sort, and export.

CSV Dedupe

Remove duplicate rows from a CSV. Pick which columns to compare and what to keep.