CSV Schema Detector

Paste CSV data to automatically detect column names, data types, and basic statistics.

Input

Settings

Delimiter

First row is header

Lines: 5Characters: 200Rows: 4

Data preview

id	name	email	age	is_active	created_at
1	Alice	alice@example.com	28	true	2024-01-15
2	Bob	bob@example.com	35	false	2024-02-20
3	Charlie		42	true	2024-03-10
4	Diana	diana@example.com	31	true	2024-04-05

Detected Columns

Column	Type	Unique	Sample Values
id	integer	4	1, 2, 3
name	string	4	Alice, Bob, Charlie
email	emailNullable	3	alice@example.com, bob@example.com, diana@example.com
age	integer	4	28, 35, 42
is_active	boolean	2	true, false
created_at	date	4	2024-01-15, 2024-02-20, 2024-03-10

SQL

CREATE TABLE my_table (
  id INTEGER NOT NULL,
  name VARCHAR(255) NOT NULL,
  email VARCHAR(255) NULL,
  age INTEGER NOT NULL,
  is_active BIT NOT NULL,
  created_at DATE NOT NULL
);