Convert DBF to XLS

Turn DBF documents into XLS. One sheet with the field names as the header and numbers, dates and logical fields as typed cells, decoded with the code page the file names, or as Western European when it names none.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop DBF files on the dialor turn it to pick what to do

A DBF table as one Excel sheet.Field names become the header row. Numbers, dates and logical fields become typed cells.

  1. What you get

    An XLS workbook with one sheet. The first row holds the field names, and each record in the DBF table becomes a row below it.

    Numbers, dates and logical fields are written as typed cells, not as plain text.

  2. Text and code pages

    Text is decoded with the code page the DBF file names. When the file names none, it is read as Western European.

  3. What does not carry over

    Some FoxPro fields do not convert. Currency, date-time and memo fields come out as an unsupported-field note instead of their values. Double fields come out as 0.

    The Excel 97-2003 format has limits of 65,536 rows and 256 columns. Rows and columns past those limits are dropped without a warning, so a larger table arrives incomplete.

DBF and XLS.What each format is.

The formats

From · DBF

dBase Table

dBase tables, the attribute tables of shapefiles and many legacy databases.

Extensions
.dbf
MIME type
application/x-dbf
Kind
Documents
To · XLS

Excel 97-2003 Workbook

The binary Excel workbook format from Excel 97 through 2003, and its templates (.xlt). WPS Spreadsheets saves the same format as .et and .ett.

Extensions
.xls .xlt .et .ett
MIME type
application/vnd.ms-excel
Kind
Documents

In your code.The same DBF to XLS conversion through the API, for your app or your agent.

terminal
$ cv convert sheet.dbf sheet.xls
$ cv convert sheet.dbf sheet.xls

Questions.What people ask about DBF to XLS.

01OF 04

No. The whole table goes onto one sheet.

They come out as an unsupported-field note, not as the stored values. Date-time fields are treated the same way.

Rows past 65,536 are dropped without a warning. The Excel 97-2003 format cannot hold them.

Yes, with XLS to DBF. You can also see every DBF conversion.

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