Skip to content

CSV Descriptive Statistics

Summary statistics for every column in a CSV file: N, missing, mean, SD and more.

Summary statistics

A column counts as numeric when at least 80% of its non-missing values are numbers. Blank cells and NA, N/A, NaN, null, none, "." and "-" are treated as missing. SD is the sample standard deviation and quartiles use linear interpolation (Excel QUARTILE.INC).

Continue your work

Share this tool

Found it useful? Send it to a friend or teammate.

Rate this tool

0.0

0 ratings

  • 5 stars 0
  • 4 stars 0
  • 3 stars 0
  • 2 stars 0
  • 1 star 0

Click a star to rate this tool

Clear instructions

Find steps, examples and limitations below.

Use online

Open the tool in a supported web browser.

Free to use

No sign-up required. Tool-specific limits may apply.

How to use the CSV Descriptive Statistics

Summary statistics for every column in a CSV file: N, missing, mean, SD and more.

  1. 1 Upload a CSV or TSV file, or paste data copied from Excel.
  2. 2 Say whether the first row holds the column names.
  3. 3 Read the summary table and download it as CSV.

Example and practical tips

For a 16-row clinical dataset, the glucose column shows 15 values, 1 missing, mean 126.4 and a median of 102, a gap that hints at an outlier.

Frequently asked questions

Is my data uploaded to a server?

No. The file is read and summarized entirely in your browser.

How are text columns handled?

Columns that are mostly non-numeric are listed separately with the number of distinct values and the most common ones.

Report an issue

Something broken or not quite right? Tell us and we will look into it.