Turn a spreadsheet into SQL in seconds
Drop in an Excel or CSV file and get ready-to-run SQL: a CREATE TABLE With sensible column types and INSERT Statements for every row. Choose MySQL, SQL Server, PostgreSQL or SQLite, and the quoting, data types and date formats are handled for you.
Tested before you download
Every time the SQL changes, the tool runs it in a real SQLite database inside your browser and compares every value with your spreadsheet, so quotes in names like O'Brien, blank cells, dates and decimals are all checked.
Smart column types
- Whole numbers become
INTOrBIGINT; decimals becomeDECIMAL(p,s)Sized to fit. - Dates become
DATEOrDATETIME, written asYYYY-MM-DD. - Text becomes
VARCHAR/NVARCHARSized to your longest value. - Codes with leading zeros (like 00123) stay as text.