Convert SQL to XLSX

Turn SQL files into XLSX files. The tables the script creates are loaded first, with a dump from MySQL, MariaDB or PostgreSQL rewritten into SQLite's dialect.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop SQL files on the dialor turn it to pick what to do

One workbook for each table in the script.Each table becomes its own XLSX file with one sheet, named after the table.

  1. What you get

    The tables the script creates are loaded first. A dump from MySQL, MariaDB or PostgreSQL is rewritten into SQLite's dialect before it is loaded.

    The result is one or more files. Each table gets one workbook, named after it, with a single sheet.

  2. How values are stored

    Numbers, dates and times become typed cells, so Excel treats them as numbers and dates, not as text. Codes with a leading zero stay text, so the zeros are kept.

    Dates that are not real dates, such as MySQL's 0000-00-00, are left empty. PostgreSQL true and false become 1 and 0.

  3. What is left out

    Views, functions and triggers are left out, and a warning tells you so. Only the tables and their rows are written to the workbooks.

    To go the other way, use XLSX to SQL.

SQL and XLSX.What each format is.

The formats

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

In your code.The same SQL to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.sql report/ --to xlsx
$ cv convert report.sql report/ --to xlsx

Questions.What people ask about SQL to XLSX.

01OF 04

One workbook per table, each named after its table. A script that creates several tables gives you several files.

Yes. A dump from MySQL, MariaDB or PostgreSQL is rewritten into SQLite's dialect before the tables are loaded.

No. Codes with a leading zero stay text, so the zeros are kept.

They are left out with a warning. Functions are left out the same way.

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