how to export mongodb database to csv code example

Example 1: mongoexport csv with query

mongoexport -d database -c collection --type=csv --out file.csv --fields name,fromHour,fromMin,toHour,toMin --query '{"_id":"56a647bff167043ad6ee49c0"}'

Example 2: import csv into mongodb

mongoimport --type csv -d database -c collection --headerline --drop index2020.csv

Example 3: how to export mongodb database to json

sudo mongoexport --db newdb -c restaurants --out newdbexport.json