Convert CSV data into JSON format using Javascript

by

The below should work for you.

All credit to http://techslides.com/convert-csv-to-json-in-javascript 

//var csv is the CSV file with headers
function csvJSON(csv){

  var lines=csv.split("\n");

  var result = [];

  // NOTE: If your columns contain commas in their values, you'll need
  // to deal with those before doing the next step 
  // (you might convert them to &&& or something, then covert them back later)
  // jsfiddle showing the issue https://jsfiddle.net/
  var headers=lines[0].split(",");

  for(var i=1;i<lines.length;i++){

      var obj = {};
      var currentline=lines[i].split(",");

      for(var j=0;j<headers.length;j++){
          obj[headers[j]] = currentline[j];
      }

      result.push(obj);

  }

  //return result; //JavaScript object
  return JSON.stringify(result); //JSON
}

More Related Contents:

  1. jquery messagebox get from button click mvc4
  2. jQuery POST, Error 405 Method not allowed
  3. jQuery: How to traverse / Iterate over a list of object
  4. ASP.NET MVC Partial view ajax post?
  5. How do I check if an element is hidden in jQuery?
  6. How to display an chage photo option on mouse hover similar to linkedin using Javascript? [closed]
  7. Get palindrome length from string [closed]
  8. Graphical bar presentation using jquery [closed]
  9. Store Dropdown list old values and re populate them
  10. HTML Form Submit pass array to PHP [closed]
  11. Why does jQuery or a DOM method such as getElementById not find the element?
  12. How can I select an element by name with jQuery?
  13. jQuery disable/enable submit button
  14. jQuery click events firing multiple times
  15. Binding arrow keys in JS/jQuery
  16. variable === undefined vs. typeof variable === “undefined”
  17. jQuery object and DOM element
  18. Is there a way to return a list of all the image file names from a folder using only Javascript?
  19. How to get an AJAX get-request to wait for the page to be rendered before returning a response?
  20. Webhoster inserts a javascript which brokes my code how to remove it?
  21. jQuery.getScript alternative in native JavaScript
  22. Google MAP API v3: Center & Zoom on displayed markers
  23. How to stop an animated gif from looping
  24. Is there a ‘has focus’ in JavaScript (or jQuery)?
  25. How to prevent html/JavaScript code modification
  26. Animating Multiple Markers
  27. In Javascript, how do I determine if my current browser is Firefox on a computer vs everything else?
  28. javaScript: Can a comma occur after the last set of values in an array?
  29. How to add font types on Quill js with toolbar options?
  30. How can I reorder elements with JavaScript?

Leave a Comment