Developer tools
CSV column statistics
Pick columns and get count, sum, mean, median, quartiles and standard deviation for each. It runs in your browser.
Processed in your browser
1. Add CSV
Drop one CSV or TSV file here
Choose a UTF-8 file or paste CSV.
2. Choose columns
Positions distinguish duplicate or empty headers. Select text columns to count missing and distinct values too.
0 selected
Loading controls…
Column statistics
No result yet
Scroll horizontally when needed. Statistic names stay on the left.
All data rows are analyzed. Only the preview is paged; copy and download include every selected column and the statistical definitions.
How to get statistics for a CSV column
- Add your CSV.
Drop one UTF-8 CSV file or select Choose file. You can also paste CSV and select Read columns. Check the Delimiter and First row is a header.
- Choose columns.
Each column shows its first three values. Tick the columns you want, then select Analyze columns.
- Save the report.
Read the Column statistics table, then select Copy report or Download JSON.
Example: prices and quantities
Use example loads four products with Price and Quantity columns. One price is blank and one quantity is n/a. Analyze both columns:
- Price: 3 valid numbers and 1 blank. Minimum 9.99, maximum 19, sum 41.49, mean 13.83, median 12.5.
- Quantity: 3 valid numbers and 1 invalid (n/a). Sum 7, median 2, sample standard deviation about 1.53.
The Product column has no numbers, so it shows 4 invalid and 4 distinct values.
How numbers are interpreted
Decimal format and missing values
Numbers use a decimal dot, optional sign and optional exponent: -12.5, .5, 1e3. Surrounding whitespace is ignored for numeric parsing. Grouping commas, currency symbols, percentages, dates, hexadecimal, Infinity and NaN are invalid. Nonzero values that round to zero during parsing are also invalid. A decimal comma such as 1,5 is invalid too. Leading zeros are ignored numerically, so 007 counts as 7; column types are not guessed, and every nonblank cell that is not a number is counted as invalid.
Empty, whitespace-only and absent cells count as blank. Blank and invalid cells are omitted from numeric statistics. Distinct counts compare original nonblank strings exactly, including case and whitespace: 01 and 1 are distinct. Input strings are never converted in the source preview.
Precision and unavailable results
Calculations use 64-bit binary floating-point numbers, not exact decimal arithmetic. Each cell is rounded to the nearest 64-bit value when read, so 0.1 plus 0.2 shows 0.30000000000000004. Figures are shown with every digit of the 64-bit result and are not rounded for display. Integers beyond ±9,007,199,254,740,991 may round; their count is shown. Use exact decimal software when that precision is required.
An em dash (JSON null) means no valid numeric values, too few sample values, or overflow. Overflow and detected underflow have notes. Empty numeric sets have no sum. No fixed row or file limit is imposed; browser memory is the practical limit. Cancel terminates processing.
Average, quartiles and spread
Mean is sum divided by valid count. Median, Q1 and Q3 use linear interpolation at (n − 1) × p in sorted values, with p = 0.5, 0.25 and 0.75 (type 7). Range is maximum minus minimum.
Population variance divides squared deviations from the mean by n; sample variance divides by n − 1 and requires at least two values. Standard deviations are the square roots of those variances. The sum is the exact total of the 64-bit cell values, rounded once, so whole numbers add up exactly while the total stays within the safe integer range. Mean, quartiles, variance and deviation can differ from exact arithmetic in their last digit or two.
CSV records and reports
Quoted commas, escaped quotes and multiline fields are supported. Uneven rows remain included; absent fields count as blank. Blank records count as data rows; a final record terminator does not add a row. Auto-detection can be uncertain, so check the samples.
Reset clears input and output. Reports contain header strings; JSON does not execute spreadsheet formulas.
Questions
How do I find the average of a CSV column?
Tick the column and select Analyze columns. The Mean row is the average: the sum of the valid numbers divided by how many there are. Blank and non-numeric cells are left out, and the Median row gives the middle value.
Why are some of my numbers counted as invalid?
The tool reads plain numbers with a dot as the decimal mark, such as 1234.5 or 1e3. Thousands separators (1,234), currency signs, percent signs and decimal commas (1,5) count as invalid. Remove them first, for example with CSV Find and Replace.
Which standard deviation should I use?
Use the sample figure when the rows are a sample of a larger group. It divides by n − 1 and needs at least two numbers. Use the population figure when the rows are the whole group; it divides by n.
How are quartiles calculated?
Q1, median and Q3 use linear interpolation between sorted values, the same method as Excel's QUARTILE.INC and the default in R and NumPy.
What does a dash mean in the table?
The figure is not available: the column has no valid numbers, has only one number for a sample figure, or the result overflowed. In the JSON report a dash is null.
Is my CSV uploaded?
No. The file is read and analyzed in your browser, and nothing is uploaded or stored. Reset clears the input and the report.