Sometimes, you need to import data from files, CSV, JSON, or other types, to MongoDB collections, here are some tools you can use. All supports Atlas.
1. mongoimport, https://www.mongodb.com/docs/database-tools/mongoimport/
mongoimport is a powerful command-line tool for importing data from JSON, CSV, and TSV files into MongoDB collections.
Import JSON
mongoimport --host=mongodb1.example.net --port=37017 --username=user --collection=contacts --db=marketing --file=/opt/backups/mdb1-examplenet.json
Import CSV,TSV
mongoimport --db=users --collection=contacts --type=csv --headerline --file=/opt/backups/contacts.csv
2. MongoDB Compass, https://www.mongodb.com/docs/compass/current/
MongoDB Compass is a powerful GUI for querying, aggregating, and analyzing your MongoDB data in a visual environment.
You can use MongoDB Compass to import and export data to and from collections. Compass supports import and export for both JSON and CSV files.
for details: https://www.mongodb.com/docs/compass/current/import-export/
3. WithData FileToMongo, https://withdata.com/file-to-mongo/
FileToMongo is a data conversion software that helps you to import File (TXT, CSV, TSV, EXCEL, JSON, XML, SQL, INI, RDF, LOG) data to MongoDB. Support all MongoDB deployment types: standalone, replica set, sharded cluster, and MongoDB Atlas.
For details:
Import CSV file to MongoDB collection, http://www.withdata.com/blog/filetomongo/import-csv-file-to-mongodb-collection.html
Import JSON file to MongoDB collection, http://www.withdata.com/blog/filetomongo/import-json-file-to-mongodb-collection.html
more: TSV , Excel, XML, SQL, TXT (“|” pipe delimited text), TXT (“;” semicolon delimited text)
