Export DBF to Excel

With DBF Viewer 2000 you can export dbf to Excel (XLS, XLSX) from GUI or from the command line. To export a dbf file to XLS (Excel) format, open File | Save as/Export menu, and select file type: XLS or XLSX (Excel 2003-2022).

"Export DBF to XLS" dialog box opens. Select the fields to be exported and specify their order using up and down arrows.

DBF to Excel screenshot

DBF Viewer 2000 allows you export memo fields (from .fpt/.dbt files) to XLS/XLSX format.

To export large memo fields, set on option "XML-based"

DOWNLOAD
for FREE

DBF to Excel Command Line

"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" file.dbf /EXPORT:file.xls | file.xlsx [/XML] [/FILTER | /REVERSE| /COLUMNS | /FROMRECORD | /SORTBY [/DESC] | /SHEETASFILENAME | /NOHDR]

Examples:

Simple export DBF to XLS

c:\Program Files (x86)\DBF Viewer 2000\dbview.exe sample.dbf  /EXPORT:sample.xls

Export DBF to XLSX format

"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:mytable.xlsx

Export with Columns Selection

"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" sample.dbf /EXPORT:mytable.xls /COLUMNS:ZIP,NAME

Export DBF to XLS in reverse order

c:\Program Files (x86)\DBF Viewer 2000\dbview.exe sample.dbf  /EXPORT:sample.xls /REVERSE

Export DBF to XLSX from record #100

c:\Program Files (x86)\DBF Viewer 2000\dbview.exe sample.dbf  /EXPORT:sample.xlsx /FROMRECORD:1000

Export dbf to xls as xml based

c:\Program Files (x86)\DBF Viewer 2000\dbview.exe sample.dbf /EXPORT:sample.xls /XML

Export with sorting

c:\Program Files (x86)\DBF Viewer 2000\dbview.exe sample.dbf /EXPORT:sample.xls /SORTBY:DATE

Export with Filter command by Name

c:\Program Files (x86)\DBF Viewer 2000\dbview.exe sample.dbf /EXPORT:table.xls /FILTER2:Name:Jim

Export DBF to XLS with Wide filter

c:\Program Files (x86)\DBF Viewer 2000\dbview.exe sample.dbf /EXPORT:table.xls /wfilter:Robin

Export without header

c:\Program Files (x86)\DBF Viewer 2000\dbview.exe sample.dbf /EXPORT:table.xls /NOHDR

Set Sheet Name as File name

c:\Program Files (x86)\DBF Viewer 2000\dbview.exe sample.dbf /EXPORT:mytable.xlsx /sheetasfilename

Do you need more options for Excel format ?

Please, contact us by E-mail: support@dbf2002.com or by On-line form.

DOWNLOAD NOW

See also: DBF to CSV, DBF to XML, Excel to DBF importing, DBF to SQL, command line options, Filtering records in dbf file