Developer Tool

Excel to SQL Insert Generator

Upload Excel or CSV data, review inferred columns, and generate SQL Server `CREATE TABLE` plus batched `INSERT` statements instantly. Useful for seeding lookup tables, migrations, demos, and quick one-off imports.

Spreadsheet Upload

Read `.xlsx`, `.xls`, and `.csv` files directly in the browser.

CREATE + INSERT

Generate table DDL and ready-to-run SQL Server insert statements together.

Smart Type Detection

Auto-detect numbers, dates, nullability, and suggested SQL data types.

Private by Default

Your file stays in the browser. Nothing is uploaded to the server.

How to use

  1. 1Upload your spreadsheet or CSV file and confirm the correct sheet plus header row.
  2. 2Adjust table name, column data types, nullable flags, and optional primary keys.
  3. 3Choose whether you want `CREATE TABLE`, `INSERT`, batching, transactions, and `GO` separators.
  4. 4Generate SQL, copy it, or download it as a `.sql` file for immediate use.

What it handles

  • +Auto-detects `INT`, `BIGINT`, `DECIMAL`, `DATE`, `DATETIME`, and `NVARCHAR` suggestions.
  • +Escapes text values safely for SQL Server, including single quotes and optional Unicode `N` prefix.
  • +Supports multi-row batched inserts for better performance on larger data sets.
  • +Lets you exclude columns, mark primary keys, and tweak nullable rules before export.
  • +Processes data entirely client-side, so spreadsheets do not leave the browser.