CSV / Excel to SQL Converter - Instant Online Schema & Insert Generator

CSV to SQL conversion is the process of taking tabular data from spreadsheets or plain text files and translating it into Structured Query Language (SQL) statements. This typically includes two primary components: Data Definition Language (DDL) to create the database table with appropriately typed columns (`CREATE TABLE`), and Data Manipulation Language (DML) to populate the table with rows (`INSERT INTO`). Manually writing SQL insert statements for hundreds or thousands of rows is tedious, error-prone, and slow. Our tool automates the entire migration pipeline in milliseconds right in your browser.

• **Automated Data Type Inference**: Analyzes cell values to accurately detect booleans, integers, bigints, decimals, ISO timestamps, JSON, and text.
• **Multiple SQL Dialects**: Full support for PostgreSQL, MySQL, SQLite, Microsoft SQL Server (T-SQL), and Plus dialects including Oracle (PL/SQL), Google BigQuery, Snowflake, and DuckDB.
• **Batched INSERT Generation**: Generates multi-row insert statements in configurable batch sizes (50, 100, 500 rows) to prevent query payload limits and accelerate database execution.
• **Transaction Wrapping**: Automatically encloses generated queries in `BEGIN TRANSACTION ... COMMIT` blocks for atomic, safe execution.
• **Multi-Format Input**: Upload `.csv`, `.tsv`, `.xlsx`, or paste directly from your clipboard (including tab-separated data copied from Google Sheets or Excel).
• **100% Client-Side Privacy**: All file parsing, type inference, and SQL generation run entirely inside your browser. Your sensitive business spreadsheets are never transmitted to any server.

• 1. **Input Your Data**: Drag & drop your `.csv` or `.xlsx` file, or switch to the "Paste Text" tab to paste copied rows from Google Sheets.
• 2. **Select Database Dialect**: Choose your target database (PostgreSQL, MySQL, SQLite, SQL Server, etc.).
• 3. **Configure Options**: Customize your Table Name, Batch Size, and choose whether to include `CREATE TABLE` or Transaction blocks.
• 4. **Click Generate**: Click "Generate SQL Query" to run the instant conversion pipeline.
• 5. **Preview & Download**: Inspect the highlighted SQL in the Monaco Editor, copy it to your clipboard, or click "Download .sql" to save the file.

• **PostgreSQL**: Maps to `BOOLEAN`, `INTEGER`, `BIGINT`, `NUMERIC(12, 4)`, `TIMESTAMPTZ`, `JSONB`, and `VARCHAR(255)` / `TEXT` with double-quoted identifiers.
• **MySQL / MariaDB**: Maps to `TINYINT(1)`, `INT`, `BIGINT`, `DECIMAL(12, 4)`, `DATETIME`, `JSON`, and `VARCHAR(255)` / `TEXT` with backtick identifiers.
• **SQLite**: Maps dynamically to `INTEGER`, `REAL`, and `TEXT` for lightweight embedded databases.
• **SQL Server (T-SQL)**: Maps to `BIT`, `INT`, `BIGINT`, `DECIMAL(12, 4)`, `DATETIME2`, `NVARCHAR(MAX)` with square bracket `[identifier]` escaping.
• **Enterprise & Cloud Warehouses (Plus)**: Dedicated syntax for Oracle PL/SQL, Google BigQuery, Snowflake, and DuckDB analytical engines.

• **Use Batch Inserts**: Inserting thousands of single-row `INSERT INTO ... VALUES (...)` statements creates severe network round-trip overhead. Batching 50 to 500 rows per statement executes orders of magnitude faster.
• **Wrap in Transactions**: Using `BEGIN TRANSACTION` and `COMMIT` avoids creating a separate disk write operation for every single statement and ensures your database can rollback cleanly if an error occurs.
• **Sanitize Column Names**: Avoid spaces and special characters in column names. Our tool automatically converts headers into lowercase `snake_case` to ensure cross-database portability.
• **Inspect Data Before Inserting**: Use the Preview feature to confirm inferred column types before running the script on a production database.