MongoDB Import, Export, and Database Tools

MongoDB•Permalink

Use mongoimport, mongoexport, bsondump, and GridFS tools for practical MongoDB data movement workflows.

View

Standard Detailed Compact

Export

Copy the compact sheet, download it, or print it.

Download

`D` dense toggle · `C` copy all

## Import and export data

Export a collection to JSON

↗#

mongoexport --uri="mongodb://localhost:27017/appdb" --collection=users --out=users.json

# Write documents to a JSON file.

Export selected fields to CSV

↗#

mongoexport --uri="mongodb://localhost:27017/appdb" --collection=users --type=csv --fields=name,email,created_at --out=users.csv

# Create a CSV export for spreadsheets or BI tools.

Import JSON data

↗#

mongoimport --uri="mongodb://localhost:27017/appdb" --collection=users --file=users.json --jsonArray

# Load JSON documents into a collection.

Import CSV data

↗#

mongoimport --uri="mongodb://localhost:27017/appdb" --collection=users --type=csv --headerline --file=users.csv

# Load CSV rows into a collection.

Convert BSON to JSON

↗#

bsondump dump/appdb/users.bson > users.json

# Inspect dump data as JSON.

## GridFS and files

List GridFS files

↗#

mongofiles --uri="mongodb://localhost:27017/appdb" list

# Show files stored in GridFS.

Upload a file to GridFS

↗#

mongofiles --uri="mongodb://localhost:27017/appdb" put report.pdf

# Store a local file in GridFS.

Download a GridFS file

↗#

mongofiles --uri="mongodb://localhost:27017/appdb" get report.pdf

# Retrieve a file from GridFS.

More in MongoDB

MongoDB Transactions and Change Streams

Use sessions, multi-document transactions, and change streams for modern event-driven and consistency-sensitive MongoDB applications.

MongoDB Backup, Restore, and Replica Set Workflows

Use mongodump, mongorestore, replica set commands, and diagnostic tools for operational MongoDB workflows.

MongoDB Users, Roles, and Administrative Commands

Create users, grant roles, inspect server status, and run the most common administrative commands in MongoDB.

MongoDB Indexes, Explain Plans, and Performance

Create indexes, inspect query plans, and troubleshoot common MongoDB query performance issues.

MongoDB Aggregation Pipeline Patterns

Group, project, sort, unwind, lookup, facet, and aggregate analytics data with MongoDB pipelines.

MongoDB Update Operators and Array Patterns

Use $set, $unset, $inc, $push, $addToSet, positional updates, and arrayFilters for real-world MongoDB mutations.

Recommended next

No recommendations yet.

Browse all sheets →