I'm looking for a very simple way to export data from mongoDB into a CSV. Most of the answers involve bash scripts… etc. Is there a simple mongoDB command that will just export the data into CSV?
Update:
As of mongo 3.0.6 --csv
is no longer supported and the new flag is --type=csv
, so the command would be
mongoexport --db users --collection contacts --type=csv --fieldFile fields.txt
Original answer:
This can be done from the command line using the mongo utility function mongoexport --csv
.
Alongside the --csv
the documentation states that you also need to use --fields
or specify a file with the fields in using --fieldFile
.
Have a look at the usage examples and see if they help, for example:
mongoexport --db users --collection contacts --csv --fieldFile fields.txt
If you already have the .bson file, in order to export to csv:
bsondump collection.bson > file.csv
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With