Favorite places of your favorite city
Home
Add to preferred sources on Google

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.

CSV input

Up to 5 MiB, 5,000,000 UTF-16 units, 100,000 records, 256 columns and 2,000,000 cells.

Column statistics

Read a CSV table to see its column statistics.

Your browser reads the table and calculates the statistics on your device.

Summarize a column

  1. Paste a table or choose a local UTF-8 file.
  2. Choose the field separator and header option, then read the table.
  3. 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

Yes. The selector identifies each column by its original position.

An empty cell or a cell containing only ordinary ASCII spaces and tabs counts as blank.

Blank cells and values outside the supported decimal format are excluded from numeric statistics.

It copies the column position, counts and available statistics as plain text. Copied numbers use a dot as the decimal mark.

Sources

References for CSV syntax and the measures used in the summary.

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 Converter

CSV Row Filter

Keep or exclude CSV rows with text conditions on specific columns.

Open tool — CSV Row Filter

CSV Column Editor

Select, reorder and rename columns from a local CSV table.

Open tool — CSV Column Editor

CSV 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 Converter

Compare Two CSV Files

Match rows by a key column and find added, removed and changed records.

Open tool — Compare Two CSV Files

CSV 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 & Remover

CSV Merger

Combine rows from several CSV files by exact column name. Preview alignment and download CSV with a merge report.

Open tool — CSV Merger

CSV 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 Converter

CSV Splitter

Split a CSV by rows or exact file size. Keep headers and download each part.

Open tool — CSV Splitter
View all tools in this category