How to save csv data into .csv file in nodejs?

Question

This is my "app.js" file.

const { convertArrayToCSV } = require('convert-array-to-csv');
const converter = require('convert-array-to-csv');
const fs = require('fs')
const csv = require('csv-parser')
const randomWords = require('random-words')
const header = ['number', 'first', 'last', 'handle'];

const dataArrays = [
[1, 'Mark', 'Otto', '@mdo'],
[2, 'Jacob', 'Thornton', '@fat'],
[3, 'Larry', 'the Bird', '@twitter'],
];
const val = convertArrayToCSV(dataArrays, {
header,
separator: ','
});
console.log(val)

output:

number,first,last,handle
1,Mark,Otto,@mdo  
2,Jacob,Thornton,@fat
3,Larry,the Bird,@twitter

I want to save this "Val" as a .csv file on my device. How can I do that? Please help. I am stuck here for the last 4 hours.

@Mujahidaul Islam as your convertArrayToCSV results in an string it should work — Aalexander
– Aalexander, Commented Jan 13, 2021 at 14:22
it could be that you need write access to the directory where you will create the file. You can check this in unix enviroment with ls -al Or do as path your home folder /home/newcsvfile.csv ~/newcsvfile.csv — Aalexander
– Aalexander, Commented Jan 13, 2021 at 14:24

marc_s · Accepted Answer · 2021-01-19 20:19:04Z

3

File System Library

To achieve this you can use the File System Library of NodeJs

Data can be: <string> | <Buffer> | <TypedArray> | <DataView> | <Object>

As option you can parse an encoding like

fs.writeFile('message.txt', 'Hello Node.js', 'utf8', callback);


const { convertArrayToCSV } = require('convert-array-to-csv');
const converter = require('convert-array-to-csv');
const fs = require('fs')
const csv = require('csv-parser')
const randomWords = require('random-words')
const header = ['number', 'first', 'last', 'handle'];

const dataArrays = [
[1, 'Mark', 'Otto', '@mdo'],
[2, 'Jacob', 'Thornton', '@fat'],
[3, 'Larry', 'the Bird', '@twitter'],
];
const val = convertArrayToCSV(dataArrays, {
header,
separator: ','
});
console.log(val)


fs.writeFile('<pathtodirectory>/message.csv', val, (err) => {
      if (err) throw err;
      console.log('The file has been saved!');
    });

edited Jan 19, 2021 at 20:19

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Jan 13, 2021 at 14:17

Aalexander

4,9843 gold badges13 silver badges37 bronze badges

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

3 Comments

Aalexander Over a year ago

You‘re welcome :) of you think this was helpful mark it as accepted, the button below up / down vote.

Mujahidul Islam Over a year ago

I don't enough reputation for voting. It needs a minimum of 15 reputations to vote.

Aalexander Over a year ago

Accepting is possible with any rep. You can choose one of your answers as helpful then other people see this helped solving the problem. Ist is the greyed out check below the up down button

Darth · Accepted Answer · 2021-01-13 14:16:54Z

2

const fs = require('fs')
const header = ['number', 'first', 'last', 'handle'];

const dataArrays = [
[1, 'Mark', 'Otto', '@mdo'],
[2, 'Jacob', 'Thornton', '@fat'],
[3, 'Larry', 'the Bird', '@twitter'],
];

const val = [header].concat(dataArrays).map(arr => arr.join(',')).join('\r\n');

fs.writeFile('filename.csv', val, err => {
  if(err) console.error(err);
  else console.log('Ok');
}););

answered Jan 13, 2021 at 14:16

Darth

1,64911 silver badges20 bronze badges

1 Comment

Mujahidul Islam Over a year ago

Thank's for your time and effort .

Collectives™ on Stack Overflow

How to save csv data into .csv file in nodejs?

2 Answers 2

File System Library

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

File System Library

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related