You need to run mongoimport commands from your system’s command line (e.g. If you don’t have it, you can use the installation instructions over at the MongoDB website to install it on to your system. If you have it, you should see version information, etc. If you’re not sure whether you have the MongoDB Database Tools/ mongoimport installed, try running the following command in your Terminal or Command Prompt to check: mongoimport -version The MongoDB Database Tools are a suite of command-line utilities for working with MongoDB. Mongoimport is part of the MongoDB Database Tools package. See The Import Modes of mongoimport for examples of each mode. Any non-matching documents have no effect. All other documents are inserted.ĭeletes existing documents in the database that match a document in the import file. Merges existing documents that match a document in the import file with the new document. Replaces existing documents in the database with matching documents from the import file. All other documents are inserted. A matching document is one that has the same unique ID (such as a matching _id field) as a document in the import file. If a matching document already exists in the collection, an error occurs. This mode inserts the documents from the import file. These modes determine what happens if there’s already matching documents in the collection that you’re trying to import into. There are various import modes that you can use with mongoimport. Result: Īs expected, our new document is the only one in the collection. In this case, I didn’t specify a collection to import it into, so it created a collection with the same name of the file ( pets). The following command imports the CSV file into MongoDB: mongoimport -db=PetHotel -type=csv -headerline -file=pets.csv Suppose we have the following CSV file called pets.csv: _id,name,type This article presents examples of importing a CSV file into MongoDB. The import file could have been created by mongoexport or some other export utility. mongoimport is a command line utility that imports content from an Extended JSON, CSV, or TSV file. When using MongoDB, you can use mongoimport to import documents into a collection.

How to convert a file into extra base