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.
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.
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.
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.
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
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
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.
$ cv convert report.sql report.numbers$ cv convert report.sql report.numbersQuestions.What people ask about SQL to NUMBERS.
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.