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.

  1. 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.

  2. Formulas

    Formulas give their last computed values. The database holds those values, not the formulas.

  3. 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.

  4. Older files

    Files from Numbers 2009 and earlier are not supported.

NUMBERS and SQLITE.What each format is, and the options this conversion takes.

  1. 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

From · NUMBERS

Apple Numbers

Apple Numbers spreadsheets from macOS and iOS.

Extensions
.numbers
MIME type
application/vnd.apple.numbers
Kind
Documents
To · 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

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

terminal
$ cv convert sheet.numbers sheet.sqlite
$ cv convert sheet.numbers sheet.sqlite

Questions.What people ask about NUMBERS to SQLITE.

01OF 04

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.

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