What does a DBF Contain?
DBF is short for database file. The dBASE database system created the format, and later programs like FoxPro and Clipper adopted it.
A DBF stores one table. Rows contain records and columns contain fields like names, dates and numbers.
| Detail | DBF |
|---|---|
| Extension | .dbf |
| Origin | dBASE |
| Used by | dBASE, FoxPro, Clipper and many data export tools |
| Contents | One table of records |
| MIME type | application/dbase |
How is a DBF File Built?
A DBF has two parts. The header record lists meta data like the last update date, the number of records and the field definitions. The data records follow and contain the values for every field.
Because the format is plain and well documented, many tools open and save it, and legacy systems still export data to DBF data.
What Opens a DBF File?
Method #1: Open It in Excel (Free With Excel)
- Start Excel and select File and then Open.
- Choose All Files or the dBase files filter in the file type list.
- Select the DBF and then Open.
Method #2: Open It in LibreOffice (Free)
Start LibreOffice Calc and select File and then Open. LibreOffice Help states that you can open and save dBASE files, and that formulas and formatting get lost when you save one.
Method #3: Open It in Access or a Viewer
Microsoft Access imports DBF tables, and a DBF viewer shows the file with no database program. Save the table as CSV when you need to share the data.
What Problems do DBF Files Cause?
- Damage. A network or workstation interruption can corrupt a DBF.
- No security. The format has no password or permission settings.
- Old limits. Old DBF versions cap the file size and field types.
- Odd characters. A wrong code page shows broken symbols when you open the file.
Copy the file before you open it, and convert important data to CSV or Excel. Our MBOX file guide and OLM file guide explain other file formats in this family.
Frequently Asked Questions
What does DBF Stand for?
DBF stands for database file. dBASE created the format.
Which Programs Open DBF Data?
Excel, Access, LibreOffice Calc, FoxPro and dBASE open them. Free DBF viewers exist too.
How does Excel Open One?
Select File, Open and choose All Files or the dBase filter. Select the DBF and then Open.
Can You Convert It to CSV?
Yes. Open the file in Excel or LibreOffice Calc and save it as CSV.
Why do Strange Characters Appear?
The file uses a code page that your program does not match. Try another encoding when you import it.
Can One DBF Contain Several Tables?
No. One DBF holds one table. A dBASE database is a folder of DBF data.
Is It Safe to Edit?
Edit a copy. Saving in another program can drop formatting and break field settings.
Author's Verdict
DBF is a plain table format, so Excel or LibreOffice opens most files in seconds.
Copy first and convert to CSV when you plan to share the data.
Key Takeaways
- DBF started with dBASE and holds one table.
- Excel and LibreOffice open DBF data.
- The format has no password protection.
Related Guides