Convert GNUMERIC to DBF

Turn GNUMERIC documents into DBF files. Each sheet, hidden ones included, becomes its own dBASE III table with formulas as the values Gnumeric computes 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 GNUMERIC files on the dialor turn it to pick what to do

One dBASE table for each sheet.Every sheet in the workbook, hidden ones too, becomes its own DBF file.

  1. What you get

    Each sheet becomes a separate dBASE III table, so a workbook with several sheets gives you several files. Formulas are written as the values Gnumeric computes, not as the formulas themselves.

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

  2. How names and text change

    Field names are cut to 10 characters and keep only Latin letters, digits and underscores. When no characters are left from a name, the field is called FIELD1, and so on.

    Cells that are not numbers, dates or true/false values are stored as text of up to 254 bytes. The text uses the Windows code page that fits it, or UTF-8 when none does.

GNUMERIC and DBF.What each format is.

The formats

From · GNUMERIC

Gnumeric Workbook

Workbooks saved by Gnumeric, the GNOME spreadsheet, as gzipped XML.

Extensions
.gnumeric
MIME type
application/x-gnumeric
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 GNUMERIC to DBF conversion through the API, for your app or your agent.

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

Questions.What people ask about GNUMERIC to DBF.

01OF 04

Yes. Each sheet becomes its own table, and hidden sheets are included.

They are replaced by the values Gnumeric computes. The formula itself is not kept.

It becomes the field names of the table. They are cut to 10 characters and keep only Latin letters, digits and underscores.

The name in the first row had no Latin letters, digits or underscores left after cutting. Such fields are named FIELD1 and so on.

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