CSV (Comma-Separated Values) files store tabular data in plain text format, making them widely used for data exchange. If you want to import CSV data into MongoDB, follow the steps below.

Step 1: Prepare Your CSV File

Ensure your CSV file is properly formatted with column headers. Example:

name,age,city
John,25,New York
Alice,30,Los Angeles
Bob,28,Chicago
    

Step 2: Start MongoDB

Ensure MongoDB is running. If not, start the MongoDB server using the following command:

mongod
    

Step 3: Use mongoimport Command

Use the mongoimport tool to import the CSV file into MongoDB. Run the following command:

mongoimport --db mydatabase --collection mycollection --type csv --headerline --file data.csv
    

Explanation:

• --db mydatabase: Specifies the database name.
• --collection mycollection: Defines the collection to store the data.
• --type csv: Indicates that the input file is a CSV.
• --headerline: Uses the first row as field names.
• --file data.csv: Specifies the CSV file name.

Step 4: Verify Data in MongoDB

Open the MongoDB shell and check if the data was imported successfully:

mongo
use mydatabase
db.mycollection.find().pretty()
    

Conclusion

By following these steps, you can efficiently import CSV data into MongoDB. This method is useful for data migration, analytics, and database management.