CSV → SQL INSERT 生成器

免费在线 CSV 转 SQL INSERT 工具：粘贴 / 拖拽 CSV 自动识别分隔符（逗号/Tab/分号/竖线），智能推断列类型（INT / DECIMAL / DATE / DATETIME / BOOLEAN / VARCHAR），可选生成 CREATE TABLE，支持 MySQL / PostgreSQL / SQLite / SQL Server 多方言、批次拆分、空值处理。所有处理在浏览器本地完成

Usage & overall rating
NaNToday Remaining
NaNConverted
NaNTotal Helped
Rating(undefined users)
Table
Dialect
MySQL
Delimiter
detected: ,
Batch
Click or drop a .csv file
id,name,email,age,signup_at,is_active,note 1,Alice,alice@example.com,30,2024-01-15 10:30:00,true,"Hello, world" 2,Bob,bob@example.com,25,2024-02-20 09:00:00,false,"with ""quote"" inside" 3,小明,xiaoming@test.com,,2024-03-01 14:00:00,1,中文测试 4,Eve,eve@example.com,28,2024-04-01 12:00:00,0,
Type CSV on the left to see generated SQL
User Guide
✨ Features
• RFC 4180 compliant CSV parser — handles quoted fields, embedded newlines, '' escaping • Auto-detects delimiter: comma / Tab / semicolon / pipe (manual override available) • Smart column type inference: TINYINT / SMALLINT / INT / BIGINT / DECIMAL / DATE / DATETIME / BOOLEAN / VARCHAR(N) / TEXT / EMAIL / UUID • Optional CREATE TABLE generation with NULL / NOT NULL annotations • Four dialects: MySQL / PostgreSQL / SQLite / SQL Server, each with the right identifier-quoting style • Batch splitting: max N rows per INSERT (default 500), avoids over-large statements • Live data preview (first 10 rows) + type chips + line-numbered error messages • Drag-and-drop upload / paste / download .sql file • All processing local in your browser — CSV never leaves your device
📖 How to Use
Step 1
Paste CSV text or drop a .csv file into the upload area
Step 2
Configure: table name, dialect, delimiter (auto-detect), include CREATE TABLE
Step 3
The right pane shows generated SQL live; below shows inferred column types and a data preview
Step 4
Click 'Download SQL' to save, or 'Copy' to paste into your client

Rate this tool (optional)

Could not load your rating. You can still use the tool. Please retry.

Feedback List