Convert SXC to DBF

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

One dBASE table for each sheet.Every sheet in the SXC file becomes its own DBF table, hidden sheets included.

  1. What you get

    Each sheet is written as a dBASE III table, so a workbook with several sheets gives you several DBF files. Formulas are saved as their last results, not as formulas.

    The first row of each sheet becomes the field names. Numbers, dates and true/false values become typed fields.

  2. How names and text are handled

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

    Other cells are stored as text of up to 254 bytes. The text uses the Windows code page that fits, or UTF-8 if none does.

SXC and DBF.What each format is.

The formats

From · SXC

OpenOffice.org 1.0 Spreadsheet

Calc spreadsheets from OpenOffice.org 1.x and StarOffice 6 and 7, the XML format that OpenDocument grew out of.

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

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

Questions.What people ask about SXC to DBF.

01OF 04

Yes. Hidden sheets become their own tables like the others.

No. Each formula is stored as its last result.

It becomes the field names. They are cut to 10 Latin letters, digits and underscores.

No. Each sheet becomes its own DBF table, so you get one file per sheet.

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