EN

Excel to SQL converter

Turn a spreadsheet into ready to run SQL. Open an Excel or CSV file, or paste cells straight from Excel, pick your database and get CREATE TABLE and INSERT statements with sensible column types.

Your files never leave your device. Everything runs in your browser.

How it works

  1. Add your dataOpen an .xlsx or .csv file, or copy cells in Excel and paste them into the input box.
  2. Pick database and tableChoose SQL Server, MySQL, PostgreSQL or SQLite and type the table name.
  3. Copy or downloadCheck the column types, then copy the SQL or download it as a .sql file.

From spreadsheet to table in seconds

Importing price lists, product catalogs or customer exports into a database usually means writing long INSERT statements by hand or fighting with import wizards. This tool reads the data, works out a fitting type for every column and writes the SQL for you.

Numbers become INT, BIGINT or DECIMAL with the right precision, true and false become BIT or BOOLEAN, dates become DATE or DATETIME and text gets a length that fits the longest value.

Safe values for every database

Quotes inside text are escaped, accented and other special characters are kept, and SQL Server strings get the N prefix so Unicode is stored correctly. Codes with leading zeros, such as barcodes and postal codes, stay text so no digits are lost.

Large tables are split into batches, because SQL Server accepts at most 1000 rows in a single VALUES list.

Frequently asked questions

Is my data uploaded anywhere?

No. Everything runs in your browser. Your spreadsheet is not sent to our servers.

Can I paste data directly from Excel?

Yes. Select the cells in Excel, copy them and paste into the input box. The tool recognizes the tab separated format automatically.

Which Excel files are supported?

Modern .xlsx files from Excel, Google Sheets and LibreOffice. Old .xls files need to be saved as .xlsx first. Files with several sheets let you choose the sheet.

Why are my column names changed?

With Simplify names on, spaces and special characters are replaced, for example Product Name becomes product_name. Turn it off to keep the original names in quotes.

Does it work without an internet connection?

Yes. After you open the page once, it keeps working even if your connection drops.