sridhar-macpro:test sridhar$ cat test.csv
name,location
"Chris","Right here",
"Delta","Right here and here" , , , ,

mongoimport -d test -c test -type csv --file ./test.csv --drop --headerline

> db.test.find()

{ "_id" : ObjectId("4e4d8b1df037a08ef9273a18"), "name" : "Chris", "location" : "Right here", "field2" : "" } { "_id" : ObjectId("4e4d8b1df037a08ef9273a19"), "name" : "Delta", "location" : "Right here and here", "field2" : "", "field3" : "", "field4" : "", "field5" : "" }