How to read data From *.CSV file using javascript?

by

No need to write your own…

The jQuery-CSV library has a function called $.csv.toObjects(csv) that does the mapping automatically.

Note: The library is designed to handle any CSV data that is RFC 4180 compliant, including all of the nasty edge cases that most ‘simple’ solutions overlook.

Like @Blazemonger already stated, first you need to add line breaks to make the data valid CSV.

Using the following dataset:

heading1,heading2,heading3,heading4,heading5
value1_1,value2_1,value3_1,value4_1,value5_1
value1_2,value2_2,value3_2,value4_2,value5_2

Use the code:

var data = $.csv.toObjects(csv):

The output saved in ‘data’ will be:

[
  { heading1:"value1_1",heading2:"value2_1",heading3:"value3_1",heading4:"value4_1",heading5:"value5_1" } 
  { heading1:"value1_2",heading2:"value2_2",heading3:"value3_2",heading4:"value4_2",heading5:"value5_2" }
]

Note: Technically, the way you wrote the key-value mapping is invalid JavaScript. The objects containing the key-value pairs should be wrapped in brackets.

If you want to try it out for yourself, I suggest you take a look at the Basic Usage Demonstration under the ‘toObjects()’ tab.

Disclaimer: I’m the original author of jQuery-CSV.

Update:

Edited to use the dataset that the op provided and included a link to the demo where the data can be tested for validity.

Update2:

Due to the shuttering of Google Code. jquery-csv has moved to GitHub

More Related Contents:

  1. Remove element from JS injected HTML
  2. How can i create html automatic change page? [duplicate]
  3. Get file size, image width and height before upload
  4. convert base64 to image in javascript/jquery
  5. How to disable all div content
  6. Keyboard shortcuts with jQuery
  7. How to scroll to top of page with JavaScript/jQuery?
  8. Can jQuery .keypress() detect more than one key at the same time?
  9. Convert CSV data into JSON format using Javascript
  10. How to use jQuery to select a dropdown option?
  11. Write elements into a child iframe using Javascript or jQuery
  12. Does using $this instead of $(this) provide a performance enhancement?
  13. JavaScript Scale Text to Fit in Fixed Div
  14. AngularJS group check box validation
  15. Why “$().ready(handler)” is not recommended?
  16. When to prefer JSON over XML?
  17. How can I use JSON data to populate the options of a select box?
  18. How to use javascript conditionally like CSS3 media queries, orientation?
  19. RGB to HSV color in javascript? [closed]
  20. Alert for unsaved changes in form
  21. new Image(), how to know if image 100% loaded or not?
  22. Uploading File using Ajax in Asp.Net Core
  23. How to check if css value is supported by the browser?
  24. how to read json result in jquery?
  25. Trigger for span text/html on changed
  26. Best JavaScript Date Parser & Formatter? [closed]
  27. jQuery .on() method doesn’t see new elements
  28. Passing parameters to a JQuery function
  29. jQuery: Check if special characters exists in string
  30. Validate Dynamically Added Input fields

Leave a Comment