How to export mongoDB data into a CSV format?

问题:

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?

回答1:

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

回答2:

If you already have the .bson file, in order to export to csv:

bsondump collection.bson > file.csv

回答3:

It's pretty easy with mongoDB compass, you just need to goto

Collection -> Export Collection -> Select Export data as JSON or CSV

and export the data.