How To Write Data Into CSV File In JavaScript
Last Updated : Mar 11, 2024
IN - JavaScript NodeJS | Written & Updated By - Amruta
In this article we will show you the solution of how to write data into csv file in JavaScript, in this we are going to use Node.js. the csvjson is a Node.js library to convert Simple CSV to JSON and JSON to CSV with stream support.
We have to create JSON file first to convert it to csv.
Step By Step Guide On How To Write Data Into CSV File In Javascript :-
At first, we have to create the JSON file first.
JSON file :
[
{
"name" : "peter" ,
"city" : "tokyo" ,
"gender" : "male",
"email": "peter@gmail.com"
},
{
"name" : "mary" ,
"city" : "london" ,
"gender" : "female",
"email": "mary@gmail.com"
},
{
"name" : "thomas" ,
"city" : "paris" ,
"gender" : "male",
"email": "thomas@gmail.com"
},
{
"name" : "john" ,
"city" : "new york" ,
"gender" : "male",
"email": "john@gmail.com"
}
]
Now install csvjson by npm install csvjson fs into the Terminal.
JavaScript file :
<!DOCTYPE html>
<html lang = " en " >
<head>
<meta charset = " UTF - 8" >
<meta http-equiv = " X-UA-Compatible " content = " IE=edge " >
<meta name = " viewport " content = " width = device-width , initial-scale = 1.0 " >
<title> how to write data into csv file in javascript </title>
<style>
body {
font-family : 'Lucida Sans', Verdana , sans-serif ;
}
h1 {
font-size : larger ;
font-weight : bolder ;
color : rgb(113, 221, 113) ;
text-align : center ;
}
h3 {
text-align : center ;
}
</style>
</head>
<body>
<h1> TALKERSCODE </h1>
<h3> how to write data into csv file in javascript </h3>
<script>
var csvjson = require('csvjson')
var fs = require('fs')
fs.readFile('./dataJ.json','utf-8',(err, fileContent)={
if(err){
console.log(err)
throw new Error(err)
}
//convert json to csv
const csvData = csvjson.toCSV(fileContent,{
headers : 'key'
});
fs.writeFile('./employeeData.csv',csvData,(err)={
if(err){
console.log(err)
throw new Error(err)
}
console.log("Converted successfully")
});
})
</script>
</body>
</html>
- First, we write <! DOCTYPE html> which we used as the instruction to the web browser about what version of HTML file is written in.
- Secondly, the <html> tag is used to indicate the beginning of an HTML document.
- As mentioned above, the <head> tag contains information about the web page. In this tag, a <title> tag is used which helps us to specify a webpage title.
- Both <head> and <title> tags are Paired tags. So, both have </head> and </title> ending tags respectively.
- Now create a < style > tag to add style to the HTML page.
- Thirdly, the <body> tag is used to define the webpage body. All the contents to show on the website are written here.
- <h1> tag used to add heading here.
- Now create a <script> tag to write the JavaScript file. And close it with </script> tag.
- First create a variable for csvjson to require the csvjson file and for fs to require the fs file
- .readFile() to read the json file
- Using toCSV () with the constant csvData.
- writeFile() to write the json to csv data.
- Console.log() to display the success message.
Conclusion :-
At last, here in conclusion, here we can say that with this article’s help, we know how to write data into CSV file using JavaScript.
I hope this article on how to write data into csv file in JavaScript helps you and the steps and method mentioned above are easy to follow and implement.
About Amruta
