Convert SQLITE to NUMBERS

Turn SQLITE files into NUMBERS. One sheet per table, named after it, in name order; views are skipped.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop SQLITE files on the dialor turn it to pick what to do

Your database as Numbers sheets.Each table becomes its own sheet in one Numbers file.

  1. What you get

    One NUMBERS file with one sheet per table. Each sheet is named after its table, and the sheets are in name order. Views are skipped.

    Numbers, dates and times become typed cells, so they behave as values in Numbers. Codes with a leading zero stay text, so the zero is not lost. A column that mixes numbers with text keeps both.

  2. What changes

    Numbers keeps 15 significant digits, so a number with more digits than that is not kept in full. Fonts that Numbers does not have become Helvetica Neue.

  3. Size limit

    A document of more than 300,000 cells fails with unsupported_elements. The limit counts cells across the whole document, not per sheet.

SQLITE and NUMBERS.What each format is.

The formats

From · SQLITE

SQLite Database

A whole relational database in one file. Tables, indexes and views.

Extensions
.sqlite .sqlite3 .db
MIME type
application/vnd.sqlite3
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 SQLITE to NUMBERS conversion through the API, for your app or your agent.

terminal
$ cv convert report.sqlite report.numbers
$ cv convert report.sqlite report.numbers

Questions.What people ask about SQLITE to NUMBERS.

01OF 04

Yes. Each table becomes one sheet named after the table, and the sheets are in name order.

No. Views are skipped, and only tables become sheets.

No. Codes with a leading zero stay text, so the zero stays.

The document has more than 300,000 cells. Conversions above that size fail with this code.

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