Data & CSV
CSV column profile
Inspect missing values, distinct values and numeric summaries by column.
A clear answer. Here’s how.
For each column, counts rows, whitespace-empty cells, distinct non-blank exact values and decimal numeric cells. Numeric min/max/mean use only valid finite decimal cells, with up to 100 digits of magnitude; mixed text is counted separately. Profiles describe the supplied data rather than inferring a definitive schema or changing values.
See a worked example
Worked example
A fixed demonstration, separate from the values you enter above.
- Your CSV data
ID,Name,Department,Amount,Date 001,Ada,Design,120,2026-01-05 002,Sam,Writing,80,2026-01-06 003,Jo,Design,150,2026-01-07 004,Lee,Writing,,2026-01-08 005,Alex,Design,60,2026-01-09
- Column separator
- Comma
Example result
| Column | Rows | Blank / whitespace | Distinct non-blank | Decimal numeric cells | Other non-blank | Numeric minimum | Numeric maximum | Numeric mean |
|---|---|---|---|---|---|---|---|---|
| ID | 5 | 0 | 5 | 5 | 0 | 1 | 5 | 3 |
| Name | 5 | 0 | 5 | 0 | 5 | |||
| Department | 5 | 0 | 2 | 0 | 5 | |||
| Amount | 5 | 1 | 4 | 4 | 0 | 60 | 150 | 102.5 |
| Date | 5 | 0 | 5 | 0 | 5 |