CSV Statistics
Get a summary of every column: filled and empty cells, unique values, and the minimum, maximum, sum and mean for number columns.
How to analyze a CSV file
Paste your CSV
The first row should be the header.
Read the table
Every column gets a row: filled and empty cells, unique values, and for numbers the minimum, maximum, sum and mean.
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
| Column | Filled | Empty | Unique | Type | Min | Max | Sum | Mean | Longest |
|---|---|---|---|---|---|---|---|---|---|
| name | 5 | 0 | 4 | text | 5 | ||||
| team | 5 | 0 | 4 | text | 9 | ||||
| city | 5 | 0 | 3 | text | 8 | ||||
| age | 5 | 0 | 4 | number | 36 | 85 | 252 | 50.40 | 2 |
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.