Excel to SQL

Turn any spreadsheet into CREATE TABLE and INSERT statements, tested in a real database.

🔒 Runs in your browser⚡ Instant results👤 No sign-up⭐ Downloads with Pro

Turn a spreadsheet into SQL in seconds

Drop in an Excel or CSV file and get ready-to-run SQL: a CREATE TABLE With sensible column types and INSERT Statements for every row. Choose MySQL, SQL Server, PostgreSQL or SQLite, and the quoting, data types and date formats are handled for you.

Tested before you download

Every time the SQL changes, the tool runs it in a real SQLite database inside your browser and compares every value with your spreadsheet, so quotes in names like O'Brien, blank cells, dates and decimals are all checked.

Smart column types

Frequently asked questions

Is my data uploaded?

No. The file is read and converted in your browser, and the test database also runs on your device.

How big a file can I convert?

Tens of thousands of rows work well. Very large files create very large SQL files; for those, your database's own import tool may be faster.

Why does SQL Server use N'text'?

The N prefix keeps accents and symbols (like é or £) correct in NVARCHAR columns.

More data analysis & spreadsheet tools

📊
Excel Data AnalyserInstant KPI dashboard, insights, report & slides
📈
Instant DashboardPower BI style dashboard from any Excel file
🔁
CSV ↔ Excel ConverterConvert CSV, XLSX, XLS, ODS and JSON
🧩
Excel File MergerCombine many spreadsheets into one
🧹
Duplicate RemoverFind and delete duplicate rows
📈
Chart MakerPaste data, get a chart, download PNG or PowerPoint
🗄️
Excel to SQLCREATE TABLE & INSERT statements from any spreadsheet
🧮
SQL Query BuilderBuild SQL with clicks, explained in English, run on your data
✨
SQL FormatterMake messy SQL clean and readable
🧽
Data CleanerFix spaces, capitals, text numbers, dates, blanks and duplicates
🔗
VLOOKUP / Merge Two SheetsMatch two files on a shared column, no formulas
🆚
Compare Two Excel FilesSee added, removed and changed rows and cells
🧊
Pivot Table BuilderGroup, total and chart your data with clicks
🌐
Web Table to ExcelCopy tables from websites into clean Excel
🔣
JSON ↔ Excel ConverterFlatten JSON into a spreadsheet, or Excel into JSON
📍
UK Postcode Lookup (Bulk)Add council, region and lat/long to postcodes
🔄
Unpivot / Reshape DataColumns to rows and back, ready for Power BI
🎯
Outlier FinderSpot unusual values, typos and errors
📐
Statistics CalculatorMean, SD, correlation, t-test, chi-square explained
🎲
Random Sample PickerRandom rows for audits, surveys and prize draws
🧪
Test Data GeneratorRealistic fake UK data for testing and demos

See all 108 tools →