CSV to SQL converter

To convert CSV to SQL, paste the CSV data below: the tool generates CREATE TABLE and INSERT statements for MySQL, PostgreSQL, SQLite or SQL Server – with detected column types and properly escaped text. Everything in your browser.

Source: IETF – RFC 4180: Common Format and MIME Type for CSV Files. Updated: 2 October 2026.

CSV

Database

Table name

First row contains the column names

Separator

Decimal mark in numbers

Clean up names (lower case, no special characters)

Include CREATE TABLE

Several rows per INSERT (500)

Empty fields as NULL

My Toolbox

Result

SQL: CREATE TABLE "products" ( "id" INTEGER, "name" TEXT, "price" DOUBLE PRECISION, "date" DATE ); INSERT INTO "products" ("id", "name", "price", "date") VALUES (1, 'Apple', 1.2, '2026-10-01'); INSERT INTO "products" ("id", "name", "price", "date") VALUES (2, 'Pear', 0.95, '2026-10-02'); INSERT INTO "products" ("id", "name", "price", "date") VALUES (3, 'Kiwi, green', NULL, '2026-10-03');
Summary: 3 rows, 4 columns · separator: comma · table: products · columns: id: integer, name: text, price: decimal number, date: date

How it is calculated

Converting CSV to SQL means turning a table in text form into a table in the database: first the structure (CREATE TABLE), then the rows (INSERT). The tool reads your CSV data in your browser following RFC 4180, derives the column types from all values and writes the SQL in your database’s dialect.

How it works

Paste CSV, for example from Excel or an export (separator and decimal mark are detected).
Choose the database and table name; if you like, clean up names, leave out CREATE TABLE or bundle INSERTs.
Copy the SQL and run it in your database tool.

What the tool detects and adjusts

Types: integers (INT or BIGINT), decimal numbers, booleans, dates and dates with time (also from DD.MM.YYYY), otherwise text with a fitting length. Numbers with a leading zero, such as postcodes, stay text.
Names: in backticks, double quotes or square brackets depending on the database; optionally lower case and without special characters, duplicates are numbered.
Text: single quotes are doubled; MySQL also escapes the backslash, SQL Server adds the N prefix for special characters.
Empty fields: NULL or empty text, as you choose.

Limits

The generated SQL is meant for small to medium amounts of data. For very large files, COPY (PostgreSQL), LOAD DATA (MySQL), .import (SQLite) or BULK INSERT (SQL Server) are faster.

Up to 100,000 rows and 3 million characters. Only SQL text is generated, nothing is executed; check types and names before loading.
Primary keys, indexes and numbers with thousands separators (“1,234.50”) are not derived – such columns stay text.

Privacy

The data never leaves your browser. Next steps: CSV to JSON, CSV to Excel or format SQL.

Frequently asked questions

How do I convert CSV to SQL?

Paste the CSV and choose the database and table name: the tool generates CREATE TABLE and INSERT statements that you copy and run.

Which databases are supported?

MySQL/MariaDB, PostgreSQL, SQLite and SQL Server. Types, name quoting and escaping follow the chosen system.

How does the tool detect column types?

From all values of a column: only whole numbers give INT/BIGINT, decimals give decimal numbers, true/false a boolean, valid dates DATE. Everything else becomes text.

Why are postcodes text?

Because leading zeros (for example 01067) would be lost as a number. Numbers with a leading zero therefore stay text.

Can I convert CSV to SQL without uploading the file?

Yes. Everything runs in your browser.

How do I load very large CSV files into a database?

Use the database’s import commands (COPY, LOAD DATA, .import, BULK INSERT). This tool is meant for small to medium amounts of data and for creating the table structure.

Sources and legal basis

As of: 2 October 2026 · Editorial policy