Convert NUMBERS to DBF
Turn NUMBERS documents into DBF files. Each table becomes its own dBASE III table with formulas as their last computed values and the first row as field names, cut to 10 Latin letters, digits and underscores (FIELD1 and so on when none are left).
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 sheets as dBASE tables.Each table becomes its own DBF file with typed fields.
What you get
Each table in the NUMBERS file becomes its own dBASE III table, so a file with several tables gives you several DBF files. Formulas are written as the last values they computed.
The first row of each table becomes the field names. Numbers, dates and true/false values become typed fields.
How names and text are handled
Field names are cut to 10 characters and use only Latin letters, digits and underscores. When no usable characters are left, the field is named FIELD1 and so on.
Other cells are stored as text of up to 254 bytes. The text uses the Windows code page that fits it, or UTF-8 when none does.
What is not supported
Files from Numbers 2009 and earlier are not supported. Only files from later versions of Numbers can be converted.
To go the other way, use DBF to NUMBERS.
NUMBERS and DBF.What each format is.
The formats
Apple Numbers
Apple Numbers spreadsheets from macOS and iOS.
- Extensions
- .numbers
- MIME type
- application
/vnd .apple .numbers - Kind
- Documents
dBase Table
dBase tables, the attribute tables of shapefiles and many legacy databases.
- Extensions
- .dbf
- MIME type
- application
/x -dbf - Kind
- Documents
In your code.The same NUMBERS to DBF conversion through the API, for your app or your agent.
$ cv convert sheet.numbers sheet/ --to dbf$ cv convert sheet.numbers sheet/ --to dbfQuestions.What people ask about NUMBERS to DBF.
Yes. Each table becomes its own dBASE III table, so you can get one or more DBF files from one NUMBERS file.
They are written as their last computed values. The formula itself is not kept.
The first row becomes the field names, and DBF field names are cut to 10 Latin letters, digits and underscores. If none are left, the field is named FIELD1 and so on.
Not if it comes from Numbers 2009 or earlier. Those files are not supported.