CSV to SQL INSERT Statements Converter

CSV to SQL INSERT Statements Converter

Convert CSV data to SQL INSERT statements for MySQL, PostgreSQL, SQLite, SQL Server, and Oracle. Paste your CSV with column headers, configure options like batch inserts and type detection, and get properly escaped SQL ready to execute. Handles quoted fields, embedded commas, NULL values, and dialect-specific escaping.

How to Use

Paste CSV data into the input area (first row must be column headers). Select your target database flavor, set a table name, and choose your INSERT style (individual, batch, or chunked). The converter auto-detects column types and generates properly escaped SQL instantly. Review detected columns in the preview, override types if needed, and copy or download the SQL output. Optionally include a CREATE TABLE statement or transaction wrapper.

Features

• 5 Database Flavors — MySQL (backtick identifiers), PostgreSQL (double-quote identifiers), SQLite (double-quote), SQL Server (bracket identifiers), and Oracle (INSERT ALL syntax). Each with correct escaping and quoting rules.
• Batch INSERT — Individual INSERT per row, multi-row batch INSERT with VALUES clauses, or configurable chunk size. SQL Server auto-limits to 1000 rows per statement. Oracle uses INSERT ALL … SELECT FROM dual.
• Auto Type Detection — Automatically identifies integers, floats, booleans, NULLs, and strings from your data. Numbers are unquoted, strings are properly escaped and quoted, NULLs are literal NULL.
• Column Editor — Preview detected columns with names, types, and sample values. Rename columns and override type detection before generating SQL.
• NULL Handling — Configure how empty values are treated: as SQL NULL, as empty strings, or detect “NULL” text as actual NULL values.
• CREATE TABLE — Optionally prepend a CREATE TABLE statement with inferred column types mapped to each database dialect (VARCHAR, INT, DECIMAL, BOOLEAN, etc.).
• Transaction Wrapper — Optionally wrap output in BEGIN/COMMIT for atomic execution.
• RFC 4180 CSV Parsing — Handles quoted fields with embedded commas, escaped quotes, and newlines within fields. Auto-detects delimiter (comma, tab, semicolon, pipe).

SQL INSERT Syntax

The SQL INSERT statement adds rows to a database table. The basic syntax is: INSERT INTO table_name (column1, column2) VALUES ('value1', 'value2'); String values must be properly escaped — single quotes within values are doubled (O’Brien becomes O”Brien). Numeric values are inserted without quotes. NULL is a keyword, not a string. Batch inserts combine multiple rows in a single statement for better performance: INSERT INTO table VALUES (...), (...), (...);