OFFICE🗃️CSV ⇄ SQL
Generate CREATE TABLE + INSERT
Generates MySQL-compatible CREATE TABLE + INSERT statements. Auto-detects delimiter (comma/semicolon/TAB/pipe). When "column type inference" is on, columns are inferred as INTEGER/DECIMAL/BOOLEAN/DATE/TEXT (TEXT only when off). Identifiers and string values are properly escaped (backticks and single quotes supported).
CSV ⇄ SQL: Auto-Generate CREATE + INSERT
Typical scenarios: ① import spreadsheet data into a database; ② batch-generate test data; ③ turn a small CSV into runnable INSERT statements during data migration.
How to use: upload or paste a CSV. The tool infers each column's type and generates the CREATE and INSERT statements — you can customize the table name and copy the result.
Notes: ① column types are auto-inferred — adjust them manually if a better fit is needed; ② date fields default to text to avoid format mismatches across databases; ③ the output is standard SQL — tweak it for your database's dialect if needed.
Related Tools
← Home