How are column types detected?

Each column is scanned across all rows. If every non-empty value is a whole number it becomes INT, decimal numbers become FLOAT, and everything else becomes VARCHAR(255).

What CSV delimiters are supported?

Comma (,) is the primary delimiter. Values wrapped in double quotes are handled correctly, including quoted values that contain commas.

What does the batch size option do?

Instead of one INSERT per row, rows are grouped into a single INSERT statement with multiple value tuples. A batch size of 100 means up to 100 rows per INSERT, which is significantly faster for large imports.

CSV to SQL INSERT

Convert CSV data into SQL INSERT statements with auto-detected column types.

Table name

Batch size

Include CREATE TABLE

$csv input

lines

0 chars1 lines

$sql insert statements[READY]

lines

0 chars1 lines

Related Tools

SQLSQL Formatter

Format and beautify SQL queries with proper indentation and uppercase keywords.

{}→JSON to SQL Schema

Infer a SQL CREATE TABLE statement from a JSON object or array.

SQL→SQL Result to CSV

Convert tab- or pipe-separated SQL CLI output into clean CSV format.

FAQ

How are column types detected?: Each column is scanned across all rows. If every non-empty value is a whole number it becomes INT, decimal numbers become FLOAT, and everything else becomes VARCHAR(255).
What CSV delimiters are supported?: Comma (,) is the primary delimiter. Values wrapped in double quotes are handled correctly, including quoted values that contain commas.
What does the batch size option do?: Instead of one INSERT per row, rows are grouped into a single INSERT statement with multiple value tuples. A batch size of 100 means up to 100 rows per INSERT, which is significantly faster for large imports.

Paste CSV data, enter a table name, and generate ready-to-run SQL INSERT statements. Automatically detects column types: numbers become INT, decimals become FLOAT, and text becomes VARCHAR. Supports batch inserts and optional CREATE TABLE generation.