The TOOLBeans CSV to SQL converter turns CSV, TSV and Excel spreadsheet data into ready-to-run SQL statements for any major database. Instead of writing INSERT statements by hand or wrestling with import wizards, you paste your data or drop in a file and the tool produces a clean, correct SQL script, complete with an optional CREATE TABLE schema, in a fraction of a second. It supports MySQL, PostgreSQL, SQLite, SQL Server, MariaDB and Oracle, and generates the right identifier quoting, data type names and INSERT syntax for whichever one you choose.
The converter reads each column and works out the most appropriate data type for it, recognising integers, decimals, booleans, dates, timestamps and text. You can then fine-tune the result in the Columns editor: rename a column, override the detected type, or exclude columns you do not want, all before generating the SQL. Empty cells are turned into proper NULL values, string values are safely escaped to prevent broken statements, and you can wrap everything in a transaction so the whole import succeeds or fails as one unit.
Everything happens entirely in your browser. Your spreadsheets, which often contain sensitive customer or business data, are never uploaded to any server, which makes this a safe option even for confidential datasets. There is no account, no upload limit and no cost.
For each column the tool examines every value and picks the most specific type that fits all of them, then maps it to the right name for your chosen database. If the detection is not quite what you want, the Columns editor lets you override any type manually.
Whole numbers like 28 or -1500 become INT or INTEGER, automatically promoted to BIGINT when values exceed the 32-bit range.
Numbers with a decimal point like 75000.50 become DECIMAL or NUMERIC, suitable for money and measurements where precision matters.
Columns containing only true/false, yes/no or 0/1 become the dialect boolean type, such as BOOLEAN, TINYINT(1) or BIT.
Values like 2024-01-15 become DATE, and values that also include a time become DATETIME, TIMESTAMP or the equivalent for your database.
Anything else becomes VARCHAR sized to fit the longest value, or TEXT when the content is too long for a bounded varchar.
Many online converters upload your file to a server to process it. This tool does not. All parsing and SQL generation runs locally in your browser using JavaScript, including reading Excel files. Your data never leaves your computer.
That matters because spreadsheets often hold sensitive information such as customer records, financial figures or internal business data. Because nothing is transmitted, you can convert confidential datasets without worrying about where they end up, and the tool keeps working even if your internet connection drops after the page has loaded.