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.
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.
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.
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
dBase Table
dBase tables, the attribute tables of shapefiles and many legacy databases.
- Extensions
- .dbf
- MIME type
- application
/x -dbf - Kind
- Documents
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.
$ cv convert sheet.dbf sheet.xls$ cv convert sheet.dbf sheet.xlsQuestions.What people ask about DBF to XLS.
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.