Input
List B
Result
Ad space: paste your AdSense code here
How to use it
- Copy rows from Excel, including the header row, and paste them in.
- Enter your table name and tick the header option.
- Copy the INSERT statements and run them in your SQL client.
Frequently asked questions
How are text and numbers handled?
Numbers stay unquoted, text is wrapped in single quotes with embedded quotes escaped, and empty cells become NULL. Values with leading zeros, such as 0123, stay as text.
Does it work with any database?
It creates standard INSERT INTO ... VALUES statements that work in most databases. Check date formats for your database.
More SQL tools
📋 List to IN clausePaste a column from Excel and get a quoted, comma-separated list for WHERE ... IN (...).🔄 Rows ↔ columnsSwap pasted data so vertical becomes horizontal, and the other way round.✂️ Split to rowsTurn one line like a,b,c into one value per row.⚖️ Compare two listsFind what is in one list but not the other, what both share, or all unique values.🧹 Clean & sort linesTrim spaces, remove duplicates, sort, change case, and add text to every line.✨ SQL formatterPut each major clause on its own line and uppercase keywords.