Want to batch import data from Excel files to MongoDB collections?
Using Withdata software FileToMongo, a MongoDB Excel importer for Windows, MacOS, and Linux, 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.
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.
Bulk import Excel to MongoDB in command line
Save “Excel to MongoDB” session, then you can:
- Bulk import Excel to MongoDB in Windows command line.
- Bulk import Excel to MongoDB in Linux command line.
- Bulk import Excel to MongoDB in macOS command line.
Set scheduled tasks for bulk importing Excel to MongoDB
You can schedule and automate this “Excel to MongoDB” conversion task by:
1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.
FAQ
Download FileToMongo
