Convert SQL to ODS

Turn SQL files into ODS 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 spreadsheet per table in your SQL script.Each table becomes its own ODS 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 loading.

    Each table comes out as one spreadsheet, 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 zero.

  2. What changes

    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 with a warning. Only the tables and their rows reach the spreadsheets.

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

OpenDocument Spreadsheet

OpenDocument spreadsheet, the native format of LibreOffice Calc.

Extensions
.ods
MIME type
application/vnd.oasis.opendocument.spreadsheet
Kind
Documents

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

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

Questions.What people ask about SQL to ODS.

01OF 04

Not always. Each table in the script becomes its own ODS file, so a script with several tables gives several files.

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

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

No. Views, functions and triggers are left out with a warning.

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