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