CSV to SQL Converter
ConvertersConvert CSV data to SQL INSERT statements instantly in your browser. Auto-detects column types. Shows table preview. One-way conversion. 100% client-side.
CSVcsv
Loading editor…
SQLsql
Loading editor…
Input: 152 chars
About CSV to SQL Converter
The CSV to SQL converter parses CSV data using csv-parse and generates a `CREATE TABLE` statement plus `INSERT INTO` rows. Column types are inferred automatically — numeric columns become `INTEGER` or `REAL`, boolean strings become `BOOLEAN`, and all other columns become `TEXT`. The CSV input panel shows a sortable table preview. The conversion is one-way; use CSV to JSON and then JSON to SQL for more control.
Features
- ✓Generates CREATE TABLE and INSERT INTO statements from CSV data
- ✓Automatic column type inference: INTEGER, REAL, BOOLEAN, TEXT
- ✓First CSV row treated as column names
- ✓Sanitises column names for SQL compatibility
- ✓CSV input has interactive sortable table view
- ✓Download generated SQL as a .sql file
- ✓Copy output to clipboard in one click
- ✓Web Worker processing — never blocks the UI
- ✓100% client-side — data never leaves your browser
Common Use Cases
- Importing spreadsheet data into a SQL database via generated INSERT statements
- Generating SQL seed files for development databases from CSV fixtures
- Quickly populating test databases from CSV exports
- Migrating CSV data to MySQL, PostgreSQL, or SQLite
- Creating SQL migration scripts from legacy data exports
Frequently Asked Questions
QWhat SQL dialect does the output target?
The generated SQL uses standard syntax (quoted identifiers, standard types) compatible with MySQL, PostgreSQL, and SQLite. Minor syntax tweaks may be needed for specific dialects.
QHow are column types determined?
The converter samples all values in each column. If all are integers it uses INTEGER, if all are numeric it uses REAL, true/false values produce BOOLEAN, and all others produce TEXT.
QIs my data sent to a server?
No. All conversion runs in a Web Worker inside your browser.