Withdata Software

3 ways to export MongoDB data to files (CSV, TSV, JSON) without coding

Sometimes, you need to export MongoDB data to files, CSV, JSON, or other types, here are some tools you can use.

1. mongoexport

https://www.mongodb.com/docs/database-tools/mongoexport/

mongoexport is a command-line tool that produces a JSON or CSV export of data stored in a MongoDB instance.

MongoDB Export JSON

mongoexport –host=”mongodb0.example.com:27017″ –collection=events –db=reporting –out=events.json

MongoDB Export CSV

mongoexport –db=users –collection=contacts –type=csv –fieldFile=fields.txt –out=/opt/backups/contacts.csv

2. MongoDB Compass

https://www.mongodb.com/docs/compass/current/

MongoDB Compass is a powerful GUI for querying, aggregating, and analyzing your MongoDB data in a visual environment.
You can use MongoDB Compass to import and export data to and from collections. Compass supports import and export for both JSON and CSV files.

for details: https://www.mongodb.com/docs/compass/current/import-export/

3. WithData MongoToFile

https://withdata.com/mongo-to-file/

MongoToFile is a data conversion software that helps you to export MongoDB database data to CSV (TXT), SQL, JSON, XML, html, and Excel. Support all MongoDB deployment types: standalone, replica set, sharded cluster, and MongoDB Atlas.

For details:

MongoDB Export database to CSV files

https://www.withdata.com/blog/mongotofile/batch-export-mongodb-collections-to-csv-files.html

MongoDB Export database to JSON files

https://www.withdata.com/blog/mongotofile/batch-export-mongodb-collections-to-json-files.html

more:
MongoDB to TSV
MongoDB to Excel
MongoDB to XML
MongoDB to SQL
MongoDB to TXT (“|” pipe delimited text)
MongoDB to TXT (“;” semicolon delimited text)