Excel cannot open a DBF file
You double-click a .dbf and Excel shows an error, a column of blanks or text full of odd symbols. The file is usually fine; it is that Excel’s dBase support only covers the oldest, simplest tables.
Free to use. Nothing to install. The file is read in your browser and never uploaded. Windows version — 4.6 MB, no installation: details. Pro — $29 once: price.
What you see and what it usually means
| Symptom | Likely cause |
|---|---|
| An error that the file format is not recognised or is corrupt | A dialect Excel does not read — Visual FoxPro, dBase 7, Clipper variants — or a header Excel rejects |
| Opens, but accented or non-Latin letters are wrong | Excel decoded the text with the wrong code page; DBF stores one byte per character and the code page is a hint in the header — see garbled text |
| Long text columns are blank or contain numbers | The text lives in a separate memo file (.fpt or .dbt) that was not found or not read — see memo files |
| Some rows are missing, or there are too many | Records flagged as deleted are handled differently by different programs — see deleted records |
| Leading zeros are gone | Codes were converted to numbers — see leading zeros |
Ways around it
- Open it in a DBF viewer first. Confirm the dialect, the code page and the memo, filter out what you do not need, then export to XLSX with deliberate column types. This is also the least lossy route into Excel.
- Try LibreOffice Calc. It has its own dBase reader and often opens what Excel refuses, but it asks for a character set and handles memo only partly.
- Use the ODBC / OLE DB route from Excel’s Data tab. It needs a driver matching your Office’s bitness and a configured data source, and memo is often unreadable.
- Check the file is really a DBF. Some exports are saved with a
.dbfextension but are CSV or another format; the first bytes of the file show it. See DBF file structure.
If the file really is damaged
A truncated download or a file cut off mid-record can fail in every program. A tool that reads the header and then the records one by one can often still show the intact part. Compare the file size with what the header says: header length plus record length times record count should come close to it.
FAQ
Did a Microsoft update remove DBF support?
Support has been narrowed over the years and covers only the classic dialects. If a table opened before and does not now, a different dialect, memo or code page is the more likely reason than the file itself.
How do I get a DBF into Excel correctly?
Open it in a viewer, check the encoding and memo, then export to XLSX. See converting DBF to Excel or CSV.
Is it safe to use an online DBF converter?
Only if the file is processed locally. Many converters upload it to a server; check before sending real data.
Can I save back to DBF from Excel?
Not reliably: where a dBase save option exists it covers only classic dBase, with no memo and field names limited to ten characters.
Free to use. Your file is not uploaded to a server. Windows version — 4.6 MB, no installation: details. Pro — $29 once: price.