CSV to SQL
Paste or upload a CSV — get a CREATE TABLE with inferred column types, and batched INSERT statements.
Files never leave your browser.
CREATE TABLE
CREATE TABLE "users" ( "id" INTEGER, "name" TEXT, "active" BOOLEAN, "score" DOUBLE PRECISION );
INSERT (1 statement)
INSERT INTO "users" ("id", "name", "active", "score") VALUES
(1, 'Ada Lovelace', TRUE, 9.5),
(2, 'Doe, John', FALSE, 10);Runs in your browser. Nothing you type is sent anywhere.
How this works
- The first row is the header; quoted fields, embedded commas and embedded newlines inside quotes are all handled, per the common CSV convention.
- Choose the delimiter if your file doesn't use a comma (e.g. ; or tab).
- Each cell is typed as boolean, number or text before column-type inference runs, same as the JSON to SQL tool.
Do this against your live database in Tablyne.
PostgreSQL GUI →FAQ
Does my file get uploaded anywhere? +
No — parsing happens entirely in your browser, whether you paste the CSV or upload a file.
What if a column is empty in some rows? +
An empty cell becomes NULL; if every value in a column is empty, its type falls back to TEXT.
Can I use a semicolon or tab as the delimiter? +
Yes — set the delimiter field to whatever single character separates your columns.