Convert OTS to DBF

Turn OTS 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 OTS files on the dialor turn it to pick what to do

One dBASE table for each sheet.Every sheet in the template becomes its own DBF file, with the first row as field names.

  1. What you get

    Each sheet, hidden ones included, becomes its own dBASE III table. A template with three sheets gives three DBF files.

    Formulas are written as their last results. Numbers, dates and true/false values become typed fields. Other cells become text.

  2. Field names and text

    The first row of each sheet becomes the field names. Each name is cut to 10 Latin letters, digits and underscores. When no such characters are left, the field is named FIELD1 and so on.

    Text fields hold up to 254 bytes. The text is written in the Windows code page that fits it, or in UTF-8 when none does.

OTS and DBF.What each format is.

The formats

From · OTS

OpenDocument Spreadsheet Template

A LibreOffice Calc template. New spreadsheets start from a copy of it.

Extensions
.ots
MIME type
application/vnd.oasis.opendocument.spreadsheet-template
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 OTS to DBF conversion through the API, for your app or your agent.

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

Questions.What people ask about OTS to DBF.

01OF 04

Yes. Hidden sheets become their own tables, the same as visible ones.

One or more. Each sheet gives one DBF file.

They are written as their last results, so the table holds values, not formulas.

Field names are cut to 10 Latin letters, digits and underscores. If none are left, the field is named FIELD1 and so on. See every DBF conversion for other ways to reach this format.

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