Export mongodb collection data to csv file in node js

Question

I have created a mongodb collection in mongolab and want to print all documents in that collecton. I have mongolab and the url of mongolab to get connected with the collection is -

mongodb://user:[email protected]:41248/new

The sample document structure is -

{
    "_id": "9759572745-Sing",

   "details": {
    "Gender": "M",
    "PreTrainingStatus": "Fresher",
    "Religion": "Hindu",
    "attendanceInPercentage": "",
    "batchHolders": {
        "AssessmentDate": "Thu Jul 16 2015",
        "CourseFee": "7500",
        "isEditable": false
    },
    "batchID": "282726",
    "eid": "",
    "whereDidYouHearAboutStar": "---Select---",
    "skillInstructorOrTrainerName": "282726",
    "specificGovtInstitutetieups": "---Select---",
    "isSelected": false,
    "isEditable": false
},
"addedOnMs": 1439455766000,
"submittedOnMs": 1439454813000,
"latitude": "27.409566879272",
"longitude": "77.69295501709",
"locationName": "Uttar Pradesh 281006,null"
}

I want to Print it and all nested properties to be displayed in a column. But I am not able to do so, Please help.

Thank you (In Advance), Dia

Please tell me you just did not post your account credentials to StackOverflow. You need to change those quickly. — Blakes Seven
– Blakes Seven, Commented Aug 31, 2015 at 9:19

Manoj Khatri · Accepted Answer · 2018-11-01 06:39:26Z

Implementing json2csv library for exporting data to csv file on nodejs

Example

const json2csv = require('json2csv').parse;

//For unique file name
const dateTime = new Date().toISOString().slice(-24).replace(/\D/g, 
'').slice(0, 14); 

const filePath = path.join(__dirname, "../../../", "public", "exports", "csv-" + dateTime + ".csv");

let csv; 

const student = await req.db.collection('Student').find({}).toArray();

// Logging student
// [{id:1,name:"John",country:"USA"},{id:1,name:"Ronny",country:"Germany"}]

const fields = ['id','name','country'];

 try {
        csv = json2csv(booking_info, {fields});
    } catch (err) {
        return res.status(500).json({err});
    }

 fs.writeFile(filePath, csv, function (err) {
        if (err) {
            return res.json(err).status(500);
        }
        else {
            setTimeout(function () {
                fs.unlink(filePath, function (err) { // delete this file after 30 seconds
                if (err) {
                    console.error(err);
                }
                console.log('File has been Deleted');
            });

        }, 30000);
            res.download(filePath);
        }
    })

Tushar Gupta - curioustushar · Accepted Answer · 2017-05-24 02:40:39Z

5

You can use https://www.npmjs.com/package/json2csv

Set nested option value to true

And Also Specify fields that you want from JSON. For nested document you can specify like this details.Gender

edited May 24, 2017 at 2:40

Tushar Gupta - curioustushar

57.2k24 gold badges106 silver badges110 bronze badges

answered Aug 31, 2015 at 9:19

Hiren S.

2,82017 silver badges25 bronze badges

1 Comment

Hiren S. Over a year ago

@narainsagar Yes. Worked with 1000000 records.

Collectives™ on Stack Overflow

Export mongodb collection data to csv file in node js

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related