Convert SQL to XLSM

Turn SQL files into XLSM 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 your script.Each table the script creates becomes its own XLSM file with one sheet.

  1. What you get

    The tables the script creates are loaded first. Each table is saved as its own workbook, named after the table, with one sheet. A script with several tables gives you several files.

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

    Each file is a macro-enabled workbook with no macros in it.

  2. Dumps from other databases

    A dump from MySQL, MariaDB or PostgreSQL is rewritten into SQLite's dialect before the tables are loaded. PostgreSQL true and false become 1 and 0.

    Dates that are not real dates, such as MySQL's 0000-00-00, are left empty.

  3. What is left out

    Views, functions and triggers are left out, and you get a warning when that happens. Only the tables and their data are converted.

    For other formats, see every SQL conversion or every XLSM conversion.

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

Excel Macro-Enabled Workbook

An Excel workbook with macros enabled.

Extensions
.xlsm
MIME type
application/vnd.ms-excel.sheet.macroEnabled.12
Kind
Documents

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

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

Questions.What people ask about SQL to XLSM.

01OF 04

One per table. Each workbook is named after its table and has one sheet.

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

No. It is saved as a macro-enabled workbook, but it has no macros in it.

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

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