How are column types inferred?

Per-column heuristic: all-integer → INTEGER, all-numeric → DECIMAL, all-boolean → BOOLEAN, short strings → VARCHAR(255), longer → TEXT.

CSV to SQL INSERT Statements

NEW

Paste a CSV and get SQL INSERT statements for MySQL, PostgreSQL, SQLite or MS SQL — optionally with a CREATE TABLE preamble (column types are inferred from the data). Multi-value INSERT mode collapses everything into one statement.

Table Dialect First row is column names Include CREATE TABLE Multi-value INSERT (one statement)

CSV input SQL output

More options

Load file

Unix (LF) Dos (CRLF)

Load file

Unix (LF) Dos (CRLF)

→ Send output to:

How to use CSV to SQL

Paste your CSV.
Set table name and dialect.
Optionally enable CREATE TABLE.
Click Generate SQL.

What is CSV to SQL?

Each cell value is quoted appropriately — numbers stay unquoted, NULL handled, booleans recognized. Identifier escaping follows the chosen dialect (backticks for MySQL, double-quotes for Postgres, brackets for MSSQL).

FAQ

How are column types inferred?: Per-column heuristic: all-integer → INTEGER, all-numeric → DECIMAL, all-boolean → BOOLEAN, short strings → VARCHAR(255), longer → TEXT.

Related tools

← Back to CSV Tools · All tags

Last updated: 2026-05-22

CSV to SQL INSERT Statements

How to use CSV to SQL

What is CSV to SQL?

FAQ

Related tools

Ad blocker detected

Keyboard shortcuts