Want to batch export MongoDB collections to Excel files?
Using MongoToFile, a native GUI tool, you can batch export MongoDB collections to Excel files easily and fast, no need to program, just a few mouse clicks!
Support all MongoDB deployment types: standalone, replica set, sharded cluster, and MongoDB Atlas.
Support Windows, Linux, macOS.
Here’s how to.
Export
Please download and install MongoToFile, then run it.
Click “Export All Collections” at task dialog.
then show the wizard.
Select “Excel” file type.
1. Select MongoDB collections to export.
2. Set Excel options.
3. List collections to be exported.
4. Summary.
5. Batch export MongoDB collections to Excel files.
After exporting, you can view output Excel files.
Save/load session
You can save/load session to run “MongoDB collections to Excel files” conversion repeatly.
1.Save Session.
Click “Save Session” button, then enter a session file name.
click “OK” button.
2.Load Session.
Click the “Open a Saved Session” in task window, select a session file.
then show the wizard form, click a few “Next” to export MongoDB collections to Excel files.
Run in command line
You can run “MongoDB collections to Excel files” conversion in command line.
When you save session, you can click “Save & Make Batch File”.
The “Save & Make Batch File” form shows.
Click “OK” button, you’ll create a batch file, in Windows, like this:
C: cd "C:\Users\pansh\AppData\Local\Programs\MongoToFile" MongoToFile task="C:\Users\pansh\Documents\test.ula" logfile="C:\Users\pansh\Documents\test.log"
You can run this batch file in command line.
Run as scheduled task
You can run “MongoDB collections to Excel files” conversion automatically at specific time.
On Linux/macOS, you can use Crontab.
For macOS, How to Fix Cron Permission Issues in macOS.
On Windows, in “Save & Make Batch File” form, you can click “Create & Schedule Task” to set a scheduled task.
And then, with scheduled task wizard, step by step.
You’ll see created task listed in scheduled task list.
Download
Here you can download MongoToFile, and buy MongoToFile.