Convert CSV to SQLite SQL

How to convert a CSV file to SQLite

SQLite is a local, file-based database — which makes it a natural fit for SQLified, since both run without a server. Drop your CSV and SQLified writes a CREATE TABLE + INSERT script with sensible column types, ready to run against a new or existing .db file.

1. Drop your CSV onto the converter above (or click to choose a file).
2. Review the schema. SQLified infers SQLite type affinity. Adjust any type, mark columns nullable, rename them, or set a primary key.
3. Generate the SQL — a CREATE TABLE plus batched INSERT statements.
4. Run it with sqlite3 mydb.db < script.sql or paste it into DB Browser for SQLite.

What the generated SQL looks like

CREATE TABLE IF NOT EXISTS "users" (
  "id" INTEGER NOT NULL,
  "name" TEXT NOT NULL,
  "signup_date" DATE NOT NULL,
  "amount" REAL NOT NULL
);

INSERT INTO "users" ("id", "name", "signup_date", "amount") VALUES
('1', 'Ada Lovelace', '2026-01-04', '120.50'),
('2', 'Alan Turing', '2026-02-11', '99.00');

Identifiers are double-quoted, and CREATE TABLE IF NOT EXISTS means the script is safe to re-run.

SQLite type affinity

Unlike most databases, SQLite doesn't enforce rigid column types — it uses type affinity, a preferred storage class per column. SQLified maps your data accordingly:

• Whole numbers → INTEGER.
• Decimals → REAL.
• Dates → DATE / DATETIME (stored as text, which SQLite handles natively).
• Everything else → TEXT.

This beats a plain .import, which would otherwise store every column as text.

Frequently asked questions