Convert DBF to ODS

Turn DBF documents into ODS. One sheet with the field names as the header and numbers, dates and logical fields as typed cells, decoded with the code page the file names, or as Western European when it names none.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop DBF files on the dialor turn it to pick what to do

A spreadsheet from your dBase table.One sheet, with field names as the header and typed cells below.

  1. What you get

    One ODS file with a single sheet. The field names become the header row, and each record becomes a row under it.

    Numbers, dates and logical fields come out as typed cells, not as plain text. Text is decoded with the code page the DBF file names. If the file names none, it is read as Western European.

  2. What does not carry over

    Some FoxPro fields have no equivalent in the output. Currency, date-time and memo fields come out as an unsupported-field note instead of their values.

    Double fields come out as 0, not as the stored number. Check any sheet made from a table with double fields before you rely on it.

  3. When it fails

    A file that cannot be parsed stops the conversion with input_corrupted. The DBF file is damaged or is not a readable dBase table.

    To go the other way, use ODS to DBF.

DBF and ODS.What each format is.

The formats

From · DBF

dBase Table

dBase tables, the attribute tables of shapefiles and many legacy databases.

Extensions
.dbf
MIME type
application/x-dbf
Kind
Documents
To · ODS

OpenDocument Spreadsheet

OpenDocument spreadsheet, the native format of LibreOffice Calc.

Extensions
.ods
MIME type
application/vnd.oasis.opendocument.spreadsheet
Kind
Documents

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

terminal
$ cv convert sheet.dbf sheet.ods
$ cv convert sheet.dbf sheet.ods

Questions.What people ask about DBF to ODS.

01OF 04

Yes. The field names become the header row of the single sheet.

Yes. Numbers, dates and logical fields become typed cells, not text.

It uses the code page named in the DBF file. If the file names none, it reads the text as Western European.

They come out as an unsupported-field note, not as values. Date-time fields are handled the same way, and double fields come out as 0.

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