About this tool
Manually turning a spreadsheet export into SQL INSERT statements is tedious and error-prone — you need to correctly quote strings, leave numbers unquoted, escape apostrophes, and repeat the pattern for every row. This tool automates that: paste CSV data, set your table name, and it generates a ready-to-run block of INSERT statements with proper type detection, so numeric columns aren't wrapped in quotes and text columns are safely escaped. It's built for getting sample or exported data into MySQL, PostgreSQL, or standard SQL databases quickly, whether you're seeding a test database, migrating a small dataset, or turning a spreadsheet a colleague sent you into something you can run directly against a table.
Frequently asked questions
Does it detect column types automatically?
Yes — values that look numeric are inserted unquoted, and everything else is treated as text and properly escaped.
Can I set a custom table name?
Yes, there's a field to specify the target table name used in every generated INSERT statement.
Does it handle special characters like apostrophes?
Yes — single quotes inside text values are automatically escaped so the generated SQL runs without syntax errors.
Is the output compatible with PostgreSQL and MySQL both?
The generated syntax uses standard SQL INSERT formatting that works in both, though database-specific quirks (like identifier quoting style) may need minor adjustment.
What if my CSV has a header row?
The first row is used as column names for the generated INSERT statements; make sure your CSV includes headers before pasting.