CSV to SQL Converter

Convert CSV to SQL INSERT statements with an optional CREATE TABLE for MySQL, PostgreSQL, SQLite or SQL Server, detecting numbers and booleans. Free.

CSV input

Open file

Delimiter

SQL dialect

Table name

Detect numbers and booleansInclude CREATE TABLEMulti-row INSERT

SQL output

Runs entirely in your browser. Your data is never uploaded.

Related Tools

View All

Color Converter Number Base Converter Text to Binary Binary to Text NATO Phonetic Alphabet Converter JSON to TypeScript JSON to Go Struct JSON to Python

What is CSV to SQL?

Convert CSV data with a header row into SQL statements: a CREATE TABLE with inferred column types and INSERT statements for every row, quoted and escaped for MySQL, PostgreSQL, SQLite or SQL Server.

How to use CSV to SQL

Paste CSV into the CSV input box, or use Load sample or Open file.
Choose the Delimiter, SQL dialect and Table name.
Toggle Detect numbers and booleans, Include CREATE TABLE and Multi-row INSERT.
The SQL output updates as you type; use Copy or Download.

Example

Input

id,name
1,Ada
2,Bob

Output

CREATE TABLE `my_table` (
  `id` INT,
  `name` VARCHAR(255)
);

INSERT INTO `my_table` (`id`, `name`) VALUES
  (1, 'Ada'),
  (2, 'Bob');

When to use CSV to SQL

Use it for one-off imports when you cannot use a database's native CSV loader (LOAD DATA, COPY, BULK INSERT). For millions of rows those native loaders are much faster.

How CSV to SQL works

The CSV is parsed with PapaParse using the first row as column names. With type detection, a cell becomes a number only if it is a plain integer or decimal without leading zeros (so 007 stays text), true/false become booleans and empty cells become NULL. The same type inference, identifier quoting and string escaping as the JSON to SQL tool is then applied.