What Is a DBF File?
A file with the .DBF file extension is most likely a Database file used by the data management system dBASE. Data is stored within the file in an array with multiple records and fields. Since the file structure is pretty straightforward, and the format was used early on when database programs first arose, it’s been considered a standard format for structured data. Esri’s ArcInfo stores data in files that end in .DBF, too, but it’s called the shapefile attribute format instead. These files use the dBASE format to store attributes for shapes. Free tables created by Microsoft Visual FoxPro are also stored as files that use this extension. Confusingly, database files used by that program are saved as DBC files. There’s more on Microsoft’s site about Visual FoxPro terminology.
How to Open DBF Files
dBASE is the primary program used to open DBF files. However, the file format is supported in other database and database-related applications too, like Microsoft Access and Excel, Quattro Pro (a part of Corel WordPerfect Office), OpenOffice Calc, LibreOffice Calc, HiBase Group DBF Viewer, Astersoft DBF Manager, DBF Viewer Plus, DBFView, and Alpha Software Alpha Anywhere. GTK DBF Editor is one free DBF opener for macOS and Linux, but NeoOffice (for Mac), multisoft FlagShip (Linux), and OpenOffice work as well. Xbase mode can be used with Emacs to read xBase files. ArcInfo from ArcGIS uses DBF files in the shapefile attribute file format. The discontinued Microsoft Visual FoxPro database software is another way to open these files.
How to Convert a DBF File
Most of the software from above that can open or edit this file type can most likely convert it, too. For example, Excel can save one to any format supported by that program, like CSV, XLSX, XLS, PDF, etc. The same company that releases DBF Viewer, mentioned above, also has DBF Converter, which converts the file to CSV, Excel formats like XLSX and XLS, plain text, SQL, HTM, PRG, XML, RTF, SDF, and TSV. dbfUtilities exports DBF to JSON, CSV, XML, and Excel formats. It works through the dbfExport tool included in the dbfUtilities suite. You can convert this file online using DBFconv.com, which supports exporting to CSV, TXT, and HTML.
Still Can’t Open the File?
If your file isn’t opening with the suggestions from above, double-check the file extension to make sure it actually reads as DBF. Some file formats use an extension that’s spelled a lot like other ones, even when the formats are completely unrelated. One example is DBX. They might be Outlook Express Email Folder files or AutoCAD Database Extension files, but either way, they can’t open with the same tools mentioned above. If your file doesn’t open with those database programs, check to make sure you’re not actually dealing with a DBX file. If what you have is really a DBK file, it might be in the Sony Ericsson Mobile Phone Backup file format. It can probably open with a tool like 7-Zip, but it won’t work with the database applications above. Other file extension examples that you could easily confuse for this one include DB, DBA, PDB, and MDE.
More Information on dBASE
DBF files are often seen with text files that use the .DBT or .FPT file extension. Their purpose is to describe the database with memos or notes, in raw text that’s easy to read. NDX files are Single Index files that store field information and how the database is to be structured; it can hold one index. MDX files are Multiple Index files that can contain up to 48 indexes. All the details on the header of the file format can be found on the dBASE website. The release of dBASE in 1980 made its developer, Ashton-Tate, one of the biggest business software publishers in the market. It originally ran only on the CP/M microcomputer operating system but was soon ported over to DOS, UNIX, and VMS. Later that decade, other companies began releasing their own versions of dBASE, including FoxPro and Clipper. This prompted the release of dBASE IV, which came around the same time as SQL (Structured Query Language) and the growing use of Microsoft Windows. By the early 1990s, with xBase products still popular enough to be the leader in business applications, the top three firms, Ashton-Tate, Fox Software, and Nantucket, were purchased by Borland, Microsoft, and Computer Associates, respectively.
