Convert STC to DBF

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

Each sheet becomes a dBASE table.Hidden sheets are included, and formulas arrive as their last results.

  1. What you get

    One dBASE III table for each sheet in the template, hidden sheets included. A workbook with several sheets gives you several DBF files.

    The first row of each sheet becomes the field names. Formulas are written as the last result they showed, not as the formula.

  2. How fields are typed

    Numbers, dates and true/false values become typed fields. Every other cell becomes a text field of up to 254 bytes. The text is written in the Windows code page that fits it, or in UTF-8 when none does.

  3. How names are cut

    Field names are cut to 10 characters, using Latin letters, digits and underscores. When no usable characters are left, the field is named FIELD1 and so on.

    Because of the cut, long headings in the first row will not appear in full. Check the field names if you need to match them against another table. For other routes from this format, see every STC conversion, or see every DBF conversion.

STC and DBF.What each format is.

The formats

From · STC

OpenOffice.org 1.0 Spreadsheet Template

A Calc template from OpenOffice.org 1.x and StarOffice 6 and 7.

Extensions
.stc
MIME type
application/vnd.sun.xml.calc.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 STC to DBF conversion through the API, for your app or your agent.

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

Questions.What people ask about STC to DBF.

01OF 04

Yes. Each sheet, hidden ones included, becomes its own dBASE III table.

No. Each formula is written as its last result, so the DBF holds values only.

It becomes the field names. They are cut to 10 Latin letters, digits and underscores, and FIELD1 and so on are used when none are left.

Text is stored in fields of up to 254 bytes. It uses the Windows code page that fits, or UTF-8 when none does.

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