Excel to SQL FAQ

Common questions about converting Excel or CSV to SQL Server scripts — formats, mapping, statement types, and execution.

QWhich Excel and CSV formats are supported?

.xlsx, .xlsm, .xltx, .xltm, and .csv. CSV is comma-delimited; row 1 is headers. Legacy .xls is not supported — save as .xlsx first.

QCan I choose a specific worksheet?

Yes. Switch sheets in the dropdown after upload; the tool reads that sheet's first row as column names.

QHow do INSERT, UPDATE, and DELETE work?

INSERT: check columns, one INSERT per row. UPDATE: separate SET and WHERE columns. DELETE: check WHERE columns. A column cannot be both SET and WHERE in UPDATE.

QHow are table names and values generated?

Table names support dbo.TableName. # temp tables get CREATE TABLE and DROP. Column names strip spaces; strings/dates quoted, numbers as-is.

QDoes output work with MySQL or PostgreSQL?

Output targets Microsoft SQL Server syntax (dbo schema, DROP TABLE IF EXISTS). Adjust manually for other databases.

QWhat about empty Excel cells?

Empty cells become NULL (unquoted). Fill required fields in Excel or set DB defaults if the column is NOT NULL.

QIs my data stored on the server?

Files are uploaded for parsing but deleted immediately after processing — no spreadsheet content is retained.

QHow many rows can I process at once?

Tens of thousands in theory; beyond ~5000 rows, download the .sql file. Split very large files into batches.