Free online DBF to JSON converter

Source format: DBF

DBF is a database table file format originally associated with dBASE and later used by many database and GIS applications. A DBF file stores structured tabular data in rows and columns, similar to a spreadsheet or a simple database table. It is commonly used with legacy business systems, desktop database tools, and mapping software such as ArcGIS or QGIS, often alongside related files like .shp and .shx in shapefile datasets.

DBF is valued for its simplicity and broad compatibility, but it is also an older format with limitations such as fixed field types, limited text encoding support in some files, and constraints on field lengths and table size.

Target format: JSON

JSON (JavaScript Object Notation) is a lightweight, text-based data format used for data exchange, APIs, configuration files, and modern web applications. It represents data as objects and arrays, making it easy for software to parse and process.

Compared with DBF, JSON is more flexible for nested data, widely supported across programming languages, and easier to integrate into web services and automation workflows. It is especially useful when tabular data needs to be consumed by applications, scripts, or APIs.

How to convert DBF to JSON

The best method depends on whether you want a one-time conversion or a repeatable workflow. For most users, a desktop tool or a script is the most reliable approach. You can also convert the file on 101convert.com for free, without installing any software.

Option 1: Use Python for accurate conversion

If you need a dependable conversion that preserves table structure, Python is a strong choice. Install a DBF-reading library such as dbfread, then export the rows to JSON.

Example workflow:

1. Install Python.
2. Install the library with pip install dbfread.
3. Run a script that reads the DBF table and writes JSON output.

Example script:

from dbfread import DBF
import json

table = DBF('input.dbf', load=True)
rows = list(table)

with open('output.json', 'w', encoding='utf-8') as f:
json.dump(rows, f, ensure_ascii=False, indent=2)

This produces a JSON array where each DBF record becomes one JSON object.

Option 2: Use LibreOffice or spreadsheet software for inspection first

If you want to review or clean the data before exporting, open the DBF file in LibreOffice Calc or another database/spreadsheet tool that supports DBF. Then export or save the data in a format that can be converted to JSON with a script. This is useful when you need to correct encoding issues or remove unwanted columns before final export.

Option 3: Use GIS software for shapefile-related DBF files

If the DBF file belongs to a shapefile dataset, open the full dataset in QGIS or ArcGIS. Export the attribute table to a text-based format if needed, then convert that output to JSON. This is often the safest route when the DBF is part of geospatial data and must stay aligned with geometry files.

General conversion steps

1. Open or read the DBF file with software that supports DBF tables.
2. Check the column names, data types, and character encoding.
3. Export each row as a JSON object.
4. Save the result as .json using UTF-8 encoding.
5. Validate the JSON file in a viewer or parser to confirm it is well formed.

Notes on quality and limitations

DBF to JSON conversion is usually straightforward, but there are a few important limitations. DBF stores data in a flat table, so nested JSON structures are not created automatically; the result is typically an array of objects. If the DBF file contains dates, logical values, or numeric fields, the converter must map them correctly to JSON types.

Character encoding can be a common issue. Older DBF files may use code pages instead of UTF-8, which can cause accented characters or symbols to appear incorrectly unless the file is read with the proper encoding.

Field names in DBF are often limited in length, so the JSON keys may be short or less descriptive than desired. Also, DBF does not preserve advanced database features such as relationships, indexes, or constraints in a JSON export.

If the DBF file is part of a shapefile, remember that the DBF contains only attribute data, not geometry. Converting it to JSON will not automatically create a full geospatial GeoJSON file unless the geometry is exported separately and combined with the attributes.