Convert XLSX to SQL
Turn XLSX workbooks into SQL. SQL in SQLite's dialect that creates one table per worksheet, named after it, hidden ones included, and inserts its rows, as SQLite's .dump writes it inside one transaction, so MySQL and PostgreSQL do not run it as it is; chart sheets and empty sheets are skipped.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop XLSX files on the dialor turn it to pick what to do
A SQL script of your workbook.Each worksheet becomes a table, and its rows become inserts.
What you get
One SQL file in SQLite's dialect. It creates one table per worksheet, named after the sheet, and inserts the rows. Hidden sheets are included.
The script is laid out as SQLite's .dump writes it, inside one transaction. Each table takes its column names from the first row and its column types from the values below it.
What changes
Formulas are not kept. Each cell gives the last value the formula computed.
Decimals keep every digit SQLite stores, so 41.7 comes out as 41.700000000000002842.
Chart sheets and empty sheets are skipped, so they produce no table.
Running it elsewhere
The script is written for SQLite. MySQL and PostgreSQL do not run it as it is.
To go the other way, use SQL to XLSX. For other conversions from this format, see every XLSX conversion.
XLSX and SQL.What each format is.
The formats
Excel Workbook
Excel's workbook format since 2007. Sheets, formulas, formats and charts in zipped XML.
- Extensions
- .xlsx
- MIME type
- application
/vnd .openxmlformats -officedocument .spreadsheetml .sheet - Kind
- Documents
SQL Script
SQL statements as text. A database dump that any SQL tool can read or replay.
- Extensions
- .sql
- MIME type
- application
/sql - Kind
- Text and data
In your code.The same XLSX to SQL conversion through the API, for your app or your agent.
$ cv convert sheet.xlsx sheet.sql$ cv convert sheet.xlsx sheet.sqlQuestions.What people ask about XLSX to SQL.
Every worksheet does, hidden ones included, and each table is named after its sheet. Chart sheets and empty sheets are skipped.
From the first row of each sheet. The column types come from the values in the cells.
No. Each cell holds the last value the formula computed.
Not as it is. It is written in SQLite's dialect, as SQLite's .dump writes it.