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.

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

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

From · FODS

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
To · DBF

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.

terminal
$ cv convert report.fods report/ --to dbf
$ cv convert report.fods report/ --to dbf

Questions.What people ask about FODS to DBF.

01OF 04

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.

More conversions.Other ways in and out of FODS and DBF.