CSV Tools
CSV Column Type Detector
Automatically infer the data type of each CSV column.
Loading tool…
What is Column Types?
Scans every column in a CSV and infers its data type (number, boolean, date, string, empty) with sample values shown per column.
How it works
Non-empty values in each column are tested against type detection rules: numbers must match a numeric pattern, booleans must be true/false, dates must parse successfully.
- Paste CSV. Paste CSV data.
- Read types. Each column is shown with its inferred type and sample values.
Examples
Column detection
age: 30, 25, 35 → number. vip: true, false → boolean. name: Alice, Bob → string.
Common mistakes
Mixed type columns
A column with numbers and text defaults to 'string' type.
Alternatives
CSV Column Statistics
For getting numeric stats alongside type info.
Frequently asked questions
How accurate is the type detection?
It uses conservative heuristics — false negatives are preferred over false positives.