CSV to SQL INSERT

Build INSERT drafts from CSV headers and rows with quoted identifiers and text values.

The example value has been entered. Check it immediately or change the value.

Input is processed in the browser. Refreshing returns a sample value.

Result

Instructions and example

Apostrophes in text and double quotes in identifiers are doubled. Every value is text. Verify the SQL dialect for your connection separately.

The Pen, 1200 row becomes INSERT INTO "products" ("name", "price") VALUES ('Pen', '1200');.

Every value is text, including empty strings. Table names must be simple identifiers; statements are never executed.

Frequently asked questions

How are apostrophes inside cells represented?

Apostrophes in text and double quotes in identifiers are doubled. Every value is text. Verify the SQL dialect for your connection separately.

Are blank cells inferred as NULL or numbers?

Every value is text, including empty strings. Table names must be simple identifiers; statements are never executed.

Calculation criteria and reference materials

Verification of calculation criteria: · Calculation·verification principles · Report errors