Convert DBF to XLSX

Turn DBF documents into XLSX. 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 an Excel sheet.One sheet, with field names as the header and typed cells below.

  1. What you get

    An XLSX workbook with one sheet. The field names of the DBF table form the header row, and each record follows as a row.

    Numbers, dates and logical fields come out as typed cells, so Excel treats them as numbers, dates and true or false values, not as plain text.

  2. How text is read

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

  3. What it does not carry over

    Some FoxPro fields have no counterpart in the output. Currency, date-time and memo fields come out as an unsupported-field note instead of their values. Double fields come out as 0.

    Check tables that use these field types before you rely on the result.

  4. When it fails

    If the file cannot be parsed, the conversion stops with input_corrupted.

DBF and XLSX.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 · XLSX

Excel Workbook

Excel's workbook format since 2007. Sheets, formulas, formats and charts in zipped XML.

Extensions
.xlsx
MIME type
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Kind
Documents

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

terminal
$ cv convert sheet.dbf sheet.xlsx
$ cv convert sheet.dbf sheet.xlsx

Questions.What people ask about DBF to XLSX.

01OF 04

Yes. The field names from the DBF table are the header of the sheet.

Yes. Numbers, dates and logical fields are typed cells, not text.

They come out as an unsupported-field note, not as values. Date-time fields do the same, and double fields come out as 0.

The code page named in the DBF file. If the file names none, the text is read as Western European.

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