HOW TO WRITE CSV FILES IN NODEJS

NODE

(real quick examples)

LOAD REQUIRED MODULES - NPM INSTALL CSV-STRINGIFY const fs = require("fs"),           csv = require("csv-stringify");

ARRAY TO CSV FILE

01

DATA TO WRITE var data = [   ["Apple", "Banana"],   ["Cherry", "Durian"]  ];

CREATE CSV FILE csv.stringify(data, (e, o) =>   fs.writeFileSync("MY.CSV", o));

OBJECT TO CSV FILE

02

LOAD REQUIRED MODULES - NPM INSTALL CSV-STRINGIFY const fs = require("fs"),           csv = require("csv-stringify");

DATA TO WRITE var data = [   { a: "Doge", d: "Good Boy" },   { a: "Cate", d: "Evil" } ];

CREATE CSV FILE csv.stringify(data, {   header : true,   columns : { a : "Animal", d : "Description" } }, (e, o) => fs.writeFileSync("MY.CSV", o));

LOAD REQUIRED MODULES - NPM INSTALL CSV-STRINGIFY const fs = require("fs"),           csv = require("csv-stringify");

WRITE LINE BY LINE

03

DATA TO WRITE var data = [   ["Alpha", "Beta"], ["Charlie", "Delta"] ];

WRITE TO FILE ROW BY ROW for (r of data) {   csv.stringify([r], (e, o) =>     fs.appendFileSync("MY.CSV", o)); }