sql insert generate csv import table data

SQL INSERT Generator

Paste CSV to auto-generate INSERT statements using the first row as column names. The table name is customizable.

Paste CSV here (first row is the column name)

Table name

Number detection:

Empty cells:

USAGE

3 simple steps

1Paste CSV (first row is the column name)
2Enter the table name
3Click Generate to get INSERT statements

FAQ

Frequently Asked Questions

Q. How are empty cells and CSV "NULL" values handled?

A. Empty cells can be output as NULL or empty string ('') via the Empty cells option. Cells containing the literal text "NULL" are always output as unquoted NULL regardless of the option.

Q. A numeric column is getting quotes around its values.

A. After generating, click a column name shown below the output to toggle quoting off and re-generate instantly. Alternatively set Number detection to Auto to unquote all numeric-only values from the start.