Someone sends you a legacy .dbf file, and Excel mangles the accented characters. You need to filter a few thousand records, fix a field type and get the data into SQL Server by the end of the day. DBF Commander Professional is a Windows viewer and editor for dBase and FoxPro tables. It is built for exactly this kind of job.
Quick facts
- Version: 6.0 Build 120
- Platform: Windows (the latest build was adapted for Windows 11)
- License: Shareware, with a 30-day trial. A separate free edition limits most operations.
- Pricing: Subscription licenses for a single user. The vendor lists $19 for 1 month, $49 for 6 months and $79 for 12 months. Company and site licenses are also sold.
- Interface: Multiple document interface, with each file on its own tab
Key features
Run SQL queries directly against DBF files
You can run SQL queries on your tables without moving the data anywhere first. There is a dedicated SQL panel with multiple tabs. It supports SELECT, CREATE TABLE, ALTER TABLE, UPDATE, INSERT and DELETE, and it handles nested queries.
Fix encoding problems for good
Convert a file between ANSI, UTF-8 and MS-DOS encodings. You can also set or remove the code page flag. All DBF code pages are supported, which is what you need when text arrives garbled.
Move data in and out of other systems
Export to CSV, XLS, XLSX, XML and HTML, and import from XML and CSV. You can also transfer data to and from databases such as MS SQL, PostgreSQL, Oracle, MySQL, Firebird and InterBase. The program can create the destination table for you during export. You can also script a DBF as CREATE TABLE and INSERT INTO statements.
Edit records and structure with proper tools
Create, edit and print DBF files, and change their structure. Delete or recall records, pack a table, duplicate records, and use find and replace with case-sensitive and partial-match options. Sort by multiple fields and filter with complex conditions. There is also a Delete Duplicates tool.
Analyze and chart your data
Field statistics give you SUM, MIN, MAX, AVERAGE and DISTINCT on any fields. A chart wizard builds graphs, bar, pie, area and point charts. A Database Scheme feature has also been added.
Protect files and automate repeat jobs
Encrypt and decrypt DBF files with AES-256. View and edit MEMO and BLOB fields. The command line supports batch jobs, a silent mode and exit codes you can check from scripts.
Who it's for
It suits developers, analysts and administrators who inherit DBF data from older accounting, GIS or FoxPro systems. It also suits anyone who needs to convert those files regularly or script the conversions. If you only need to open a file now and then, the free edition may be enough to look at your data.
Pros and cons
Pros
- SQL on DBF files, with multiple query tabs
- Wide range of import, export and database transfer options
- Full encoding control, including UTF-8
- Command-line batch mode for automation
- Dark theme and a multi-language interface
- Long-running product with a documented version history
Cons
- Windows only
- Licensing is subscription-based, so you pay again to keep getting updates and support
- The free edition caps imports, exports and conversions at 1000 rows and search-and-replace at 100 occurrences, so serious work needs the Professional edition
What users say
"At first, I should say that this is the best DBF editor I have ever used" (Elphsoft testimonials)
"This great program has all the features I have been looking for quite a long time" (Elphsoft testimonials)
FAQs
Is there a free version?
Yes. DBF Commander Free covers opening, creating, editing, filtering and ordering. Import, export, conversion and SQL script generation stop at 1000 rows. Professional removes those limits and adds premium support.
Can it handle UTF-8 data?
Yes. You can convert a DBF from ANSI to UTF-8 or back. Export to CSV also supports UTF-8.
Do I need Excel installed to export to XLS or XLSX?
No. The export to XLS and XLSX is native, so MS Excel does not need to be on the machine.
Can I automate conversions?
Yes. The command line supports batch operations, a silent mode and exit codes. You can also generate chart images from the command line.
How long is the trial?
The trial period is 30 days.
System requirements
The program runs on Windows, and the latest build was adapted for Windows 11. The installer is about 6 MB.