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.
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.
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.
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
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
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.
$ cv convert report.sql report/ --to xlsx$ cv convert report.sql report/ --to xlsxQuestions.What people ask about SQL to XLSX.
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.