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. Your file never leaves your browser.
Drop a CSV or TSV file here, or click to select.
CSV, TSV · Max 2 GB
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.
Related tools
View and explore CSV files with sorting, filtering, and column type detection. Handles 100k+ rows.
Build a visual filter pipeline with AND/OR logic, pick columns, sort, and export.
Remove duplicate rows from a CSV. Pick which columns to compare and what to keep.