Convert Excel to SQL Online - Free INSERT/UPDATE/DELETE Generator

Q: How do I convert Excel to SQL online?

Open this page → upload Excel or CSV → pick INSERT/UPDATE/DELETE/SELECT and database type → map columns in the matrix → click Generate SQL → copy or download .sql. No signup, completely free.

Q: Which file formats are supported?

.xlsx, .xlsm, .xltx, .xltm, and .csv supported. CSV: UTF-8, comma-separated; row 1 = headers. Legacy .xls not supported.

Q: Which databases are supported?

SQL Server, MySQL, PostgreSQL, SQLite, and Oracle dialects; optional CREATE TABLE, batch insert, quoted identifiers.

Q: How are empty cells and NULL handled?

Blank cells and NULL text (case-insensitive) become SQL NULL, not the string 'NULL'.

Q: Is my file uploaded?

Files are uploaded for temporary processing only and deleted immediately after SQL generation—we never store or backup your spreadsheet.

194 uses

Convert Excel to SQL Online — Free Script Generator

Convert Excel to SQL free online—turn spreadsheet or CSV rows into INSERT, UPDATE, DELETE, and SELECT scripts. Configure sheet, statement type, table name, database dialect, and options in the top bar; map columns in the matrix and generate executable SQL. Supports SQL Server, MySQL, PostgreSQL, SQLite, and Oracle, plus batch insert, CREATE TABLE, and temp-table scripts for names starting with #. Files are deleted from the server after processing.

Interface preview

The UI has a top config bar, column mapping matrix, and SQL output area.

Mapping matrix Script column, include, generate data, WHERE, and sample row.

Statement type Choose INSERT, UPDATE, DELETE, or SELECT in the top bar.

Database & options Pick database type and toggle CREATE TABLE, batch insert, quoted identifiers.

Key capabilities

Four SQL types, five databases
INSERT, UPDATE, DELETE, SELECT plus SQL Server, MySQL, PostgreSQL, SQLite, and Oracle dialects.
Visual mapping matrix
Transpose matrix for script column, include, generate data, WHERE, and sample preview; drag headers to reorder or delete columns and resize widths.
Generate data & NULL handling
Per-column GUID, Today, fixed 1 or 0; empty cells and NULL text output SQL NULL.
CREATE TABLE, batch insert, export
Optional CREATE TABLE, batch INSERT, quoted identifiers; copy or download .sql output.
Temp table scripts
Table names starting with # (e.g. #temp) prepend CREATE TABLE and append SELECT plus DROP.

Use cases

Test environment seed data
Excel legacy data migration
CSV export to INSERT scripts
Batch UPDATE / DELETE scripts

How to convert Excel to SQL

Upload .xlsx or .csv; headers and a sample row are parsed automatically.
In the top bar choose sheet, statement type, table name, database type, and optional toggles.
In the matrix set target names, include columns, generate data (GUID / Today / 1 / 0), and WHERE flags.
Click Generate SQL; drag column headers to reorder or remove columns as needed.
Copy or download the .sql file; prefer download for large outputs.
Run the script in your database client.

Four statement types

INSERT

Check columns to insert; one INSERT per row, or batch INSERT when enabled.

UPDATE

Pick SET and WHERE columns separately; the same column cannot be both.

DELETE

Check WHERE columns; one DELETE per row.

SELECT

Check SELECT columns and one WHERE IN column to build SELECT ... WHERE col IN (...).

Convert Excel to SQL FAQ

QHow do I convert Excel to SQL online?

Upload .xlsx or .csv → pick INSERT/UPDATE/DELETE/SELECT and database type → map columns in the matrix → click Generate SQL → copy or download .sql. No signup required.

QWhich file formats are supported?

.xlsx, .xlsm, .xltx, .xltm, and .csv. CSV uses comma separation; row 1 is headers. Duplicate headers get _2, _3 suffixes.

QCan I pick a worksheet?

Yes. Use the Sheet dropdown in the top bar after upload.

QHow do INSERT, UPDATE, DELETE, SELECT work?

INSERT: check Include columns. UPDATE: separate SET and WHERE (mutually exclusive). DELETE: WHERE columns. SELECT: output columns plus one WHERE IN column.

QHow does the mapping matrix work?

Edit script column targets, toggle Include, set Generate data (GUID / Today / 1 / 0). Drag headers horizontally to reorder, downward to delete; resize on the right edge.

QWhat do the top-bar database options do?

Choose dialect and toggles for CREATE TABLE, batch insert, quoted identifiers. Blank cells and NULL text become SQL NULL. Names starting with # generate temp-table scripts.

View more FAQ →