DBF Viewer: Complete Feature Guide & Reference

By FinancialDataTools.com Team  ·  March 2026  ·  11 min read  ·  Last updated March 14, 2026

What Is the DBF Viewer?

The FinancialDataTools.com DBF Viewer is a free, browser-based tool for opening and exploring dBASE DBF database files. It reads your .dbf files using a native JavaScript parser built directly into the viewer — no external library and no file upload to any server.

The viewer is designed for financial analysts, accountants, and data engineers who need to access legacy dBASE data stores — from old accounting software exports to FoxPro business applications to archival financial databases that have never been migrated to a modern format.

Supported dBASE Versions

The viewer automatically detects the DBF version from the file header byte and displays it in the stats bar. Supported formats include:

Any other version byte is displayed as a hex code (e.g., DBF (0x43)) and the file is still parsed using the standard dBASE record layout.

Supported Field Types

DBF files use single-character type codes to describe each field. The viewer reads and displays all standard types:

Fields with empty or whitespace-only values are displayed as NULL in the grid, regardless of their declared type.

The Toolbar

Stats Bar

The stats bar provides at-a-glance information about the loaded DBF file:

• Records: Total number of active (non-deleted) records
• Showing: Number of records visible after applying filters
• Fields: Number of field columns in the file
• Version: Detected dBASE format version (e.g., dBASE III, Visual FoxPro)

Sorting Fields

Click any column header to sort records by that field. The first click sorts ascending, the second descending, and a third returns to the original order. Numeric fields (N, F, B, O types) sort numerically; Date fields sort chronologically; Character and Logical fields sort alphabetically.

Record Filtering

Click the filter icon in any column header to open the column filter panel. Two modes are available:

• Values mode: A checklist of all distinct values in that field. Uncheck values to hide matching records. Supports up to 500 unique values per column.
• Conditions mode: Apply up to two conditions using operators: contains, does not contain, begins with, ends with, equals, does not equal, is empty/null, is not empty/null, greater than, less than, and their inclusive variants. Combine two conditions with AND or OR.

Multiple active column filters are combined with AND logic. The number of active filters appears in a pink badge in the stats bar — click it to clear all filters at once.

Global Search

The toolbar search box performs a real-time text search across all fields simultaneously. Any record not containing the search term in any field is hidden. Global search stacks with column filters — both must be satisfied for a record to appear.

Field Schema Inspector

Click the Schema button in the toolbar to open the field definition modal. For each field, it displays:

• Field name: As defined in the DBF header (max 10 characters in standard dBASE)
• Type: The single-character dBASE type code (C, N, D, L, M, etc.)
• Len: The declared field length in bytes
• Dec: The number of decimal places (for numeric fields)

The Copy Field List button copies the full schema as plain text — useful when documenting a legacy database or mapping field definitions to a target schema for migration.

Deleted Records

dBASE uses a soft-delete mechanism: records are marked for deletion with a 0x2A (*) byte at the start of the record but are not immediately removed from the file. The DBF Viewer automatically skips deleted records — only active records are displayed and counted. This is consistent with standard dBASE behavior where a PACK operation is required to physically remove deleted records.

The record count shown in the stats bar reflects active records only, so it may be lower than the total record count reported by the DBF file header.

Pagination

DBF files with more than 50,000 active records are automatically paginated to 5,000 records per page. The page bar at the bottom shows the current page, total pages, and the absolute record range. Navigation buttons — First, Previous, Next, Last — let you move through pages. A pagination badge appears in the stats bar when pagination is active.

Export Options

Click Export in the toolbar to open the export dialog. Four formats are available:

Two export scopes: Filtered view exports only records visible after applying current filters, and All records exports every active (non-deleted) record ignoring filters.

Privacy & Security

The DBF Viewer is entirely client-side. Your file is read using a native JavaScript parser running inside your browser tab — no file content is transmitted to any server. The only network requests are to load the viewer itself and the ExcelJS library from a CDN (used only during Excel export).

This makes it appropriate for sensitive financial data including legacy accounting databases, FoxPro-based business systems, and archival records containing client or transaction data.

Closing the browser tab clears all data from memory immediately. No data is written to localStorage or any persistent browser storage.

Use Cases for Financial Data

dBASE and FoxPro were dominant database platforms in accounting and business software through the 1990s, and their DBF format remains the file format of choice for many legacy systems still in active use. Common scenarios:

• Legacy accounting software: Applications built on dBASE III/IV or Clipper — including many DOS-era accounting platforms — store ledger entries, invoices, and customer records in DBF files that can now be opened directly in the browser.
• FoxPro business applications: Custom-built FoxPro and Visual FoxPro applications used in finance departments, insurance, and real estate stored structured data in DBF files. The viewer can open these without any FoxPro installation.
• Geographic and property data: Shapefiles (used in GIS for property and land records) always include a companion .dbf file containing attribute data. The DBF Viewer can open these attribute files to inspect parcel, zoning, or valuation data.
• Data migration audits: When migrating from legacy DBF systems to SQL Server, PostgreSQL, or cloud platforms, the viewer lets you audit field types, record counts, and value distributions before committing to a migration plan.
• Archival research: Historical financial records stored in DBF format from decades-old business systems can be opened and exported to modern formats without installing dBASE, FoxPro, or any third-party software.

Related Articles