CSV to SQL
· runs entirely in this browser, nothing is uploaded
1 · CSV input
Encoding
UTF-8
Windows-1252 (Excel "CSV")
ISO-8859-1
UTF-16 LE
Example
Clear
First row is header
Delimiter
Auto
,
;
Tab
|
4 · SQL output
Copy
Download .sql
2 · Options
Database
MySQL / MariaDB
PostgreSQL
SQL Server
SQLite
Oracle
ANSI
Table
Statement
INSERT
REPLACE (MySQL/SQLite)
UPDATE (by Key)
DELETE (by Key)
Rows per INSERT
DROP TABLE
IF EXISTS
CREATE TABLE
IF NOT EXISTS
Empty field → NULL
Text "NULL" → NULL
Trim values
Quote all names
3 · Fields
— types are detected; edit anything
#
Name
Type
Size
Key
Include
NOT NULL
Sample