Skip to content

Free online XLS to DBF converter

Convert legacy Excel XLS worksheets into DBF tables for GIS, accounting, and database software.

Convert XLS to DBF online - free

Uploading…

Your file is processed automatically and deleted right after you download the result, or after 3 hours at the latest.

How it works

  1. 1/3

    Upload your .xls file

    Click to browse to select your file you want to convert or simply drag & drop your file into selected area.

  2. 2/3

    Perform .xls to .dbf conversion

    After successful file upload, click to convert when you are ready.

  3. 3/3

    Download converted .dbf file

    Conversion result is ready to download.

Conversion statistics: XLS to DBF

XLS files are most often converted to OFX 33% VCF 16% DBF 9% SAV 9%

Updated November 21, 2026, from conversions on 101convert.com

How to convert xls to dbf file

Legacy GIS, accounting, and database programs may require a DBF table instead of an Excel workbook. Converting the spreadsheet produces a flat table that older software can open, edit, or import.

What the XLS format is

XLS is Microsoft Excel's binary workbook format for Excel 97–2003, also supported by applications such as LibreOffice Calc. An XLS file can contain multiple worksheets, formulas, formatting, charts, merged cells, and typed values, but these workbook features do not map directly to a DBF table.

What the DBF format is

DBF is the dBASE table format used by dBASE, FoxPro, Visual FoxPro, older accounting systems, and some GIS applications. It stores records as rows and columns with field types such as character, numeric, logical, and date; some variants also support memo fields.

DBF is useful when the destination program specifically expects a dBASE table. Its simple, relatively compact structure is easy for legacy software to read, but it does not store worksheet layout, cell formatting, charts, workbook relationships, or spreadsheet formulas.

How to convert an XLS file

Using LibreOffice Calc

  1. Make a backup of the original .xls file. Keep one data table per worksheet, with the column names in the first row.
  2. Remove title rows, merged cells, blank header cells, subtotals, and decorative formatting that are not part of the data.
  3. Open the workbook in LibreOffice Calc and select the worksheet to export. The DBF format stores one table, so export each required worksheet separately.
  4. Choose File → Save As.
  5. Select dBASE (*.dbf) as the file type, enter a filename, and choose Save.
  6. Confirm use of the dBASE format. If Calc displays an encoding or character-set option, choose the code page required by the destination application.
  7. Open the resulting .dbf in the target program and inspect field names, dates, numbers, identifiers, and non-ASCII text.

Using the built-in converter

For conversion without installing software, upload the .xls file to the free converter on 101convert.com, select DBF as the output format, start the conversion, and download the resulting .dbf file. Verify the downloaded table in the application that will use it, particularly when the workbook contains multiple worksheets or non-English text.

Using a database application

Microsoft Access can import an XLS worksheet as a table and, in versions that provide dBASE export, export that table through External Data → Export → More → dBase File. This approach is useful when records must be filtered or field types must be adjusted before export. The exact menu wording and available export formats depend on the Access version.

Compatibility and data-loss issues

  • Workbook features are discarded. DBF output contains records and fields, not worksheets, formulas, formatting, charts, or named ranges. Formula cells are exported as their calculated values or as ordinary data, not as reusable formulas.
  • Field names may be shortened. The widely compatible dBASE III convention permits field names of up to 10 characters. Rename long or duplicate XLS headers before export; otherwise software may truncate or alter them.
  • Column types can change. A column containing both text and numbers may be exported as character data. Empty or inconsistent values can produce blanks, default values, or conversion errors depending on the software and DBF variant.
  • Preserve identifiers deliberately. Postal codes, account numbers, and other values with leading zeros must be stored as text in XLS before conversion. Large numbers may lose precision if they are treated as numeric fields.
  • Dates need checking. Standard DBF date fields normally store a calendar date, not a time-of-day value or a time-zone-aware timestamp. Review date and time columns after export.
  • Encoding is not uniform. Many DBF implementations use a legacy code page rather than Unicode. Select the destination program's expected encoding and test accented, Cyrillic, Greek, or Asian characters.
  • Limits vary by DBF variant. Field widths, record sizes, memo support, null handling, and maximum table sizes differ between dBASE, FoxPro, and GIS implementations. Use the variant required by the receiving application and test a representative file.

XLS vs DBF: format comparison

How the XLS and DBF formats compare on the properties that matter most for this conversion.

Comparison of the XLS and DBF file formats
Property .XLS Microsoft Excel Spreadsheet .DBF dBASE Database File
Open standard No Partly open
Compression Both Uncompressed
Typical file size Medium Small
Opens in a web browser Partial No
Further editing Limited Limited
Metadata support Basic Basic
Plain-text readable No No
Best used for Data exchange Data exchange
Introduced 1987 1983
Developer Microsoft Ashton-Tate / dBASE, Inc. (format origin)
MIME type application/vnd.ms-excel application/x-dbf

Information about file extensions and file types is provided by File-Extensions.org

Frequently asked questions

Is the XLS to DBF converter free?

Yes, converting XLS to DBF on 101convert.com is completely free. No registration, email address or installation is required. If you need a higher file size limit or want to convert more files at once, see our plans.

How large can my XLS file be?

You can upload XLS files up to 10 MB and convert up to 3 files at once in a single batch. With a paid plan the limit is up to 50 MB per file and 20 files at once, see our plans.

What happens to my uploaded files?

Files are processed automatically. Your upload is deleted from our servers right after you download the result, or after 3 hours at the latest. We never view or share your files.

Do I need to install any software to convert XLS to DBF?

No. The XLS to DBF conversion runs entirely online in your browser and works on Windows, Mac, Linux, Android and iPhone.

Did the conversion fail?

In most cases, the cause is an incorrect file format. Please upload a valid XLS file for this XLS to DBF conversion. Occasionally, the issue may be on our side. We analyze recurring conversion failures and disable or fix the converter if we detect a defect.

Already downloaded

This file has already been downloaded. For your privacy it was deleted from our server right after the download, so it cannot be downloaded again. To get it once more, convert the file again.