CSV Column Statistics
Inspect a CSV column for empty, distinct, numeric and nonnumeric values, with sum, mean, median and range for finite decimal numbers.
Start with your input
Edit the example or replace it with your own text.
Choose your options
These settings are optional. Keep the defaults to get started.
How to use CSV Column Statistics
- Paste CSV and choose a column by its exact header.
- Analyze to see text-quality counts and numeric statistics.
- Review excluded values before using the totals elsewhere.
Combine data-quality counts with numeric summaries
The result reports row count, blank cells, distinct original strings and numeric/nonnumeric counts. Numeric summaries include minimum, maximum, sum, mean and median. Blank cells are not treated as zero. A small sample of nonnumeric values helps reveal a wrong column or unexpected export format.
Keep the interpretation explicit
Numeric parsing uses finite decimal or scientific notation after trimming; it does not infer currencies or localized separators. Distinct strings are compared exactly, so surrounding spaces can remain visible as separate values in the quality count. Statistics use ordinary browser floating-point arithmetic, not an exact accounting decimal engine. Values that overflow supported arithmetic cause an error rather than an infinite total.
Example input
name,score,team Ada,98,Blue Grace,85,Red Linus,91,Blue
Are empty cells included as zero in the average?
No. The numeric mean uses only values parsed as finite numbers; empty and nonnumeric counts are reported separately.
Is input uploaded?
Processing takes place in your browser. This tool does not send your input or selected files to a conversion API.