CSV Column Statistics
Get a quick numeric summary of one column in a CSV export. See how many cells contributed and which kinds of values were left out.
Summarize a column
- Paste a table or choose a local UTF-8 file.
- Choose the field separator and header option, then read the table.
- Select a column by position and choose the decimal mark used in its numbers.
How the statistics are calculated
The mean is the sum of the numeric values divided by their count. A blank cell does not contribute a zero.
The median is the middle value after sorting, or the average of the two middle values if the count is even.
Check the numeric, blank and non-numeric counts to see how much of the column contributed.
Read a mixed column
For the values 1.25, 3 and 3.75, the sum is 8 and the median is 3. The mean rounds to 2.666667.
In a semicolon-separated file with numbers like 1,25, select Semicolon for the fields and Comma for the decimal mark.
Table and number formats
Use a rectangular UTF-8 table up to 5 MiB. Plain decimal values can contain up to 18 digits before the mark and six after it.
Currency signs, grouping separators, percentages and exponent notation are counted as non-numeric. The mean may be rounded to six decimal places.
Local processing
Your browser reads the table and calculates the statistics on your device.
CSV statistics questions
Sources
References for CSV syntax and the measures used in the summary.
Related tools
JSON to CSV Converter
Convert flat JSON records to delimited text with first-seen columns, original number spellings and explicit empty-value rules.
Open tool — JSON to CSV ConverterCSV Row Filter
Keep or exclude CSV rows with text conditions on specific columns.
Open tool — CSV Row FilterCSV Column Editor
Select, reorder and rename columns from a local CSV table.
Open tool — CSV Column EditorCSV Delimiter Converter
Convert CSV separators, preview real columns and spot import problems. Works locally with CSV, TSV and text; values remain unchanged.
Open tool — CSV Delimiter ConverterCompare Two CSV Files
Match rows by a key column and find added, removed and changed records.
Open tool — Compare Two CSV FilesCSV Duplicate Finder & Remover
Find exact duplicate CSV rows or repeated IDs. Review conflicting values, keep original data and download retained, removed and unresolved records.
Open tool — CSV Duplicate Finder & RemoverCSV Merger
Combine rows from several CSV files by exact column name. Preview alignment and download CSV with a merge report.
Open tool — CSV MergerCSV to JSON Converter
Convert CSV text or UTF-8 files to JSON objects or arrays, keeping cells as strings without guessing data types.
Open tool — CSV to JSON ConverterCSV Splitter
Split a CSV by rows or exact file size. Keep headers and download each part.
Open tool — CSV Splitter