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
Your file is processed automatically and deleted right after you download the result, or after 3 hours at the latest.
Import a file from a URL
Paste a direct link to the file. We download it to our server and it is converted exactly like an upload.
How it works
-
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/3
Perform .xls to .dbf conversion
After successful file upload, click to convert when you are ready.
-
3/3
Download converted .dbf file
Conversion result is ready to download.
Conversion statistics: XLS to DBF
Updated November 21, 2026, from conversions on 101convert.com
How to convert xls to dbf file
- Databases
- No ratings yet.
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
- Make a backup of the original
.xlsfile. Keep one data table per worksheet, with the column names in the first row. - Remove title rows, merged cells, blank header cells, subtotals, and decorative formatting that are not part of the data.
- Open the workbook in LibreOffice Calc and select the worksheet to export. The DBF format stores one table, so export each required worksheet separately.
- Choose File → Save As.
- Select
dBASE (*.dbf)as the file type, enter a filename, and choose Save. - Confirm use of the dBASE format. If Calc displays an encoding or character-set option, choose the code page required by the destination application.
- Open the resulting
.dbfin 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.
| 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
Suggested software and links: xls to dbf converters
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.
Additional formats for
xls file conversion
Reverse conversion
Convert to dbf from
other formats
- xlsx to dbf
- db to dbf
- csv to dbf
- sqlite to dbf
- fox to dbf
- xlsb to dbf
- fxp to dbf
- gdb to dbf
- mdb to dbf
- sdf to dbf
- accdb to dbf
- adb to dbf
- crp to dbf
- db2 to dbf
- dbc to dbf
- dbt to dbf
- dbv to dbf
- dbx to dbf
- doc to dbf
- fdb to dbf
- fmp to dbf
- fpt to dbf
- frc to dbf
- fwp to dbf
- jpg to dbf
- lbl to dbf
- ndx to dbf
- ntx to dbf
- odb to dbf
- ods to dbf
- otg to dbf
- pmw to dbf
- sda to dbf
- sdd to dbf
- smf to dbf
- spr to dbf
- stc to dbf
- str to dbf
- sxc to dbf
- sxi to dbf
- tbk to dbf
- txt to dbf
- uos to dbf
- uot to dbf
- vor to dbf
- wfm to dbf
- xlsm to dbf
- xltx to dbf