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.
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.
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.
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.
When it fails
If the file cannot be parsed, the conversion stops with
input_corrupted.
DBF and XLSX.What each format is.
The formats
dBase Table
dBase tables, the attribute tables of shapefiles and many legacy databases.
- Extensions
- .dbf
- MIME type
- application
/x -dbf - Kind
- Documents
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.
$ cv convert sheet.dbf sheet.xlsx$ cv convert sheet.dbf sheet.xlsxQuestions.What people ask about DBF to XLSX.
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.