How to export mongoDB data into a CSV format?
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