CSV to SQL Converter (CREATE TABLE + INSERT)

Loading a spreadsheet into a database usually means writing a CREATE TABLE by hand and then hundreds of INSERT lines. Paste the CSV (or cells copied from Excel) and get both: column types are inferred from the data — whole numbers, decimals with the right precision, booleans, dates and text with a fitting length — and the rows are written as batched multi-row INSERTs, or as upserts if you name a key column. Identifiers, strings, booleans and dates are written the way MySQL, PostgreSQL, SQLite, SQL Server or Oracle expect.

How to use this tool

1. Paste CSV data with the column names in the first row.
2. Enter the table name and choose your database.
3. Choose whether to include CREATE TABLE and DROP TABLE IF EXISTS.
4. Optionally name a key column to get upsert statements instead of plain INSERTs.
5. Copy the SQL and run it in your database client.

Formula

INSERT INTO table (col, …) VALUES (row 1), (row 2), …; — one statement per batch of rows

Types: whole numbers → INTEGER (BIGINT beyond ±2,147,483,647), decimals → DECIMAL(p,s) with p = integer digits + s decimals, true/false → BOOLEAN (BIT in SQL Server, NUMBER(1) in Oracle, 1/0 in SQLite), YYYY-MM-DD → DATE, with a time → TIMESTAMP/DATETIME, anything else → VARCHAR(longest value) or TEXT. Values with a leading zero such as 02134 stay text. Single quotes are doubled; MySQL also doubles backslashes. Upserts use ON CONFLICT (PostgreSQL, SQLite), ON DUPLICATE KEY UPDATE (MySQL) or MERGE (SQL Server, Oracle).

Example

The sample products become CREATE TABLE "products" with id INTEGER, name VARCHAR(13), email VARCHAR(18), price NUMERIC(4,2) (4.50, 1.20 and 12), in_stock BOOLEAN and added DATE, followed by one INSERT with 3 rows: (3, 'O''Brien''s Ink', 'ink@example.com', 12, FALSE, NULL) shows the doubled quotes and the empty date as NULL. The empty email of row 2 also becomes NULL.