Export multiple MongoDB collections to 1 CSV file without programming

by

Want to export multiple MongoDB collections to 1 CSV file?

Using MongoToFile, a native GUI tool, you can export multiple MongoDB collections to a single CSV file 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.

Start MongoToFile, connect to MongoDB.

export MongoDB collection to CSV file - connect to mongodb

Click “Export Similar Collections” at task dialog.

Export multiple MongoDB collections to 1 CSV file - task window

Select “CSV” file type.

Export MongoDB collections to 1 CSV file - select type

1. Select MongoDB collections to export.

Extract multiple MongoDB collections to 1 CSV file - select collections

2. Set CSV options.

Batch dump multiple MongoDB collections to 1 CSV file - config CSV file

3. Summary.

Batch convert multiple MongoDB collections to 1 CSV file - summary

4. Export multiple MongoDB collections to one CSV file.

Export multiple MongoDB collections to 1 CSV file - convert file

After exporting, you can view output CSV file.

Bulk Export MongoDB collections to single CSV file - view CSV file

Save/load session

You can save/load session to run “MongoDB collections to single CSV file” conversion repeatly.

1.Save Session.

Click “Save Session” button, then enter a session file name.

Bulk Export MongoDB collections to single CSV file - save session

click “OK” button.

2.Load Session.

Click the “Open a Saved Session” in task window, select a session file.

Bulk Export MongoDB collections to single CSV file - load session

then show the wizard form, click a few “Next” to export MongoDB collections to single CSV file.

Bulk Export MongoDB collections to single CSV file - start session

Run in command line

You can run “MongoDB collections to single CSV file” conversion in command line.

When you save session, you can click “Save & Make Batch File”.

Bulk Export MongoDB collections to single CSV file - save session

The “Save & Make Batch File” form shows.

Bulk Export MongoDB collections to single CSV file - create batch file

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.uls" 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 single CSV file” 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.

Bulk Export MongoDB collections to single CSV file - create batch file

And then, with scheduled task wizard, step by step.

Bulk Export MongoDB collections to single CSV file - scheduled task application

Bulk Export MongoDB collections to single CSV file - scheduled task name

Bulk Export MongoDB collections to single CSV file - scheduled task time

Bulk Export MongoDB collections to single CSV file - scheduled task user

Bulk Export MongoDB collections to single CSV file - scheduled task information

You’ll see created task listed in scheduled task list.

scheduled task list

Download

Here you can download MongoToFile, and buy MongoToFile.

Download MongoToFile Download MongoToFile