Convert SQL to NUMBERS

Turn SQL files into NUMBERS. 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

A spreadsheet for each table in your SQL script.Each table becomes a sheet in a Numbers file, with numbers and dates as typed cells.

  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. The output is one Numbers file.

    Each table becomes one sheet, named after the table. The sheets come in name order.

  2. How values are read

    Numbers, dates and times become typed cells. Codes with a leading zero stay text, so they keep their zero. A column that mixes numbers with text keeps both.

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

  3. What is left out

    Views, functions and triggers are left out with a warning. Only the tables and their rows reach the spreadsheet.

    Fonts that Numbers does not have become Helvetica Neue.

  4. Size limit

    A document of more than 300,000 cells fails with unsupported_elements. See every SQL conversion or every NUMBERS conversion for other routes.

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

Apple Numbers

Apple Numbers spreadsheets from macOS and iOS.

Extensions
.numbers
MIME type
application/vnd.apple.numbers
Kind
Documents

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

terminal
$ cv convert report.sql report.numbers
$ cv convert report.sql report.numbers

Questions.What people ask about SQL to NUMBERS.

01OF 04

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.

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

The document would hold more than 300,000 cells. Above that size the conversion stops with unsupported_elements.

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