DiagramDB
DiagramDB / CSV to SQLite

CSV to SQLite

Turn a CSV export into a SQLite table: a CREATE TABLE with sensible types and INSERT statements you can run as they are.

SQL · 3 rows
CREATE TABLE imported_rows (
  id INTEGER NOT NULL,
  email TEXT NOT NULL,
  signup_date TEXT NOT NULL,
  plan TEXT NOT NULL,
  monthly_fee REAL NOT NULL,
  is_active INTEGER NOT NULL
);

INSERT INTO imported_rows (id, email, signup_date, plan, monthly_fee, is_active) VALUES
(1, 'ada@example.com', '2026-01-14', 'pro', 29.00, 1),
(2, 'grace@example.com', '2026-02-02', 'free', 0, 1),
(3, 'O''Brien, Kate', '2026-02-19', 'team', 99.50, 0);

Detected columns

Types are inferred from every value in the column. Override any that are wrong: zip codes and phone numbers with leading zeros stay text on purpose.

ColumnTypeNullableLongest value
idno1
emailno17
signup_dateno10
planno4
monthly_feeno5
is_activeno5

Big file? Use SQLite’s bulk loader

Copy just the CREATE TABLE statement from the output above, run it, then load the whole file straight into the new table:

SQLite bulk import
.mode csv
.import --skip 1 data.csv imported_rows

These are sqlite3 shell commands. --skip needs version 3.32 or newer. Wrap generated INSERTs in BEGIN; … COMMIT; for a large speed-up.

Other databases

CSV to MySQL · CSV to PostgreSQL · CSV to SQL Server · CSV to Oracle · JSON to SQL

Questions

How do I convert a CSV file to SQLite INSERT statements?

Paste the CSV or open the file, check the detected column types, and copy or download the script. It contains a SQLite CREATE TABLE (optional) followed by multi-row INSERT statements in batches you choose.

How do I import a large CSV into SQLite?

For more than about 100,000 rows, use the bulk loader shown on this page. It is much faster than running INSERT statements. Generate the CREATE TABLE here, then bulk-load the file into it.

Which SQLite data types are used?

Whole numbers become integer types, decimals become exact numeric types (never floating point), true/false values become booleans, ISO dates and timestamps become date/time types, and everything else becomes a text type sized from the longest value. You can override any column.

Is my file uploaded?

No. The CSV is parsed and converted in your browser, and nothing is sent to a server.

Related tools