Free online DBF to XLSX converter

A legacy database, GIS attribute table, or business system may export records as .dbf when the recipient needs an Excel workbook for editing, reporting, or sharing. Converting to .xlsx makes the table accessible in current spreadsheet software without requiring the original database application.

What the DBF format is

DBF is the dBASE database table format used by dBASE, FoxPro, Visual FoxPro, Clipper, and older business applications. It stores rows and typed fields such as character, numeric, date, logical, and memo values. Shapefile-based GIS datasets commonly use a DBF file for attribute data.

DBF is a family of related xBase formats, so field types, encoding conventions, and companion-file requirements vary by application. Memo fields may be stored in a separate .dbt or .fpt file; .cdx and .mdx files usually contain indexes. Keep companion files beside the DBF during local conversion. Opening only the DBF can leave memo fields missing or truncated.

What the XLSX format is

XLSX is the ZIP-based Office Open XML workbook format used by Microsoft Excel and supported by LibreOffice Calc, Apple Numbers, and many spreadsheet libraries. It can contain multiple worksheets, cell values, formulas, formatting, filters, charts, and tables.

XLSX is suitable when the data must be edited in a spreadsheet or sent to people without DBF-compatible software. Each worksheet supports up to 1,048,576 rows and 16,384 columns; larger DBF tables must be split or filtered before export.

How to convert DBF to XLSX

Using LibreOffice Calc

1. Install LibreOffice and place the DBF with any required .dbt or .fpt memo file in the same folder.
2. Open LibreOffice Calc and select File → Open. Choose the .dbf file.
3. In the import dialog, select the character set used by the source system. Common possibilities include Windows-1252, ISO-8859-1, and UTF-8, but the correct choice must come from the exporting application or its documentation.
4. Check column names, row values, dates, decimal separators, non-ASCII characters, and memo fields. Treat identifiers such as postal codes, product codes, and account numbers as text when leading zeros matter.
5. Select File → Save As, choose Excel 2007–365 (*.xlsx), and save the workbook.
6. When LibreOffice asks about the format, choose Use Excel 2007–365 Format.

Using the 101convert online converter

101convert.com can convert a DBF file to XLSX for free without installing software: upload the DBF, select XLSX as the output format, start the conversion, and download the workbook. Do not upload confidential or regulated records unless the service’s current handling and retention terms meet your requirements. For memo-heavy or sensitive databases, use a local application and retain all companion files.

Using Python for repeatable conversions

Install the required packages:

pip install dbfread pandas openpyxl

Run this example with the source file’s actual encoding:

python -c "from dbfread import DBF; import pandas as pd; df=pd.DataFrame(iter(DBF('records.dbf', encoding='cp1252'))); df.to_excel('records.xlsx', index=False)"

Replace cp1252 with the DBF’s real encoding and keep memo files available to dbfread. This exports records and fields but does not recreate DBF indexes, forms, relationships, validation rules, deleted-record flags, or application-specific behavior. For repeatable jobs, add explicit handling for date fields, null values, memo fields, and columns that must remain text.

Quality and compatibility limits

Encoding errors are irreversible if the wrong character set is used during import. DBF files often do not identify their encoding reliably, so inspect names, addresses, and other non-ASCII text before saving.

Spreadsheet software may interpret DBF dates, logical values, numeric precision, nulls, and decimal separators differently. Check for day-month versus month-day changes, rounded values, blank-versus-zero changes, and altered logical values.

Excel may automatically format identifiers as numbers, remove leading zeros, display long values in scientific notation, or interpret date-like codes as dates. Set those columns to text during import or correct their cell formats before exporting.

Indexes, relationships, field constraints, forms, queries, application metadata, and DBF deleted-record state do not have equivalent automatic representations in a basic XLSX export. Compare the expected active-record count with the worksheet count, inspect representative records, and verify memo fields before distributing the workbook.