node package manager
Stop writing boring code. Discover, share, and reuse within your team. Create a free org »




Read and write .dbf (dBase III) files in Node.js:

  • Supports C (string) , N (numeric) , I (integer) , L (logical) and D (date) field types
  • Can open an existing .dbf file
    • Can access all field descriptors
    • Can access total record count
    • Can read records in arbitrary-sized batches
    • Supports very large files
  • Can create a new .dbf file
    • Can use field descriptors from a hash of from another instance
  • Can append records to an existing .dbf file
    • Supports very large files
  • All operations are asyncronous and return a promise


npm install dbffile

Example: reading a .dbf file

var DBFFile = require('dbffile');'[full path to .dbf file]')
    .then(dbf => {
        console.log(`DBF file contains ${dbf.recordCount} rows.`);
        console.log(`Field names: ${ =>}`);
        return dbf.readRecords(100);
    .then(rows => rows.forEach(row => console.log(row)))
    .catch(err => console.log('An error occurred: ' + err));

Example: writing a .dbf file

var DBFFile = require('dbffile');
var fieldDescriptors = [
    { name: 'fname', type: 'C', size: 255 },
    { name: 'lname', type: 'C', size: 255 }
var rows = [
    { fname: 'Joe', lname: 'Bloggs' },
    { fname: 'Mary', lname: 'Smith' }
DBFFile.create('[full path to .dbf file]', fieldDescriptors)
    .then(dbf => {
        console.log('DBF file created.');
        return dbf.append(rows);
    .then(() => console.log(rows.length + ' rows added.'))
    .catch(err => console.log('An error occurred: ' + err));


The module exports two functions and a class, as follows:

/** Open an existing DBF file. */
function open(path: string): Promise<DBFFile>;
/** Create a new DBF file with no records. */
function create(path: string, fields: Field[]): Promise<DBFFile>;
/** Represents a DBF file. */
class DBFFile {
    /** Full path to the DBF file. */
    path: string;
    /** Total number of records in the DBF file (NB: includes deleted records). */
    recordCount: number;
    /** Metadata for all fields defined in the DBF file. */
    fields: { name: string; type: string; size: number; decs: number; }[];
    /** Append the specified records to this DBF file. */
    append(records: any[]): Promise<DBFFile>;
    /** read some specific rows from the dbf file. **/
    readRecords(maxRows?: number): Promise<any[]>;