CSV to SQL INSERT statements

How to use it

1. Enter csv data, cell delimiter, table name, statement style, identifier quoting and leave numbers unquoted.
2. The result appears straight away and updates as you edit.
3. Copy the result, or copy a link that keeps the same values to share it.

How it is calculated

The first row gives the column names. Text goes between single quotes with any inner ' doubled (O''Brien). Numbers like 30 and 12.5 stay unquoted (except leading zeros like 007), and empty cells become NULL when that option is on.

Example

Inputs: Cell delimiter = Detect automatically, Table name = products, Statement style = One statement, many rows, Identifier quoting = None, Leave numbers unquoted = yes. Result: SQL statements: INSERT INTO products (product, price, qty) VALUES ('Tea', 12.5, 3), ('Coffee', 18, 2), ('Dates', 30, 1);; Data rows: 3; Columns: 3.

product,price,qty
Tea,12.5,3
Coffee,18,2
Dates,30,1

INSERT INTO products (product, price, qty) VALUES
  ('Tea', 12.5, 3),
  ('Coffee', 18, 2),
  ('Dates', 30, 1);

Limits and caveats

• No CREATE TABLE is generated, so the table must already exist with suitable columns.
• Only ' is escaped, as standard SQL requires. In MySQL with default settings, double any backslash \ in the text.
• Dates and booleans are written as quoted text.