Convert SQL to XLTX

Turn SQL files into XLTX 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 Excel template for each table.The tables in your SQL script come out as XLTX workbooks, one per table.

  1. What you get

    The tables the script creates are loaded first. Each table becomes its own workbook, named after the table, with one sheet.

    Numbers, dates and times become typed cells. Codes with a leading zero stay text, so they keep their zeros.

    Each workbook is saved as a template, so Excel opens a new copy of it.

  2. What changes

    A dump from MySQL, MariaDB or PostgreSQL is rewritten into SQLite's dialect before it is loaded.

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

    Views, functions and triggers are left out, and you get a warning about them.

SQL and XLTX.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 · XLTX

Excel Template

An Excel template.

Extensions
.xltx
MIME type
application/vnd.openxmlformats-officedocument.spreadsheetml.template
Kind
Documents

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

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

Questions.What people ask about SQL to XLTX.

01OF 04

Yes. You get one workbook per table, named after it, and each has one sheet.

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. Numbers, dates and times become typed cells.

They are left out, and you get a warning. Functions are left out in the same way.

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