Use mongoimport to Import a CSV file into a MongoDB Database and Collection 

I almost spent 2 hours and didn't figured out my mistake. But you my bro saved my day.

This video is so helpful, really hard to find a walk through but this was perfect (uploading CSV files to MongoDB on a Mac as a newbie)

Thanks so much, very helpful! I am working on my final project for a college class and it required me to import a csv file into mongodb. This video was extremely easy to follow and it took me a total of 10 minutes from installation of mongodb to working with my csv in the mongo command line. You definitely saved me 4 hours!!! 😁

thank you thank you thank youu a lot!! I tried everything but your video was the most helpful

Thank you so much. Even my instructor failed to show us how to do this.

Thank you so much! I've been trying to figure how to get the mongoimport tool. It mentions in the documentation that it no longer comes with mongodb, but it doesn't mention how to get it. Much appreciated again.

Not the hero we deserve but the hero we need

Yes ...the tools for database tools It took me 2 hrs and nothing Thank you for sharing

Thanks man!!! I’m doing some homework and been trying to figure this out for a long time as well. Your video was straight to the point helpful! Great job.

Thanks for the share, tip: write CMD in the address bar folder you are, that will open a cmd windows in that folder

your 4 hours work paid of my 6 hours! thanks man!

Thank you! I have been struggling with this thing, not 4 hours but 4 days! again thank you

Thanks a lot for the video! 👍🙏 One side note, you can save the path to the mongo executables as PATH environment variable. That will save some time by eliminating the need to copy the entire path to the bin and doing a cd before running mongo.exe or other executables present in bin directory.

thanks a lot man, been suffering for 3,4 hours trying to find the exact same thing .

Awesome man🔥it was very useful to me, respect your hardwork bro👍🏼

Cool video dude! Been trying to figure this out using MongoDB Atlas for the last few days

Thanks man for saving my 3 hours and 30 minutes

You are awesome! You saved my 3 hours and 53 mins

Thank you soooo much!!! super helpful. I spent 3 hours and finally...

Thanks a lot... i was struggling for two hours!

Thanks a lot, man!! I was trying to figure it out from last 3 hours .

Instead of having the csv file in the bin, you can put the full file path leading to the file after the "--file" and it works.

Why didn't you use the 'Compass' tool to import the .csv file. It's easier. I just imported 32,000 documents in my collection. You are a cool guy and I love your presentation way. Also, I learned a new way to import .csv in the MongoDB database collection via 'Command Prompt'. Thank you :)

Thankyou very much, you just saved me hours on this for a University project.

Thanks so much! Concise and exact explanation.

Thank you so much for this! Great job! So helpful and clear and I'm even using a mac and your clarity made it easy to understand as to how it applied to the mac environment.

Hi Nathan watched your video on aggregate functions in SQL and was super useful. Can you make more SQL videos?

Yes, It really helped me. Thanks for making this video.

Hi, your video was really helpful for me,thanks man!One question I would like to ask,I have a requirement of importing multiple csv files into mongdb,for that do I really need to write query for each csv file,or there is a way by which I can do it all at once?

Good video, clear and concise. Thank you!

Thanks alot for this very very helpful video . You saved our time and peace.

Great job sir....Awesome...fabulous

Thanks a ton, searching this info for long time. Great that u included right from downloading the zip.. 🙌

Had same issue, thank you so much!

Thank you for making this tutorial. I was about to bust a vein because i couldn't figure out how to import data from local to mongo atlas

U have made my life easier bro :)

you are a damn life saver. i gave you a like, subscribe and notification turn on. thank you good sir!

Hi! How did you manage to have an excel with values separated but tabs (or let's say heach value on its own cell) and still, even the extension of the file is indeed .csv, and work properly. I do the exact thing an the items get saved as {name,surname: john dohner}. Thanks!

Thank you....looking for this...great job

Thank you so much. So straight forward and save time

you are godman thankyou for saving my time😌

Thanks a lot probably saved me quite some time

thanks for sharing this - really helpful!

Thanks a lot bro it did helped me👍

감사합니다. 저한테 꼭 필요한 영상이었어요 !

not sure if this is a mongodb version 6.0 but when I type the command mongoimport, I got "'mongoimport' is not recognized as a internal or external command, operable program or batch file". How do I fix it??

You are a live saver . Thanks a lot ...

Thank you for the help sir.

Thank you so much I wasted my whole day trying to figuring out whats wrong with my installation ..! I think this is new update

Great video thank you so much!

Muchas gracias!!! muy buen video

Great Job, Thanks so much!

An lazy method without copying anything, and don't dealing with paths would be to use the MongoDB Compass which should be directly installed with MognoDB. Import tools etc, are already included. Only be sure MongoDB ist started, and then create a new database and add the data via new collection.

Thank You. It helped a lot.

THANK YOU YOU LOVELY MAN!

finally i found the solution, thanks a lot ♥

Tysm, but smh I'm getting E11000 duplicate key error collection {id : null} How should I pass id? Isn't it something mongo takes care of by itself?

Thank you for help my homework ;)

I need to move data from Hive to Mongo DB. Can I use import at MongoDB? Also, can I schedule task for importing data from Hive into MongoDB

Thanks alot man😁✌️

thanks but how we can use this with Mongodb Atlas , I can connect it but can't send any files TT

Thank you, man!

Thank you for this video

Thank youu so much so helpfuul

Is there a way to upload an object or an array of objects from csv to mongodb ?

Not sure why but my Mongo download already had the import exe within. Finding the mongodb msi link was frustrating for me because with firefox mongo's website didn't have a link to the msi but was there when I used google chrome.

Thanks for the video! Now, how do I upload this to my Atlas? hahahahah

Everything seemed to work fine at the beginning, but I didn't get the mongo.exe file. So still struggling...

How to add multiple excel columns into a field as array?

cheers buddy you're legend

Thanks alot, its amazing

it was really helpful thanks I spend more than you

Mine is still saying mongoimport is not recognized.

Thanks a lot bro

Excelent thanks!!!

¡Muchas gracias!

sir can i know how to import csv file in mongosh

how to import file from different path? Is this possible?

THANK YOUUUU

thank you so much

thanks man :)

you are amazing

Thank you

wonderful

Man u saved my ass !!!!

mongoimport not available on v5

I can't believe I just had to download the MongoDB Database Tools...

Super

Im trying 4hours and still #headache

It's called a collection of documents because it's not tabular... Simple.

thanks

Funny, this is super easy in a Unix environment. Figures it sucks in Windows.

Collection means table for normal people 😂😂😂

Hi for those who are trying with version 6.0.X i had to do this command to make it work : mongoimport --db your_db_name --collection your_collection_name --drop --type csv --headerline --file your_csv_file.csv

Very informative video. Thank you. PS Subscribed! {2021-06-25} - {2022-10-17}

Thanks a bunch! Clear and Easy to understand

you have been so helpful, thank you

thank you