How to convert JSON to CSV format and store in a variable

by

A more elegant way to convert json to csv is to use the map function without any framework:

var json = json3.items
var fields = Object.keys(json[0])
var replacer = function(key, value) { return value === null ? '' : value } 
var csv = json.map(function(row){
  return fields.map(function(fieldName){
    return JSON.stringify(row[fieldName], replacer)
  }).join(',')
})
csv.unshift(fields.join(',')) // add header column
 csv = csv.join('\r\n');
console.log(csv)

Output:

title,description,link,timestamp,image,embed,language,user,user_image,user_link,user_id,geo,source,favicon,type,domain,id
"Apple iPhone 4S Sale Cancelled in Beijing Amid Chaos (Design You Trust)","Advertise here with BSA Apple cancelled its scheduled sale of iPhone 4S in one of its stores in China’s capital Beijing on January 13. Crowds outside the store in the Sanlitun district were waiting on queues overnight. There were incidents of scuffle between shoppers and the store’s security staff when shoppers, hundreds of them, were told that the sales [...]Source : Design You TrustExplore : iPhone, iPhone 4, Phone","http://wik.io/info/US/309201303","1326439500","","","","","","","","","wikio","http://wikio.com/favicon.ico","blogs","wik.io","2388575404943858468"
"Apple to halt sales of iPhone 4S in China (Fame Dubai Blog)","SHANGHAI – Apple Inc said on Friday it will stop selling its latest iPhone in its retail stores in Beijing and Shanghai to ensure the safety of its customers and employees. Go to SourceSource : Fame Dubai BlogExplore : iPhone, iPhone 4, Phone","http://wik.io/info/US/309198933","1326439320","","","","","","","","","wikio","http://wikio.com/favicon.ico","blogs","wik.io","16209851193593872066"

Update ES6 (2016)

Use this less dense syntax and also JSON.stringify to add quotes to strings while keeping numbers unquoted:

const items = json3.items
const replacer = (key, value) => value === null ? '' : value // specify how you want to handle null values here
const header = Object.keys(items[0])
const csv = [
  header.join(','), // header row first
  ...items.map(row => header.map(fieldName => JSON.stringify(row[fieldName], replacer)).join(','))
].join('\r\n')

console.log(csv)

More Related Contents:

  1. How to convert CSV to JSON in Node.js
  2. Converting JSON object to CSV format in JavaScript
  3. How to change data php to javascript json [closed]
  4. how to parse json array
  5. Why does Google prepend while(1); to their JSON responses?
  6. jQuery AJAX cross domain
  7. Example JavaScript code to parse CSV data
  8. I keep getting “Uncaught SyntaxError: Unexpected token o”
  9. Unable to access JSON property with “-” dash
  10. How to check if a string is a valid JSON string?
  11. How to get JSON from URL in JavaScript?
  12. JSON find in JavaScript
  13. HTML/Javascript: how to access JSON data loaded in a script tag with src set
  14. Converting json results to a date [duplicate]
  15. What’s the difference between Javascript Object and JSON object
  16. fetch() unexpected end of input
  17. Check if a key exists inside a JSON object
  18. When to prefer JSON over XML?
  19. Object copy using Spread operator actually shallow or deep?
  20. Loop through JSON object List
  21. Iterating through/Parsing JSON Object via JavaScript
  22. sort json object in javascript
  23. jQuery AJAX Call to PHP Script with JSON Return
  24. console.log(result) prints [object Object]. How do I get result.name? [duplicate]
  25. Trying to load local JSON file to show data in a html page using JQuery
  26. Uncaught TypeError: data.push is not a function
  27. Count console.log objects
  28. JavaScript/JSON: Get unknown property of an object
  29. how to convert xml to json using jquery
  30. How to return an array from an AJAX call?

Leave a Comment