node.js: Convert json array to csv

Question

I want to convert a json array of elements to csv in node.js. I've found some module doing that like json2csv or json-csv but they are not complete. For example json2csv only support a flat structure where fields are direct children of the json root and also the schema should be the same for all json objects.
In my case, I want that.
I suppose that i've a json array of objects like that:

[{
    "libelle" : "Projet 1",
    "beneficiaire" : "Mr Leroy",
    "nature" : "Diagnostics patrimoniaux",
    "phasage" : "GLOBAL",
    "budget": [
        {"status": "BROUILLON"}
    ],
    "status" : "BROUILLON"
},
{
    "libelle" : "Projet 2",
    "beneficiaire" : "Mr Leroy",
    "nature" : "Diagnostics patrimoniaux",
    "phasage" : "GLOBAL",
    "status" : "BROUILLON"
}]

and i want to convert it to csv like that:

"libelle","beneficiaire","nature","phasage","budget[0].status","status"
"Projet 1","Mr Leroy","Diagnostics patrimoniaux","GLOBAL","BROUILLON","BROUILLON"
"Projet 2","Mr Leroy","Diagnostics patrimoniaux","GLOBAL",,"BROUILLON"

I'm looking for a good and complete node module for doing that. If it doesn't exist, I will do it myself i think so.

stackoverflow.com/questions/16831250/… Look at this ling may help you — VostanAzatyan
– VostanAzatyan, Commented Jan 7, 2015 at 10:48
I've seen that and it's not what i want. Your link convert csv to json and me i want the reverse operation. — Djiby Thiaw
– Djiby Thiaw, Commented Jan 7, 2015 at 10:55

Kauê Gimenes · Accepted Answer · 2015-04-12 00:28:35Z

5

You can use the module jsonexport its pretty easy, check this sample:

Sample:

var jsonexport = require('jsonexport');

var contacts = [{
   name: 'Bob',
   lastname: 'Smith',
   family: {
       name: 'Peter',
       type: 'Father'
   }
},{
   name: 'James',
   lastname: 'David',
   family:{
       name: 'Julie',
       type: 'Mother'
   }
},{
   name: 'Robert',
   lastname: 'Miller',
   family: null,
   location: [1231,3214,4214]
},{
   name: 'David',
   lastname: 'Martin',
   nickname: 'dmartin'
}];

jsonexport(contacts,function(err, csv){
    if(err) return console.log(err);
    console.log(csv);
});

The ouput:

lastname;name;family.type;family.name;nickname;location
Smith;Bob;Father;Peter;;
David;James;Mother;Julie;;
Miller;Robert;;;;1231,3214,4214
Martin;David;;;dmartin;

Source: https://www.npmjs.com/package/jsonexport

answered Apr 12, 2015 at 0:28

Kauê Gimenes

1,2961 gold badge13 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jeff Tian Over a year ago

Can it be used in TypeScript environment?

Andrew Myers · Accepted Answer · 2018-05-02 13:05:05Z

0

Yes, there are a few npm modules, like fast-csv and ya-csv, that are very helpful for this.

var csv = require('ya-csv');
var fastcsv = require('fast-csv');

edited May 2, 2018 at 13:05

Andrew Myers

2,7865 gold badges36 silver badges42 bronze badges

answered Jan 7, 2015 at 12:31

PPB

3,1073 gold badges19 silver badges12 bronze badges

Collectives™ on Stack Overflow

node.js: Convert json array to csv

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related