/ /

Create an Aggregation Pipeline

Docs Home

Tools

Compass

Create an Aggregation Pipeline

Docs Home

Tools

Compass

Create an Aggregation Pipeline

Export Aggregation Pipeline Results

To use your aggregated data in other external tools, you can export your pipeline results from MongoDB Compass as a JSON or CSV file.

About this Task

Avoid using CSV files exports to back up your data. CSV files may lose type information and are not suitable for backing up your data.

Steps

Click Export Data

In the aggregation pipeline pane, click the Export Data button to open the modal.

Choose the file type for your export

Under Export File Type, select either JSON or CSV. If you select JSON, your data is exported to the target file as an array of JSON objects.

(Optional) Choose an advanced JSON format option

If choose to export your data as a JSON file, you can expand the Advanced JSON Format drop-down menu and select from the following extended JSON formats:

JSON Format

Description

Sample Document

Default Extended JSON

A string format that avoids any loss of BSON type information. This is the default Compass setting.

{
  "fortyTwo" : 42,
  "oneHalf" : 0.5,
  "bignumber" : {
    "$numberLong" : "5000000000"
  }
}

Relaxed Extended JSON

A string format that emphasizes readability and interoperability at the expense of type preservation. That is, conversion from relaxed format to BSON can lose type information.

WARNING: This format is not recommended for data integrity.

{
  "fortyTwo" : 42,
  "oneHalf": 0.5,
  "bignumber" : 5000000000
}

Canonical Extended JSON

A string format that emphasizes type preservation at the expense of readability and interoperability. That is, conversion from canonical to BSON will generally preserve type information except in certain specific cases.

{
  "fortyTwo" : {
    "$numberInt" : "42"
  },
  "oneHalf" : {
    "$numberDouble" : "0.5"
  },
  "bignumber" : {
    "$numberLong" : "5000000000"
  }
}

Click Export

Specify export destination

In the new pop-up modal, enter a name for your export file, specify the file destination, and click Select to export your pipeline results.

Learn More

Back

Set Max Time MS

Builder Settings