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.
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.
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
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
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.
$ cv convert report.ots report/ --to dbf$ cv convert report.ots report/ --to dbfQuestions.What people ask about OTS to DBF.
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.