Convert NUMBERS to SQLITE
Turn NUMBERS documents into SQLITE. A SQLite database with one table per Numbers table, named after its sheet, with the table name added when a sheet holds several.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop NUMBERS files on the dialor turn it to pick what to do
Numbers tables as a SQLite database.Each table in your spreadsheet becomes a table in one database file.
What you get
One SQLite file with a table for each Numbers table. Each table is named after its sheet. When a sheet holds several tables, the table name is added to the sheet name.
Column names come from the first row of each table. Column types come from the values in the columns.
Formulas
Formulas give their last computed values. The database holds those values, not the formulas.
Choosing a sheet
Every sheet is converted unless you say otherwise. Set Sheet to a name or to a number counting from 1, and only that sheet is converted.
Older files
Files from Numbers 2009 and earlier are not supported.
NUMBERS and SQLITE.What each format is, and the options this conversion takes.
- 01 · sheet
Sheet
The one worksheet to convert, by its name or by its number counting from 1. Every worksheet is converted when it is left out.
The formats
Apple Numbers
Apple Numbers spreadsheets from macOS and iOS.
- Extensions
- .numbers
- MIME type
- application
/vnd .apple .numbers - Kind
- Documents
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
In your code.The same NUMBERS to SQLITE conversion through the API, for your app or your agent.
$ cv convert sheet.numbers sheet.sqlite$ cv convert sheet.numbers sheet.sqliteQuestions.What people ask about NUMBERS to SQLITE.
Each table is named after its sheet. If a sheet holds several tables, the table name is added too.
From the first row of each table. The types come from the values below it.
Yes. Set Sheet to the sheet's name or its number, counting from 1.
No. Each formula gives its last computed value.