Convert DBF to CSV
Turn DBF documents into CSV. One CSV with the field names as the header, dates as YYYY-MM-DD and logical fields as TRUE or FALSE, decoded with the code page the file names, or as Western European when it names none.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop DBF files on the dialor turn it to pick what to do
A plain CSV from a dBase table.Field names become the header, and dates and logical values are written in a fixed form.
What you get
One CSV file with the field names from the DBF as the header row. Each record becomes a row.
Dates are written as YYYY-MM-DD. Logical fields are written as TRUE or FALSE.
Text is decoded with the code page the file names. If the file names none, it is read as Western European.
What does not come through
Some FoxPro field types are not supported. Currency, date-time and memo fields come out as an unsupported-field note instead of their values.
Double fields come out as 0, so their real values are not in the CSV.
When it fails
If the file cannot be parsed, the conversion stops with
input_corrupted. This means the DBF is damaged or is not a readable dBase table.To go the other way, use CSV to DBF.
DBF and CSV.What each format is.
The formats
dBase Table
dBase tables, the attribute tables of shapefiles and many legacy databases.
- Extensions
- .dbf
- MIME type
- application
/x -dbf - Kind
- Documents
CSV
Rows of comma-separated values. The plainest way to move a table between programs.
- Extensions
- .csv
- MIME type
- text
/csv - Kind
- Text and data
In your code.The same DBF to CSV conversion through the API, for your app or your agent.
$ cv convert sheet.dbf sheet.csv$ cv convert sheet.dbf sheet.csvQuestions.What people ask about DBF to CSV.
Dates are written as YYYY-MM-DD. Logical fields are written as TRUE or FALSE.
It uses the code page named in the DBF file. If the file names none, it reads the text as Western European.
They come out as an unsupported-field note, not as their values. The same holds for FoxPro date-time fields.
Double fields are not read and are written as 0. Check these columns before you rely on the CSV.