CSV to SQL INSERT Generator
Generate SQL CREATE TABLE and INSERT statements from CSV data for MySQL, PostgreSQL, SQLite or SQL Server.
How to use
- 1Paste CSV with a header row.
- 2Set the table name and dialect, then copy the SQL.
Frequently asked questions
How are column types chosen?
Each column is checked: all integers become INTEGER, all numbers DECIMAL/REAL, true/false BOOLEAN, everything else text.
Are quotes in values escaped?
Yes. Single quotes are doubled (O'Brien → 'O''Brien'), which is the SQL standard escape.
How are empty cells stored?
Empty cells become NULL rather than an empty string.