How export a specific query in mongo to csv?

mongodb csv robo3t
jhonny lopez picture jhonny lopez · Aug 10, 2015 · Viewed 20.8k times · Source

I'm am searching for either on how to export a query result from mongo to CVS or excel, or how to export results in robomongo. I found mongoexport but I think that only can export a collection with some simple constraints.

This is my query:

 db.getCollection('user').find({ "coins": { $elemMatch: { "id":"30","amount":0} }  })

Answer

Jay G picture Jay G · Aug 11, 2015

For MongoDB 3.0+, you can specify the query into mongoexport using -q and --type options:

mongoexport -d test -c user -q '{ coins: { $elemMatch: { "id":"30","amount":0}}}' --type=csv --out exportdir/myRecords.json

For earlier versions, use --csv option with the header fields:

mongoexport -d test -c user -q '{ coins: { $elemMatch: { "id":"30","amount":0}}}' --csv -f first_name,last_name,title --out exportdir/myRecords.json

Related questions

How to use mongoimport to import csv

Trying to import a CSV with contact information: Name,Address,City,State,ZIP Jane Doe,123 Main St,Whereverville,CA,90210 John Doe,555 Broadway Ave,New York,NY,10010 Running this doesn't seem to add any documents to the database: $ mongoimport -d mydb …

Read More
How to export collection to CSV in MongoDB?

How do you export all the records in a MongoDB collection to a .csv file? mongoexport --host localhost --db dbname --collection name --type=csv > test.csv This asks me to specify name of the fields I need to export. …

Read More
I need to call mongoexport remotely and get the result from node.js

I'm not sure how to go about this, I need to export a mongodb collection as an .csv. Calling mongoexport with spawn.child_process in node will accomplish this but my mongodb server and node server are currently on separate …

Read More