What is a DBF File and How do You Open It?

Quick Answer. DBF is a database file format that started with dBASE. DBF files contain a header and a table of records. FoxPro, Access and Excel open DBF data. LibreOffice Calc opens DBF data for free. DBF data carry no password protection.

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.

DetailDBF
Extension.dbf
OrigindBASE
Used bydBASE, FoxPro, Clipper and many data export tools
ContentsOne table of records
MIME typeapplication/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)

  1. Start Excel and select File and then Open.
  2. Choose All Files or the dBase files filter in the file type list.
  3. 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