Skip to content

Instantly share code, notes, and snippets.

@ctmcisco

ctmcisco/README.md

Forked from bertspaan/README.md
Created October 25, 2021 19:20
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ctmcisco/cf0b2f11fb25d3e542d7f78ae8e0d89b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ctmcisco/cf0b2f11fb25d3e542d7f78ae8e0d89b to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. @bertspaan bertspaan created this gist Jan 2, 2014.
    8 changes: 8 additions & 0 deletions README.md
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,8 @@
    # Python script to convert DBF database file to CSV

    - First download `dbfpy`: http://sourceforge.net/projects/dbfpy/files/latest/download?source=files
    - Then install: `sudo python setup.py install`

    To convert DBF file to CSV:

    ./dbf2csv database.dbf
    24 changes: 24 additions & 0 deletions dbf2csv.py
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,24 @@
    #!/usr/bin/python

    import csv
    from dbfpy import dbf
    import os
    import sys

    filename = sys.argv[1]
    if filename.endswith('.dbf'):
    print "Converting %s to csv" % filename
    csv_fn = filename[:-4]+ ".csv"
    with open(csv_fn,'wb') as csvfile:
    in_db = dbf.Dbf(filename)
    out_csv = csv.writer(csvfile)
    names = []
    for field in in_db.header.fields:
    names.append(field.name)
    out_csv.writerow(names)
    for rec in in_db:
    out_csv.writerow(rec.fieldData)
    in_db.close()
    print "Done..."
    else:
    print "Filename does not end with .dbf"