Want to batch import data from Excel files to MongoDB collections?
Using Withdata software FileToMongo, a MongoDB Excel importer, you can bulk import data from Excel files to MongoDB collections easily and fast.
- Can run in GUI mode, Step by Step, just a few mouse clicks.
- Can run in Command line, for Scheduled Tasks and Streams.
- Support all MongoDB deployment types: standalone, replica set, sharded cluster, and MongoDB Atlas.
- Support Windows, Linux, macOS.
- Can work without Microsoft Excel installed.
Bulk import data from Excel files to MongoDB collections
Login to MongoDB -> Choose Excel files -> Set MongoDB collections. -> Import Excel files into MongoDB collections
Start FileToMongo, connect to MongoDB.
Click “N File To N Collection” at task dialog.
then show the wizard.
Select the “Excel” file type.
1. Open a folder contains Excel files.
2. Set Excel options.
3. List collesions, set “Import Type”.
4. Map files to collections.
5. Summary.
6. Import Excel data to MongoDB collections.
After importing, you can view imported data.
You can schedule and automate this ” Excel to MongoDB” conversion task by:
1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.