Exporting data from MongoDB is a common requirement for sharing data with external applications or performing data analysis using different tools. MongoDB provides a command-line tool called mongoexport to facilitate this process.
In this article, We will learn about How to Export data from MongoDB with the help of various examples and so on.
Exporting Data Using mongoexport
- MongoDB allows us to export its data into other file formats like JSON or CSV so that the data can be used externally by other applications.
- So, to export data from the MongoDB database, MongoDB provides a command-line tool known as mongoexport.
- Using this tool we can export data of a collection in JSON or CSV(comma-separated value) format.
- We can also use features like limit and sort on a collection while exporting the data.
Note: mongoexport does not run in the mongo shell. So, when we use mongoexport tool we have to exit from the Mongo shell.
Exporting data from MongoDB is essential for data backup and migration. To learn how to manage data export and handle large datasets in full-stack applications, the Full Stack Development with Node JS course provides detailed lessons on data management in MongoDB
Syntax:
For exporting data in JSON format
mongoexport --db database_name --collection collection_name --out path_or_name_of_the_file
For exporting data in CSV format
mongoexport --db database_name --collection collection_name --type=csv --fields fields_names --out path_or_name_of_the_file
Important Points:
- Here, the out command specifies the directory and the file in which the exported data is to be stored. In case we don’t use –out the file gets created at path where we are at the time of running cmd.
- If the specified file is not created then mongoexport tool will automatically create a file and store data in it.
- If the mongoexport tool is not present in your system then you can install it from here.
- The mongoexport tool also provides options. Some of the commonly used options are:
| Option |
Description
|
| –help |
It will return the information about option and the use of mongoexport |
| –version |
It will return the version of mongoexport |
| –db |
It will specify the name of the database in which mongoexport will run. |
| –collection |
It will specify the collection to export. |
| –fields |
It will specify the fields that will include in the export. If you are specifying multiple fields the use comma in between them. E.g. –fields name, class |
| –type |
It will specify the file type to export. For JSON format use json and for CSV format use csv. |
| –out |
It will specify a file in which the data is going to store. |
| –skip |
Using this option you can control from where mongoexport starts exporting files. |
| –sort |
Using this option you can sort the exporting data. |
| –limit |
Using this option you can limit the number of documents to export. |
Examples of How to Export Data from MongoDB
In the following examples, we are working with:
Database: GeeksforGeeks
Collection: students
Documents: five documents that contain the details of the students in the form of field-value pairs.
Output:
Example 1: Exporting the whole collection in JSON format
In this example, we are going to export all the documents present in the student collection to a JSON file(named as exportstudents.json) using mongoexport tool.
mongoexport --db GeeksForGeeks --collection students --out C:\Users\Darksider\exportstudents.json
So, here we export all the 5 documents present in the student collection to a JSON file.
Output:
Example 2: Exporting Only 2 Records using Limit
In this example, we are going to export only 2 documents from the student collection to a JSON file(named as studentslim.json) using mongoexport tool.
mongoexport --db GeeksForGeeks --collection students --limit 2 --out C:\Users\Darksider\studentslim.json
So, here we only export 2 documents from the student collection by setting up the value of –limit to 2.
Output:
Example 3: Exporting the Whole Collection in CSV Format
In this example, we are going to export all the documents present in the student collection to a CSV file(named as students.csv) using mongoexport tool.
mongoexport --db GeeksForGeeks --collection students --type=csv --fields name,age --out C:\Users\Darksider\students.csv
Output:
Conclusion
Exporting data from MongoDB using the mongoexport tool is a straightforward process that can be customized with various options to fit specific requirements. Whether you need JSON or CSV formats, mongoexport provides the flexibility to export data efficiently, making it accessible for use in other applications or for further analysis.
FAQs
How do I export my MongoDB database?
You can export your MongoDB database using the mongoexport tool. This command-line tool allows you to export data from a collection in either JSON or CSV format. For example, to export a collection to a CSV file, use:mongoexport –db yourDatabase –collection yourCollection –type=csv –fields field1,field2 –out yourFile.csv
How to get data out of MongoDB?
To get data out of MongoDB, you can use the mongoexport tool for exporting data in JSON or CSV formats. Additionally, you can retrieve data programmatically using queries in the MongoDB shell or drivers for various programming languages (e.g., Python, Node.js) to extract data in a structured format.