Export MongoDB query to TSV file

by

Want to export MongoDB query results to TSV file?

Using MongoToFile, a native GUI tool, you can export MongoDB query results to TSV 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 TSV file - connect to mongodb

Click “Export From Query” at task dialog.

export MongoDB query results to TSV file - task window

Select “TSV” file type.

export MongoDB query results to TSV file - select type

1. Run a MongoDB query.

convert MongoDB query results to TSV file - run query

2. Set TSV options.

extract MongoDB query results to TSV file - config TSV file

3. Summary.

dump MongoDB query results to TSV file - summary

4. Export MongoDB query results to TSV file.

export MongoDB query results to TSV file - convert file

After exporting, you can view output TSV file.

export MongoDB query result to TSV file - view TSV file

Save/load session

You can save/load session to run “MongoDB query result to TSV file” conversion repeatly.

1.Save Session.

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

export MongoDB query to TSV file - save session

click “OK” button.

2.Load Session.

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

export MongoDB query to TSV file - load session

then show the wizard form, click a few “Next” to export MongoDB query result to TSV file.

export MongoDB query to TSV file - start session

Run in command line

You can run “MongoDB query result to TSV file” conversion in command line.

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

export MongoDB query to TSV file - save session

The “Save & Make Batch File” form shows.

export MongoDB query to TSV 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.ulq" logfile="C:\Users\pansh\Documents\test.log"

You can run this batch file in command line.

Run as scheduled task

You can run “MongoDB query result to TSV 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.

Export MongoDB query to TSV file - create batch file

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

Export MongoDB query to TSV file - scheduled task application

Export MongoDB query to TSV file - scheduled task name

Export MongoDB query to TSV file - scheduled task time

Export MongoDB query to TSV file - scheduled task user

Export MongoDB query to TSV 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