BYTETOOLS

CSV Column Statistics Calculator

Profile a CSV column by column: type, blanks, distinct values, min, max, mean, median, standard deviation and percentiles, plus top values — all in-browser.

Drop a .csv file here or click to browse

What is the CSV Column Statistics Calculator?

The ByteTools CSV Column Statistics Calculator profiles a dataset the way an analyst would before trusting it.

  • Automatic numeric, text, boolean and date typing per column
  • Count, blank, distinct, min, max, sum, mean, median and mode
  • Sample standard deviation, variance and 25/50/75 percentiles
  • Top value frequencies with percentage share
  • Minimum, maximum and average text length
  • Export the profile as CSV or Markdown — nothing is uploaded

How to use the CSV Column Statistics Calculator

  1. 1

    Paste your CSV into the input box, or drop a .csv file to load it.

  2. 2

    Choose the delimiter and confirm whether the first row is a header.

  3. 3

    Read the profile table for a per-column overview of type, blanks and spread.

  4. 4

    Pick a column in 'Column detail' to see its percentiles and top values.

  5. 5

    Copy or download the whole profile as CSV or a Markdown table.

About the CSV Column Statistics Calculator

The ByteTools CSV Column Statistics Calculator profiles a dataset the way an analyst would before trusting it. Paste your CSV or drop a file and every column is typed as numeric, text, boolean or date, then summarised: how many values are filled, how many are blank, and how many are distinct.

Numeric columns get count, minimum, maximum, sum, mean, median, mode, sample standard deviation and variance, plus the 25th, 50th and 75th percentiles calculated by linear interpolation — the same method as Excel's PERCENTILE.INC. Text columns get the most frequent values with their share, and the shortest, longest and average value length.

It is the fastest way to spot a column that is 40% empty, a status field with an unexpected fifth value, or a price column where one row is a thousand times bigger than the rest. Everything is computed locally in your browser, so confidential exports are never uploaded, and the whole profile exports as CSV or Markdown.

Frequently asked questions

How are the percentiles calculated?

By linear interpolation between the two closest ranks, the method used by Excel's PERCENTILE.INC and numpy's default. For the values 1, 2, 3, 4 the 25th percentile is 1.75, not 2 — worth knowing if you are comparing against a different tool.

Is the standard deviation a sample or population figure?

It is the sample standard deviation, dividing by n − 1. For 2, 4, 4, 4, 5, 5, 7, 9 that gives 2.138, whereas the population figure would be 2. Sample is the right default when your CSV is an extract rather than the whole universe.

How does it decide a column is numeric?

A column is treated as numeric when at least 80% of its non-blank values parse as numbers, which tolerates the occasional 'N/A' without giving up. Values with thousands separators or a trailing percent sign are parsed too.

What counts as a blank value?

Any cell that is empty or contains only whitespace. Blanks are counted separately from the filled values, so a mean is never dragged towards zero by missing data.

Can I profile a large export?

Yes — profiling is a single pass per column and runs entirely in your browser, so tens of thousands of rows are handled comfortably. Very large files are limited only by how much text the browser can hold in memory.

Related tools