Convert FODS to DBF
Turn FODS documents into DBF files. Each sheet, hidden ones included, becomes its own dBASE III table with formulas as their last results 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 FODS files on the dialor turn it to pick what to do
One table per sheet, ready for dBASE tools.Each sheet becomes its own DBF file, with the first row as field names.
What you get
Every sheet in the FODS file, hidden ones included, becomes its own dBASE III table. A workbook with several sheets gives you several DBF files.
Formulas are written as their last results. The first row of each sheet becomes the field names.
How fields are made
Field names are cut to 10 Latin letters, digits and underscores. If no such characters are left in a name, it becomes FIELD1 and so on.
Numbers, dates and true/false values become typed fields. Other cells become text fields of up to 254 bytes. The text is written in the Windows code page that fits, or in UTF-8 when none does.
FODS and DBF.What each format is.
The formats
Flat OpenDocument Spreadsheet
An OpenDocument spreadsheet saved as one plain XML file instead of a zip.
- Extensions
- .fods
- MIME type
- application
/vnd .oasis .opendocument .spreadsheet -flat -xml - 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 FODS to DBF conversion through the API, for your app or your agent.
$ cv convert report.fods report/ --to dbf$ cv convert report.fods report/ --to dbfQuestions.What people ask about FODS to DBF.
Yes. Each sheet becomes its own dBASE III table, and hidden sheets are included.
The first row is used as the field names. They are cut to 10 Latin letters, digits and underscores, and a name with none of those becomes FIELD1 and so on.
Formulas are written as their last results, not as formulas.
Yes. Numbers, dates and true/false values become typed fields. Other cells become text.