Database administrator with a laptop in a server room aisle

Database administrator checking query results on two monitors

Excel to SQL with CREATE TABLE and typed INSERTs

Upload the Excel or XLS file, name the table, choose MySQL, PostgreSQL or SQLite, then convert and download the .sql file. It contains CREATE TABLE plus batched INSERT statements.

XLS Encrypted, deleted after conversion

XLS, XLSX, XLSM, XLSB, ODS, CSV, TSV, Numbers, JSON, XML

Google Sheets share link

Convert to

Encrypted, auto-deleted

Demo converts up to 100 rows, once.

Sheet

Delimiter

Encoding

JSON shape

Minify JSON

SQL dialect

Table name

Wrap in a transaction

Dates

Row element

Orientation

Workbook password (if protected)

Trim spaces in every cell Remove duplicate rows Drop empty columns Stack all sheets into one table

Moving spreadsheet data into a database usually means an import wizard that guesses types badly, or a script that someone has to write and maintain. An SQL dump is simpler: one file you can review, version and run with the database client you already use.

XlsConverter reads XLS, XLSX and other workbooks and writes SQL in the dialect you choose. For dialect specific details see Excel to MySQL, Excel to PostgreSQL and Excel to SQLite.

How to convert Excel to SQL in three steps

1Upload the XLS or XLSX workbook.
2Set the table name, SQL dialect and column types.
3Convert and download the .sql dump.

Inferring SQL column types from untyped spreadsheet cells

A spreadsheet column has no declared type, so the converter has to choose one. Looking at the first ten rows is how most tools fail: a column of integers turns out to contain 12.5 on row 3,000, or a ZIP code column is read as INTEGER and loses its leading zeros. We scan every value, choose the narrowest type that fits all of them, and keep identifier like columns as VARCHAR. You can still override any choice.

Empty cells become NULL, not empty strings, unless you ask otherwise, which matters for NOT NULL constraints and for COUNT queries later. Text values are escaped for the chosen dialect, so an apostrophe in a company name never breaks the dump. Dates are written in ISO format, which all three dialects accept.

Header text becomes column names after cleanup: spaces to underscores, reserved words like order or group quoted, duplicates numbered. Legacy XLS files with data split across sheets can be merged into one table. If you prefer to load data with a bulk loader rather than INSERT statements, export XLS to CSV instead, or start from text with CSV to SQL.

Options for Excel to SQL

SQL dialect: MySQL, PostgreSQL or SQLite, each with its own quoting, types and syntax.
Table name: Name the target table, with one table per sheet when several sheets are exported.
CREATE TABLE: Include a CREATE TABLE statement, add DROP TABLE IF EXISTS, or write INSERTs only.
Column types: Accept inferred types or set VARCHAR, INTEGER, DECIMAL, DATE or TEXT per column.
Batch size: Group rows into multi row INSERT statements for faster loading.

Run it automatically

If the same spreadsheet is loaded into a database every week, a pipeline can produce the SQL dump automatically when the file arrives and deliver it to SFTP, S3 or a webhook that runs your import. The SQL conversion API returns the dump directly to your deployment script, and the automation page explains sources and schedules.

Excel to SQL questions

How do I convert an Excel file to SQL?

Upload the workbook, choose the SQL dialect and table name, review the inferred column types, and download the .sql file with CREATE TABLE and INSERT statements.

Which databases does the SQL output support?

MySQL and MariaDB, PostgreSQL, and SQLite, each with dialect correct quoting and types.

How are empty Excel cells written in SQL?

As NULL by default. You can switch to empty strings for text columns if your schema requires it.

Can each Excel sheet become its own table?

Yes. Select several sheets and each one becomes a table named after the sheet.

Can I try Excel to SQL in a demo?

Yes, a one-time demo converts up to 100 rows, and you download the SQL after signup. Full tables need a paid plan from 24 USD per month billed yearly.

Related converters

Excel to MySQL Excel to PostgreSQL Excel to SQLite XLSX to SQL CSV to SQL

Convert full files and batches

Pro starts at $24 per month billed yearly. Cancel any time.

See plans