mongoexport aggregate export to a csv file

mongodb mongoexport
Baconator507 picture Baconator507 · May 9, 2013 · Viewed 43k times · Source

I want to save the result from an aggregation into a csv file.

Using the mongo cmd line tool I can do this to get the results I want:

db.compras.aggregate({ $group : { _id : "$data.proponente", total : { $sum : "$price" } }}

How would I translate this into a mongoexport command that saves results into a csv?

Answer

Matt picture Matt · Sep 19, 2014

Slightly simpler option as of 2.6+ is to now add an $out step to your aggregate to put the results into a collection:

db.collection.aggregate( [ { aggregation steps... }, { $out : "results" } ] )

Then just use mongoexport as:

mongoexport -d database -c results -f field1,field2,etc --csv > results.csv

After that you might want to delete the temporary collection from the database so that it does not keep using unnecessary resources, and also to avoid confusion later, when you have forgotten why this collection exists in your database.

db.results.drop()

Related questions

mongoexport --fields --csv will only output the first field when working with subdocuments

Working: .\mongoexport.exe --db mydb --collection slideproof_user_event_date_count --csv --out events.csv --fields '_id,first_day' .\mongoexport.exe --db mydb --collection slideproof_user_event_date_count --out events.json --fields '_id._p,first_day' Not …

Read More
MongoDB - can't get data exported with mongoexport due to auth failed

I have a Mongo DB database and I trying to export couple "records" from one of the collections present in this database. Here is the command I am trying to use and the error I am getting: mongoexport --collection my_…

Read More
MongoDB - mongoexport all objects in nested array

I'm using MongoDB version 2.6.x. And I need to export documents from a specific collection. mongoexport is the tool which serves the need. However, I do not know how to export all the objects under a nested array. Below is …

Read More