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?, node.js: Convert json array to csv, and Json to csv in node.js. (Last one isn't as closely related.) — Andrew Myers
– Andrew Myers, Commented May 2, 2018 at 12:15
I'm voting to close this question as off-topic because the OP shows no effort / attempt — d4nyll
– d4nyll, Commented May 2, 2018 at 12:21
Some other questions: Nested JSON to CSV format Node.js and How to parse JSON object to CSV file using json2csv nodejs module — Andrew Myers
– Andrew Myers, Commented May 2, 2018 at 12:22
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
– Andrew Myers, Commented May 2, 2018 at 12:50

Professor · Accepted Answer · 2018-05-02 15:58:44Z

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 2, 2018 at 15:58

answered May 2, 2018 at 12:28

Professor

2,1701 gold badge21 silver badges29 bronze badges

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

Comments

Anna Billstrom · Accepted Answer · 2024-06-01 02:23:25Z

0

If you mean, how do you convert JSON to CSV, in Node JS:

Make sure to include a header, such as this, in csv:

      Usernames
Name1 | Name2 | Name3

edited Jun 1, 2024 at 2:23

Anna Billstrom

2,50226 silver badges33 bronze badges

answered Feb 14, 2019 at 6:57

Abhishek Kumar

971 silver badge8 bronze badges

1 Comment

Phix Over a year ago

This doesn't answer the question.

Kauê Gimenes · Accepted Answer · 2020-05-30 22:37:59Z

-2

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

answered May 30, 2020 at 22:37

Kauê Gimenes

1,2961 gold badge13 silver badges30 bronze badges

1 Comment

Phix Over a year ago

Self promotion generally isn't a good look without explaining how they can use it. What is the csv argument? How can the original poster use it?

Collectives™ on Stack Overflow

Json to csv in Node Js

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related