Batch import Excel files to 1 MongoDB collection without programming

by

Want to import data from multiple Excel files into 1 MongoDB collection?

Using Withdata software FileToMongo, a MongoDB Excel importer, you can import data from multiple Excel files into a single MongoDB collection in one go, 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.

Download FileToMongo Download FileToMongo

Import multiple Excel files into a single MongoDB collection

Login to MongoDB -> Choose Excel files -> Set MongoDB collection options. -> Import multiple Excel files into a single MongoDB collection

Start FileToMongo, connect to MongoDB.

Import multiple Excel files data to 1 MongoDB collection - connect to mongodb

Click “N File To 1 Collection” at task dialog.

Import multiple Excel files data To a single MongoDB collection - task window

Select the “Excel” file type.

Import multiple Excel files data To 1 MongoDB collection - select file type

1. Open a folder contains Excel files.

Import multiple Excel files to 1 MongoDB collection - set Excel folder

2. Set Excel options.

Import multiple Excel Files To 1 MongoDB collection - config Excel file

3. Set MongoDB collection options.

Load multiple EXCEL Files To 1 MongoDB collection - select table

4. Preveiw data will be in MongoDB.

Transfer multiple EXCEL Files To 1 MongoDB collection - preview

5. Import multiple Excel files to a single MongoDB collection.

Copy multiple EXCEL Files To 1 MongoDB collection - import data

After importing, you can view imported data in MongoDB.

Import multiple Excel Files To Single MongoDB Collection - view 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.

2) Set scheduled task.


More about FileToMongo – Excel to MongoDB Converter

Download FileToMongo for 30-day free trial Download FileToMongo