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.

  1. 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.

  2. 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.

  3. 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

From · XLSX

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
To · SQL

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.

terminal
$ cv convert sheet.xlsx sheet.sql
$ cv convert sheet.xlsx sheet.sql

Questions.What people ask about XLSX to SQL.

01OF 04

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.

More conversions.Other ways in and out of XLSX and SQL.