Convert DBF to Excel
DBF Converter allows you convert a single DBF file or folder with multiple files to Excel format (XLS, XLSX) from GUI or command line.
1. Select the DBF file or Folder for batch conversion.
2. Select the output Excel file or Folder
3. Preview, select options for sorting, filtering data (if necessary)
You can also select/unselect columns, set order for columns, and click "Finish".
DBF to XLS Command Line
"c:\Program Files (x86)\DBF Converter\dbfcnv.exe" file.dbf file.xls [/HDR | /FILTER | /COLUMNS | /COLUMNSLIST | /REVERSE | /SORTBY | /ADDTOEXIST ]
Simple DBF to XLS conversion
"c:\Program Files (x86)\DBF Converter\dbfcnv.exe" sample.dbf sample.xls /COLUMNS:NAME,STREET
Conversion with Selected Columns
"c:\Program Files (x86)\DBF Converter\dbfcnv.exe" sample.dbf sample.xls /COLUMNS:NAME,STREET
Convert folder with DBF files to XLS format
"c:\Program Files (x86)\DBF Converter\dbfcnv.exe" d:\base\*.dbf d:\out\ /TOXLS
Add sheet to existing XLSX file
"c:\Program Files (x86)\DBF Converter\dbfcnv.exe" sample.dbf mytable.xlsx /addtoexist
Convert to XLS with sorting
"c:\Program Files (x86)\DBF Converter\dbfcnv.exe" sample.dbf mytable.xls /SORTBY:Name [/ignorecase]
Convert multiple DBF files to one Excel file
"c:\Program Files (x86)\DBF Converter\dbfcnv.exe" c:\base\*.dbf table.xlsx
Conversion without Field Names
"c:\Program Files (x86)\DBF Converter\dbfcnv.exe" sample.dbf mytable.xls /NOHDR
Set custom Sheet Name
"c:\Program Files (x86)\DBF Converter\dbfcnv.exe" sample.dbf mytable.xls /SHEETNAME:My Work