How to use it
- Paste your CSV into the input box, upload a .csv file, or drop a file onto the box.
- The SQL appears as you type.
- Enter your table name and choose the quoting style for your database.
- Copy the result or download it as a .sql file.
Good to know
- The first row is used as the header. Numbers and true/false become real numbers and booleans. Dotted headers such as supplier.city are rebuilt into nested objects, so converting back gives you the original shape.
- Empty cells become NULL and true/false become TRUE/FALSE. Pick standard double quotes for PostgreSQL and SQLite, backticks for MySQL, or square brackets for SQL Server.
About the formats
CSV
CSV (comma-separated values) stores a table as plain text: one row per line, with columns split by commas. Excel, Google Sheets and almost every database can import and export it.
SQL
SQL INSERT statements add rows to a database table. The output is one multi-row INSERT that runs in PostgreSQL, MySQL, MariaDB, SQLite and SQL Server.
Questions
- Is my data uploaded anywhere?
- No. The conversion runs in your browser with JavaScript. Your data never leaves your device, and the tool keeps working if you lose your connection after the page has loaded.
- Does it create the table too?
- No, it only writes the INSERT statement. Create the table first with column names that match the headers, or edit the column list in the output.