What Is a DBF File? Format Explained and How to Open It in WPS

If someone emailed you an inventory export or a GIS attribute table ending in .dbf, the first question is usually the same: what is a DBF file, and can you open it without FoxPro? In short, a DBF file is a classic dBase-style database table—rows and columns stored in one file—still used by ERP systems, legacy apps, and shapefile workflows.

This guide answers what is DBF file format in plain language, shows how the structure works, and walks through opening and converting the table in WPS Spreadsheet so you can review data locally and share XLSX or CSV when partners need a modern workbook.

What is DBF file format in plain English

A DBF file (dBase database file) stores one table: field names, field types, and fixed-length records. The format started with dBASE in the early 1980s and became a de facto interchange standard. FoxPro, Clipper, and many GIS tools adopted the same idea—so when you ask what is DBF file, you are really asking about a portable table format that predates modern Excel workbooks.

Unlike XLSX, a DBF file is not a multi-sheet workbook. It is closer to a single database table you can open in a grid. Memo (long text) values may live in a companion .dbt or .fpt file; if that companion is missing, long notes can appear blank even when the .dbf itself opens.

Modern Microsoft Excel support for DBF varies by version and platform. Some desktop builds still open simple tables; Excel for the web often rejects the type; Mac Excel historically lacked reliable DBF open support. That is why many teams open the table in WPS Spreadsheet first—see the free DBF file viewer workflow—then Save As XLSX when they need a shareable workbook.

What is DBF file used for in business and GIS

Knowing what is DBF file used for helps you decide whether to keep the original export or convert it:

• ERP and ops exports — customer lists, stock snapshots, and batch reports from older systems still ship as .dbf.

• FoxPro / Visual FoxPro apps — legacy line-of-business tools continue to write dBase-style tables.

• GIS shapefiles — Esri shapefile packages store attribute columns in a .dbf alongside .shp and .shx. The geometry is not inside the DBF; the DBF holds the attribute table.

• Data handoffs — some portals still accept or produce DBF when they need a fixed schema without Excel formulas.

If your goal is analysis or sharing with teammates who only know Excel, convert after you review the grid. WPS can turn the table into a workbook with the DBF to Excel path (File → Save As → Excel Workbook). When a downstream system still requires DBF, you can also go the other way with XLSX to DBF.

What is DBF file structure: header, fields, and records

Under the hood, answering what is DBF file structure means three blocks:

1. Header — version flag, last update date, record count, header length, and record length.

2. Field descriptors — each column’s name (up to 11 characters in classic dBase), type (Character, Numeric, Date, Logical, Memo, and vendor extensions), length, and decimals.

3. Records — fixed-width rows. Each record starts with a deletion flag (space = active, asterisk = deleted). Fields are packed without separators.

Common field types you will see in practice:

• C — character / text

• N — numeric (stored as text digits in classic layouts)

• D — date (often YYYYMMDD)

• L — logical (true/false)

• M — memo pointer into .dbt / .fpt

Practical limits to remember: classic field names are short; some FoxPro types (datetime, currency, integer) may not round-trip perfectly in every spreadsheet; encoding (OEM code pages vs UTF-8) can garble non-English text if the wrong code page is assumed. Treat the first open as a visual check for headers, row counts, and odd characters—not as a guarantee that every proprietary type survived.

How to open a DBF file once you know what is DBF file basics

After you understand what is DBF file basics, opening one in WPS Spreadsheet is straightforward and stays on your device—no upload to an online viewer.

Open DBF file in WPS

1. Install and launch WPS Office, then open WPS Spreadsheet.

2. Choose File → Open (or Open → Computer → Browse).

3. Set the file type filter to dBase File (*.dbf) or All Files, select your .dbf, and click Open.

4. Confirm column headers and a sensible row count. If memo columns look empty, check whether a matching .dbt or .fpt file sits next to the .dbf.

   
   

Filter DBF rows in WPS

Once the grid loads, use familiar spreadsheet tools: Sort & Filter, Find, and light cell edits. Keep the original .dbf as the system export; treat your Spreadsheet session as the place to inspect and tidy before you hand data off.

How to convert and share after asking what is DBF file vs Excel

Teammates and portals rarely ask what is DBF file vs Excel—they simply expect an .xlsx. After the table looks right in WPS:

Save DBF as Excel workbook

1. Go to File → Save As.

2. Choose Excel Workbook (*.xlsx) for modern Excel, Google Sheets, and most dashboards—or Excel 97-2003 Workbook (*.xls) only when a partner still requires the older format (XLS still caps at 65,536 rows and 256 columns).

3. Pick CSV when a flat import file is enough.

4. Keep the original .dbf as backup for the source system.

Need a static handout instead of an editable sheet? Open the table, then export to PDF with the DBF to PDF flow. Going back into a legacy importer? Start from a workbook or CSV and use XLSX to DBF or CSV to DBF as needed.

Checklist before you send the file

• Header names match the source export.

• Row count is in the expected range (deleted records may still occupy space until packed).

• Dates and numbers look correct—not shifted or truncated.

• Non-English text is readable; if not, reopen with the correct encoding when your tool allows it.

• Confidential tables were converted locally—avoid uploading customer or payroll DBF files to random online converters.

Use Word, Excel, and PPT for FREE

Free Download

FAQ

What is a DBF file?
A DBF file is a dBase-style database table: one file holding field definitions and fixed-length records. It is still used by ERP exports, FoxPro apps, and GIS shapefile attribute tables.

Is a DBF file the same as Excel?
No. Excel workbooks (XLSX/XLS) support multiple sheets, formulas, and formatting. A DBF file is closer to a single database table. You can open a DBF in WPS Spreadsheet and Save As XLSX when you need Excel features.

Can I open a DBF file without FoxPro?
Yes. WPS Spreadsheet can open .dbf locally. You do not need FoxPro, dBase, or a Microsoft Excel license for a quick view and edit.

Why does Excel reject my DBF file?
Support depends on Excel version and platform. Some newer builds struggle with legacy encodings or refuse certain DBF variants; Excel on the web often blocks the type. Opening in WPS, then saving as XLSX, is a reliable workaround.

What about shapefile .dbf files?
The .dbf in a shapefile stores attributes only. Opening it in Spreadsheet shows the attribute table; it does not load map geometry from .shp.

Is converting DBF online safe?
Online tools require uploads. For customer lists, inventory, or finance exports, prefer a local open in WPS Spreadsheet so the file never leaves your device.

Free Office Download

   

• Use Word, Excel, and PPT for FREE, No Ads.

• Edit PDF files with the powerful PDF toolkit.

• Microsoft-like interface. Easy to learn. 100% Compatibility.

• Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

Free Download

100% secure

Algirdas Jasaitis