CSV Statistics

Get a summary of every column: filled and empty cells, unique values, and the minimum, maximum, sum and mean for number columns.

Processed on your device. Files are not uploaded

How to analyze a CSV file

  1. Paste your CSV

    The first row should be the header.

  2. Read the table

    Every column gets a row: filled and empty cells, unique values, and for numbers the minimum, maximum, sum and mean.

  3. Spot problems

    Look for columns with empty cells or fewer unique values than you expect.

Worked example

This is what CSV Statistics gives for its own sample values. Open the tool above and change anything to try your own.

CSV

name,team,city,age
Ada,Platform,London,36
Linus,Kernel,Helsinki,54
Grace,Compilers,New York,85
Ada,Platform,London,36
Alan,Research,London,41
Delimiter
Detect automatically
ColumnFilledEmptyUniqueTypeMinMaxSumMeanLongest
name504text5
team504text9
city503text8
age504number368525250.402

About CSV Statistics

Profile a CSV file in one step: how many cells are filled or empty in each column, how many unique values there are, whether the column is numeric, and its minimum, maximum, sum and mean.

FAQs

How is a column judged numeric?

Every filled cell must be a number.

Are empty cells counted?

They are reported separately and left out of the sums.

Can I fix the problems it finds?

Use CSV Filter or CSV Duplicate Remover.

Related tools