JIYIK CN >

This MongoDB tutorial will show you how to export all MongoDB collections.

Most databases and language frameworks allow you to export data. This makes the data useful to other programs, applications, or languages ​​in various forms.

CSV, BSON, and JSON are the most common database file formats.

Using the mongoexport tool, MongoDB allows developers to accomplish this because the mongoexport tool does not work in the mongo shell; it must be executed outside of it. This is a system command line tool.

This tutorial will focus on how to export all collections in MongoDB to CSV (Comma Separated Values) and JSON file types. But let's first take a look at the mongoexport tool.

This article describes the following:

1. mongoexport CLI tool in MongoDB
2. Install the mongoexport CLI tool
3. Exporting a collection as JSON in MongoDB
4. Exporting a collection to CSV in MongoDB

mongoexport CLI tool in MongoDB

The mongoexport tool helps export data from a MongoDB instance into JSON or CSV file types. Since the release of MongoDB 4.4, the mongoexport tool has been shipped separately from the MongoDB server.

It uses its version control. The mongoexport CLI tool supports the following versions of MongoDB.

1. MongoDB 5.0
2. MongoDB 4.4
3. MongoDB 4.2
4. MongoDB 4.0

Let's start by setting up mongoexportthe tools. The MongoDB database toolkit includes the mongoexport tool.

Install the mongoexport CLI tool

You will follow the steps below to install mongoexport from the official MongoDB website.

• Visit the official download page for MongoDB.
• Click the Tools tab under the Choose the deployment type that's best for you heading.
• Scroll down and click the MongoDB Database Tools accordion.
• Under the Available Downloads form, the latest version of the Database Tools package is selected by default. Select the platform and the packages you require for your system.
• Allow the installation process to complete before using the mongoexport utility.

Exporting a collection as JSON in MongoDB

Let's first export all the collections in MongoDB using the mongoexport tool. Then, follow the instructions below to export the collections to a JSON file.

Assume we have a database called teams. We have a set of collections in this database called PremierLeague, LaLiga, SerieA and Ligue1 that we want to export.

We also assume that you have some documentation in place. You will use these details to walk through the examples.

Given below is its syntax.

mongoexport –db database_name –collection collection_name –out path_or_filename.json

1. The out flag we have added here represents the directory path with the file name appended at the end.
2. You can choose to have mongoexport create a file with that name in that destination, or leave it to mongoexport to create one itself with that file name in that destination.

mongoexportThe data is automatically created and added to the file.

Let us take an example so that you can easily follow the steps to export all collections in MongoDB.

1. Start your MongoDB server.
2. First go to your system terminal. Check if you are not using mongo shell.
3. To export all the collections in MongoDB from the database in JSON format, pass the following command:

mongoexport –db teams –collection PremierLeague LaLiga SerieA Ligue1 –out C:\Users\Random\teamsdata.json

You should now see a JSON file containing the data created in the target location.

Exporting a collection to CSV in MongoDB

Microsoft Excel normally handles CSV files. You will use the same database, teams.

To export a collection to CSV in MongoDB, follow the steps mentioned below.

1. Start your MongoDB server.
2. First go to your system terminal. Check if you are not using mongo shell.
3. To export a collection from a database to CSV in MongoDB, pass the following command:

   mongoexport –db teams –collection Ligue1 –type=csv –fields team,size,price –out C:\Users\Random\teamssdata.csv
   

   The user should now be able to view the CSV file containing the appropriate data created in the location provided.