To use your aggregated data in other external tools, you can export your pipeline results from MongoDB Compass as a JSON or CSV file.
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.
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:
Default Extended JSON
A string format that avoids any loss of BSON type information. This is the default Compass setting.
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.
This format is not recommended for data integrity.
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.