Import Excel to MongoDB collection

by

Want to import data from Excel file to MongoDB collection?

Try Withdata FileToMongo, a Excel to MongoDB converter for Windows, MacOS, and Linux, Import Excel to MongoDB, Easy and Fast.

Download Withdata FileToMongo Download FileToMongo

Import Excel data To MongoDB

Login to MongoDB -> Choose Excel file -> Set MongoDB collection options -> Import Excel to MongoDB

Start FileToMongo, connect to MongoDB.

Import Excel file data To MongoDB collection - connect to mongodb

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

Import Excel 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.

Import Data From Excel File To MongoDB collection - view data

Import Excel to MongoDB in command line

Save “Excel to MongoDB” session, then you can:

Set scheduled tasks for 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 for “Excel to MongoDB” conversion.
  2. Set scheduled task for “Excel to MongoDB” conversion.

FAQ


More about Withdata FileToMongoExcel to MongoDB Converter

See Video: Import EXCEL file to MongoDB collection

See also: