How to use mongoimport to import CSV files?

by

Your example worked for me with MongoDB 1.6.3 and 1.7.3. Example below was for 1.7.3. Are you using an older version of MongoDB?

$ cat > locations.csv
Name,Address,City,State,ZIP
Jane Doe,123 Main St,Whereverville,CA,90210
John Doe,555 Broadway Ave,New York,NY,10010
 ctrl-d
$ mongoimport -d mydb -c things --type csv --file locations.csv --headerline
connected to: 127.0.0.1
imported 3 objects
$ mongo
MongoDB shell version: 1.7.3
connecting to: test
> use mydb
switched to db mydb
> db.things.find()
{ "_id" : ObjectId("4d32a36ed63d057130c08fca"), "Name" : "Jane Doe", "Address" : "123 Main St", "City" : "Whereverville", "State" : "CA", "ZIP" : 90210 }
{ "_id" : ObjectId("4d32a36ed63d057130c08fcb"), "Name" : "John Doe", "Address" : "555 Broadway Ave", "City" : "New York", "State" : "NY", "ZIP" : 10010 }

More Related Contents:

  1. How to use mongoimport to import csv
  2. Mongoimport of JSON file
  3. Cannot import mongodb
  4. MEAN app vs. Mongo service local in Angular2
  5. Find objects between two dates MongoDB
  6. MongoDB: Combine data from multiple collections into one..how?
  7. MongoDB: Is it possible to make a case-insensitive query?
  8. How to update the _id of one MongoDB Document?
  9. Multiple join conditions using the $lookup operator
  10. Aggregate $lookup Total size of documents in matching pipeline exceeds maximum document size
  11. How to Model a “likes” voting system with MongoDB
  12. Overflow sort stage buffered data usage exceeds internal limit
  13. Slow pagination over tons of records in mongodb
  14. MongoDB – paging
  15. MongoDB query with an ‘or’ condition
  16. mongo.exe not installed in Version 6.0.0
  17. multiple instances of Mongo DB on same server
  18. How do I import a CSV file in R? [closed]
  19. How can I share MongoDB collections between Meteor apps?
  20. How to sum every fields in a sub document of MongoDB?
  21. Where does mongodb stand in the CAP theorem?
  22. MongoDB: how to parse date in 3.6 mongoDb version?
  23. MongoDB – What about Decimal type of value?
  24. MongoDB – Querying between a time range of hours
  25. MongoDB $or query
  26. MongoDB Text Search AND multiple search words
  27. How to get multiple document using array of MongoDb id?
  28. What is the maximum number of parameters passed to $in query in MongoDB?
  29. MongoDB : aggregation framework : $match between fields
  30. Trying to merge multiple csv files in R

Leave a Comment