SimpleCSV.js is a fast and compact JavaScript CSV library for parsing csv strings, and parsing JSON table objects.

Features

In-the-Browser, For-The-Browser: Only 3 lines of code to parse CSV strings, and JSON tables.
Python csv compatible: Guaranteed to produce the same results as Python 2.7 csv parser.
JSON parser: Convert CSV to JSON, or JSON to CSV.
No dependancies: Tiny standalone .js file.

Downloads

Examples

Browser

In any web page:

<script src="http://simplecsvjs.com/dist/simplecsv.0.0.47.standalone.min.js"></script>
<script>
  var simplecsv = require('simplecsv');
  var csv = new simplecsv.csv();

  var parsedCsvdata = csv.parseString('Turing, 35, chess\nSamuel, 21, checkers');
</script>

Node.js

var simplecsv = require('simplecsv');
var csv = new simplecsv.csv();

var parsedCsvdata = csv.parseString('Turing, 35, chess\nSamuel, 21, checkers');

More Examples

CSV to JSON

var simplecsv = require('simplecsv');
var csv = new simplecsv.csv();

var jsonObj = csv.CSVToJSON('Planet Name, Color\nMars,red-orange\nUranus,light-blue',
                            { hasHeaders: true });
console.log(jsonObj);

output is:

[{"Planet Name":"Mars"," Color":"red-orange"},{"Planet Name":"Uranus"," Color":"light-blue"}]

JSON -> CSV

var simplecsv = require('simplecsv');
var csv = new simplecsv.csv();

var str  = csv.JSONToCSV('[{"Planet Name":"Mars"," Color":"red-orange"},' +
                         '{"Planet Name":"Uranus"," Color":"light-blue"}]');
console.log(str);

output is:

Planet Name, Color
Mars,red-orange
Uranus,light-blue

console.log() every cell

var simplecsv = require('simplecsv');
var csv = new simplecsv.csv();

var cdata = csv.parseString('Planet Name, Color\nMars,red-orange\nUranus,light-blue', { hasHeaders: true });
for (var i = 0; i < cdata.rowCount; i++) {
  for (var j = 0; j < cdata.columnCount; j++) {
    console.log(cdata.rows[i][j]);
  }
}

find errors

var simplecsv = require('simplecsv');
var csv = new simplecsv.csv();

var cdata = csv.parseString('Planet Name, Color\nMars\nred-orange, Uranus,light-blue', { hasHeaders: true });
console.log(csv.findErrors(cdata));

Quick Start

Install

Install with npm.

$ npm install simplecsv

Newline

SimpleCSV.js uses \n and \r\n for newline when parsing. Currently there is no support for Mac's \r for newline (i.e. universal mode in Python csv).

Support

For bug reports, feature requests and general questions, please feel free to email baris@onehundredyearsofcode.com.

Development

Refer to development notes

Documentation

Library manual