Json to csv in Node Js

Question

I have a JSON data which want to download it as csv file. How to achieve this in node js? Does NodeJs has some predefined modules for this?

P.S. I also want to add some formatting such as adding Headers like MONTHLY REPORT etc. adding row colors etc.

See also these questions: [How to convert JSON array to CSV using Node.js?](https://stackoverflow.com/q/38244285/5764553), [node.js: Convert json array to csv](https://stackoverflow.com/q/27817645/5764553), and [Json to csv in node.js](https://stackoverflow.com/q/27481929/5764553). (Last one isn't as closely related.) — Andrew Myers, May 02 '18 at 12:15
I'm voting to close this question as off-topic because the OP shows no effort / attempt — d4nyll, May 02 '18 at 12:21
Some other questions: [Nested JSON to CSV format Node.js](https://stackoverflow.com/q/35245113/5764553) and [How to parse JSON object to CSV file using json2csv nodejs module](https://stackoverflow.com/q/20620771/5764553) — Andrew Myers, May 02 '18 at 12:22
Possible duplicate of [How to convert JSON array to CSV using Node.js?](https://stackoverflow.com/questions/38244285/how-to-convert-json-array-to-csv-using-node-js) — Andrew Myers, May 02 '18 at 12:42
By the way, I don't think that CSV can do row colors. It's pretty much a text-only format. The first line is usually where the headers are, but again, I don't think you can do any special formatting. — Andrew Myers, May 02 '18 at 12:50

Adeojo Emmanuel IMM · Answer 1 · 2018-05-02T15:58:44.237

1

Node.js json2csv module would work

Here are some code examples:

Install it through npm

npm install --save json2csv

Use it in your node.js app:

const json2csv = require('json2csv').parse;
const fields = ['field1', 'field2', 'field3'];
const opts = { fields };

try {
  const csv = json2csv(myData, opts);
  console.log(csv);
} catch (err) {
  console.error(err);
}

edited May 02 '18 at 15:58

answered May 02 '18 at 12:28

Adeojo Emmanuel IMM

2,104
1
19
28

score 0 · Answer 2 · edited Feb 14 '19 at 07:27

0

In this how we should group some particular field under one headings in csv is like:

      Usernames
Name1 | Name2 | Name3

edited Feb 14 '19 at 07:27

Partho63

3,117
2
21
39

answered Feb 14 '19 at 06:57

Abhishek Kumar

97
7

score -1 · Answer 3 · answered May 30 '20 at 22:37

I don't know about you guys, but i like small packages that just work as expected without a lot of extra configuration, try using jsonexport, works really well with objects, arrays, .. and its fast!

Install

npm i --save jsonexport

Usage

const jsonexport = require('jsonexport');

jsonexport({lang: 'Node.js', module: 'jsonexport'}, function(err, csv){
    if (err) return console.error(err);
    console.log(csv);
});

https://github.com/kauegimenes/jsonexport

Json to csv in Node Js

3 Answers3