DataFlow Convert

CSV to SQL

Upload a CSV and download a .sql file with a CREATE TABLE statement and all rows as INSERT INTO statements, ready to paste into any SQL client.

File
Convert to

What the output looks like

CREATE TABLE IF NOT EXISTS "employees" (
  "id" INTEGER,
  "name" TEXT,
  "salary" REAL
);

BEGIN;
INSERT INTO "employees" ("id", "name", "salary") VALUES (1, 'Alice', 95000.0);
INSERT INTO "employees" ("id", "name", "salary") VALUES (2, 'Bob', 72000.0);
COMMIT;

Type inference

Columns are automatically typed as INTEGER, REAL, or TEXT based on the data.

Transactional inserts

All INSERT statements are wrapped in BEGIN / COMMIT for fast, safe bulk loading.

Table name from filename

Upload employees.csv and the table is named employees. Override it via the API options.

Any SQL database

Standard SQL syntax compatible with PostgreSQL, MySQL, SQLite, and others.

Prefer a binary database file instead? Convert CSV to SQLite →