Skip to content

Instantly share code, notes, and snippets.

@alonextou
Created September 30, 2017 19:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save alonextou/d79962f6139aad08aeb132816c0551b3 to your computer and use it in GitHub Desktop.
Save alonextou/d79962f6139aad08aeb132816c0551b3 to your computer and use it in GitHub Desktop.
jsonToCsv
/*** README:
Run: npm install --save csv-write-stream
Have import.json in the same directory
Run: node index.js
Let cool for 2 seconds before serving export.csv
Set sendHeaders to false to remove headers from CSV
***/
var fs = require('fs')
var csvWriter = require('csv-write-stream')
console.log('Importing...')
var writer = csvWriter({
headers: [
"Full Name",
"Address",
"City",
"State",
"Zip",
"County",
"Phone"
],
sendHeaders: true
})
writer.pipe(fs.createWriteStream('export.csv'))
fs.readFile('./import.json', 'utf8', function (err, response) {
if (err) {
console.log(err)
}
var data = JSON.parse(response)
var count = 0
data.forEach(function(record) {
writer.write([
record.FN + ' ' + record.LN,
record.ADDR,
record.CITY,
record.ST,
record.ZIP,
record.COUNTY,
record.PHONE
])
count++
})
writer.end()
console.log('Imported ' + count + ' records.')
});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment