Import Excel to MongoDB

Use Withdata FileToMongo as Excel to MongoDB Converter (Importer / Loader).

Works GREAT in 2025.

Support Windows, Linux, and macOS.

Support all MongoDB deployment types: standalone, replica set, sharded cluster, and MongoDB Atlas.

Can run in GUI mode, Step by Step, just a few mouse clicks.

  1. 1 to 1: Import Excel to MongoDB collection
  2. n to 1: Import multiple Excel files to a single MongoDB collection
  3. n to n: Batch import Excel files to MongoDB collections

Can run in CLI (Command Line Interface), for Scheduled Tasks and Streams, for Automation.





Import Excel to MongoDB in GUI



Start Withdata FileToMongo, connect to MongoDB.

connect to mongodb



Import Excel to MongoDB collection

Click "1 File To 1 Collection" at task dialog.

Import file data To MongoDB collection - task window

Select the "Excel" file type.

Import Excel file data To MongoDB collection - select file type

1. Open a Excel file.

Import Data From Excel File To MongoDB collection - open Excel file

The source Excel file like this:

import Excel file to MongoDB collection - source Excel file

2. Set MongoDB collection options.

Load Data From Excel File To MongoDB collection - set collection options

3. Preview data will be in MongoDB collection.

Transfer Data From Excel File To MongoDB collection - preview

4. Import Excel data to MongoDB collection.

Copy Data From Excel File To MongoDB collection - import data

After importing, you can view imported data in MongoDB collection.

view MongoDB data



Import multiple Excel files to a single MongoDB collection

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



Batch import Excel files to MongoDB collections

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.

view MongoDB data

Set scheduled tasks for importing Excel to MongoDB

After importing Excel to MongoDB in Command Line, then you can schedule and automate "Excel to MongoDB" conversion task by:

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for "Excel to MongoDB" conversion.
  2. Set scheduled task: On Linux/macOS, use Crontab. On Windows, use scheduled task.

FAQ

How long does it take to import Excel to MongoDB?

Is it safe to import Excel to MongoDB using FileToMongo?

Can I import Excel to MongoDB on Linux, Mac OS?

Can I import Excel to MongoDB in command line?

Can I batch import Excel files to MongoDB collections?

Can I import Excel to MongoDB without Microsoft Excel installed?