Batch import Excel files to MongoDB collections without programming

by

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.

Download FileToMongo Download FileToMongo

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.

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

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

Batch Import EXCEL files data To MongoDB collections - task window

then show the wizard.

Select the “Excel” file type.

Batch Import Excel files data To MongoDB collections - select file type

1. Open a folder contains Excel files.

Batch Import Data From Excel Files To MongoDB collections - set Excel folder

2. Set Excel options.

Batch Import Data From Excel Files To MongoDB collections - config Excel file

3. List collesions, set “Import Type”.

Batch Load Data From Excel File To MongoDB collections - select table

4. Map files to collections.

Batch Load Data From Excel File To MongoDB collections - select table

5. Summary.

Batch Transfer Data From Excel Files To MongoDB collections - preview

6. Import Excel data to MongoDB collections.

Batch Copy Data From Excel Files To MongoDB collections - import data

After importing, you can view imported data.

Bulk Import Data From Excel Files To MongoDB collections - 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