Structured Data

Data Type Detector

Paste CSV, TSV or other delimited values and instantly see the likely type and nullability of every column, plus a ready-to-copy schema. Runs entirely in your browser — your data never leaves the page.

Runs in your browser v1.0.0

Tabular data

pasted values

Auto-detect recognises comma, tab, semicolon and pipe delimiters, including quoted fields with embedded delimiters, quotes and newlines.

Detected types

live

No data yet

Paste delimited values above or load the example to detect column types.

Generated schema

How it works

Each value is classified against a ladder of types, from the most specific (boolean, integer, UUID, email, date…) down to plain text. A column keeps the most specific type that every non-empty value fits, so mixed integers and decimals become a number column, and a mix of dates and timestamps becomes a date/time column. A column is marked nullable when any cell is empty. The schema is generalised from those results and all processing happens locally.