How to write into a csv with multiple rows and columns

Question

Now I have several JSON in my mongodb, such as:

{
   title: "title_1",
   content: "content_1",
   author: "author_1"
}

And I want to write these data into a csv file with the format below:

title    content     author
title_1  content_1   author_1
title_2  content_2   author_2
...

I used the node-csv-parser module. But it always write in only the first column in the csv file, such as:

title                          content          author
title_1,content_1,author_1
title_1,content_1,author_2
...

What should I do to achieve my aim? Please show me some examples. Any help would be greatly appreciated!

generalhenry · Accepted Answer · 2013-04-19 10:15:48Z

5

convert to nested arrays, join.

var array = [
  {
    title: "title_1",
    content: "content_1",
    author: "author_1"
  },
  {
    title: "title_1",
    content: "content_1",
    author: "author_2"
  }
];
var keys = Object.keys(array[0]);
var csv = [keys.join('\t')];
array.forEach(function (data) {
  var row = [];
  keys.forEach(function (key) {
    row.push(data[key]);
  });
  csv.push(row.join('\t'));
});
csv = csv.join('\n');

output:

title   content author
title_1 content_1   author_1
title_1 content_1   author_2

edited Apr 19, 2013 at 10:15

answered Apr 19, 2013 at 10:08

generalhenry

17.3k4 gold badges51 silver badges63 bronze badges

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

4 Comments

EpsonZhao Over a year ago

And then? What should I do to write it into multiple columns in a csv file?

generalhenry Over a year ago

do, you mean all tab delimited? I adjusted my example to use tabs.

EpsonZhao Over a year ago

What module do you use? I use the node-csv-parser module, but the tab doesn't work.

EpsonZhao Over a year ago

Oh! I got it! It's the difference between operating systems. The csv file displays one column in ubuntu, and displays multiple columns in windows.

Hariharan · Accepted Answer · 2013-04-19 10:07:11Z

0

please refer below link to generate your json or csv vice-versa

http://www.cparker15.com/code/utilities/csv-to-json/

I hope this will be useful to you.

Thanks.

answered Apr 19, 2013 at 10:07

Hariharan

3,2914 gold badges22 silver badges31 bronze badges

Collectives™ on Stack Overflow

How to write into a csv with multiple rows and columns

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related