CSV Column Profiler

Inspect types, missing values, uniqueness and common values.

Common values

CSV input89 B · paste or drop a file

1 2 3 4 5 6

Column profile

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106

{ "rowCount": 4, "columnCount": 4, "columns": [ { "name": "id", "index": 0, "inferredType": "integer", "rows": 4, "missing": 0, "missingPercent": 0, "unique": 3, "uniquePercent": 75, "min": 1, "max": 3, "commonValues": [ { "value": "1", "count": 2 }, { "value": "2", "count": 1 }, { "value": "3", "count": 1 } ] }, { "name": "name", "index": 1, "inferredType": "string", "rows": 4, "missing": 0, "missingPercent": 0, "unique": 3, "uniquePercent": 75, "min": "Ada", "max": "Linus", "commonValues": [ { "value": "Ada", "count": 2 }, { "value": "Grace", "count": 1 }, { "value": "Linus", "count": 1 } ] }, { "name": "status", "index": 2, "inferredType": "string", "rows": 4, "missing": 0, "missingPercent": 0, "unique": 2, "uniquePercent": 50, "min": "active", "max": "paused", "commonValues": [ { "value": "active", "count": 3 }, { "value": "paused", "count": 1 } ] }, { "name": "score", "index": 3, "inferredType": "integer", "rows": 4, "missing": 0, "missingPercent": 0, "unique": 3, "uniquePercent": 75, "min": 70, "max": 95, "commonValues": [ { "value": "95", "count": 2 }, { "value": "70", "count": 1 }, { "value": "88", "count": 1 } ] } ] }

✓ complete89 B → 1868 B0.0 ms

About CSV Column Profiler

CSV Column Profiler summarizes the quality and shape of every field in a table: inferred data type, missing values, uniqueness, extrema and the most frequent values.

How it works

Practical type inference

Each non-empty value is classified as integer, number, boolean, ISO-style date or string. Columns with incompatible evidence are marked mixed instead of forcing a misleading type.

Completeness and cardinality

Missing and unique counts include percentages, making sparse identifiers, low-cardinality categories and accidental blanks easy to spot.

Ranges and common values

Numeric and date columns receive typed min/max values. Frequency counts expose dominant values and are capped by the selected Top setting.

Frequently asked questions

Does profiling change the CSV?

No. It only reads the table and produces a JSON report.

How are blank values counted?

Empty strings are missing; optionally, whitespace-only cells are treated as missing too.

Is the data uploaded?

No. Profiling runs entirely in your browser.

Sources & last verified

The behaviour of this tool and the claims on this page were checked against the specifications below on 5 September 2026. Everything runs in your browser, so the output you see is exactly what the engine produced.

RFC 4180 — Common format for CSV files

Found a wrong result or an outdated claim? Report an error and it will be re-verified.

Related Validate tools

csv⌁CSV Encoding Inspector csv✓CSV Validator env✓.env Parser / Validator