Package Exports
- csvjson
This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (csvjson) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.
Readme
csvjson
simple csv to json and json to csv converter for node.js and browser.
© Pradeep Mishra, Licensed under the MIT-LICENSE
Features
- csv to json object
- csv to schema json object
- csv to array object
- csv to column array object
- json object to csv
- json array to csv
Warning
- csvjson 2x has breaking changes and its not compatible with csvjson 1x code.
Example usage
var csvjson = require('csvjson');
/*
sample.csv
sr,name,age,gender
1,rocky,33,male
2,jacky,22,male
3,suzy,21,female
*/
/*
schema_sample.csv
created,contact.name,contact.age+,contact.number+,address[],address[],contact.hobbies[],contact.hobbies[],-id
2014-11-12,Pradeep,25,4352436,MG Road,Mumbai,pc games,guitar,5
2014-10-06,Arnav,16,7364537,KB Road,Mumbai,pc games,traveling,7
*/
/*
schema_sample2.csv
name,age,contacts[0].name,contacts[0].phone,contacts[1].name,contacts[1].phone,musician,instruments.past,instruments.current[],instruments.current[]
Mark,33,Jim Palmer,8888888888,Marcus Aurelius,7309899877,Yes,Guitar,Drums,Bass Guitar
Jeff,27,John Doe,8009008000,Michael Corleone,2121001000,Yes,Drums,Flute,Trumpet
*/
/*
jsoncsv.json
{
"book": {
"person": [
{
"firstName": "Jane",
"lastName": "Doe",
"age": "25",
"address": {
"streetAddress": "21 2nd Street",
"city": "Las Vegas",
"state": "NV",
"postalCode": "10021-3100"
},
"hobbies" : ["gaming", "volleyball"]
},
{
"firstName": "Agatha",
"lastName": "Doe",
"age": "25",
"address": {
"streetAddress": "21 2nd Street",
"city": "Las Vegas",
"state": "NV",
"postalCode": "10021-3100"
},
"hobbies" : ["dancing", "politics"]
}
]
}
}
*/
convert csv data to json object
var data = fs.readFileSync(path.join(__dirname, 'schema_sample2.csv'), { encoding : 'utf8'});
csvjson.toObject(data)
/*
returns
[
{
sr : 1,
name : "rocky",
age : 33,
gender : "male"
},
{
sr : 2,
name : "jacky",
age : 22,
gender : "male"
},
{
sr : 3,
name : "suzy",
age : 21,
gender : "female"
}
]
*/
convert csv data to schema json object
/*
for creating schema of json object following key can be used in header of csv file:
. for defining nested json object
[] for defining data as array (suffix)
-- can add delimiter in the array (i.e. [;] for delimiter of ;)
-- can nest objects in the array, index must be listed (i.e. [1] for index 1)
+ for defining data as integer (suffix)
- for omitting data from result output (prefix)
*/
/*
schema_sample.csv
created,contact.name,contact.age+,contact.number+,address[],address[],contact.hobbies[;],-id,friends[0].name,friends[0].phone,friends[1].name,friends[1].phone
2014-11-12,Pradeep,25,4352436,MG Road,Mumbai,pc games; guitar,5,Jeff,8761234567,Mike,1234567890
2014-10-06,Arnav,16,7364537,KB Road,Mumbai,pc games; traveling,7,Steve,555555555,Pradeep,4352436
*/
var data = fs.readFileSync(path.join(__dirname, 'schema_sample.csv'), { encoding : 'utf8'});
csvjson.toSchemaObject(data)
/*
returns
[
{
"created":"2014-11-12",
"contact":{
"name":"Pradeep","
age":25,
"number":4352436,
"hobbies":["pc games","guitar"]
},
"address":["MG Road","Mumbai"],
"friends":[
{
"name": "Jeff",
"phone": "8761234567"
},
{
"name": "Mike",
"phone": "1234567890"
}
]
},
{
"created":"2014-10-06",
"contact":{"
name":"Arnav",
"age":16,
"number":7364537,
"hobbies":["pc games","traveling"]
},
"address":["KB Road","Mumbai"],
"friends":[
{
"name": "Steve",
"phone": "5555555555"
},
{
"name": "Pradeep",
"phone": "4352436"
}
]
}
]
*/
convert csv data to array object
var data = fs.readFileSync(path.join(__dirname, 'sample.csv'), { encoding : 'utf8'});
csvjson.toArray(data);
/*
returns
[
["sr","name","age","gender"],
["1","rocky","33","male"],
["2","jacky","22","male"],
["3","suzy","21","female"]
]
*/
convert csv data to column array object
var data = fs.readFileSync(path.join(__dirname, 'sample.csv'), { encoding : 'utf8'});
csvjson.toColumnArray('./sample.csv')
/*
returns
{
sr: [ '1', '2', '3' ],
name: [ 'rocky', 'jacky', 'suzy' ],
age: [ '33', '22', '21' ],
gender: [ 'male', 'male', 'female' ]
}
*/
convert json object to csv data
var data = fs.readFileSync(path.join(__dirname, 'jsoncsv.json'), { encoding : 'utf8'});
var options = {
delimiter : ",", // <String> optional default is comma
wrap : false // <String|Boolean> optional default in false
}
csvjson.toCSV(data, options);
/*
returns
book.person[].firstName,book.person[].lastName,book.person[].age,book.person[].address.streetAddress,book.person[].address.city,book.person[].address.state,book.person[].address.postalCode,book.person[].hobbies[]
Jane,Doe,25,21 2nd Street,Las Vegas,NV,10021-3100,gaming;volleyball
Agatha,Doe,25,21 2nd Street,Las Vegas,NV,10021-3100,dancing;politics
*/npm install csvjson --save