Want to batch import data from Excel files to MongoDB collections?
Try Withdata FileToMongo, a Excel to MongoDB converter for Windows, MacOS, and Linux, Bulk import Excel to MongoDB, Easy 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:
- Save session and create .bat (Windows) or .sh (Linux/macOS) file for “Excel to MongoDB” conversion.
- Set scheduled task for “Excel to MongoDB” conversion.
FAQ
More about Withdata FileToMongo – Excel to MongoDB Converter
Download Withdata FileToMongo
See Video: Batch import EXCEL files to MongoDB collections
See also:
