@novigi/csv-to-json

Simple library for csv parse to Javascript object from any CSV string or csv file 🚀

🐿 Features

• Chainable and immutable API
• Parse CSV content into JSON object
• Parse CSV files into JSON objects
• Supports custom headers

📦 Getting Started

1. Install the dependency

npm install @novigi/csv-to-json

2. Import the library

const lib = require('@novigi/csv-to-json');

📖 Documentation

csv-to-json

This library contains methods that allow user to parse the csv, either it is a csv string or file convert into the Javscript object.

This guideline is about the formats and examples that can follow for csv string parsing to Javascript object conversion 🚀

const csv = require('@novigi/csv-to-json')

const input = 'name,age,sex\nkasun,33,male\nsteve,35,male'
let json = csv().parseData(input)

// or

let json = csv().parseFile(path/to/file)

Chainable + immutable methods! ☝

• csv-to-json
  • ~Csv
    • .delimiter ⇒ Csv
    • .lineBreak ⇒ Csv
    • .noHeaders ⇒ Csv
    • .headers ⇒ Csv
    • .parseFile ⇒ Csv
    • .parseData ⇒ Csv
  • ~csv([options]) ⇒ Csv

csv-to-json~Csv

Kind: inner class of csv-to-json

• ~Csv
  • .delimiter ⇒ Csv
  • .lineBreak ⇒ Csv
  • .noHeaders ⇒ Csv
  • .headers ⇒ Csv
  • .parseFile ⇒ Csv
  • .parseData ⇒ Csv

csv.delimiter ⇒ Csv

Delimiter is for different separators that can manually pass with csv file or string, the separator separates the CSV string in the context.

Kind: instance property of Csv
Returns: Csv - new instance of Csv object with the same options

Param	Type	Description
delimiter	string	The delimiter as a parameter to separate the values in the csv

Example

const csvString = "name;age;sex\nkasun;33;male\nsteve;35;male"
csv().fieldDelimiter(';').parseData(csvString)   // [{ name: 'kasun', age: '33', sex: 'male' }, { name: 'steve', age: '35', sex: 'male' }]

csv.lineBreak ⇒ Csv

Line-break is for for indicating the ending of a row in the csv content.

Kind: instance property of Csv
Returns: Csv - new instance of Csv object with the same options

Param	Type	Description
lineBreak	string	The lineBreak as a parameter to separate the lines in the csv

Example

const csvString = "name,age,sex\r\nkasun,33,male\r\nsteve,35,male"
csv().lineBreak('\r\n').parseData(csvString)   // [{ name: 'kasun', age: '33', sex: 'male' }, { name: 'steve', age: '35', sex: 'male' }]

csv.noHeaders ⇒ Csv

This method is to indicate whether csv content has the header data or not.

Kind: instance property of Csv
Returns: Csv - new instance of Csv object with the same options

Param	Type	Description
noHeaders	*	Indicate whether csv content has headers. Undefined parameter is considered as true

Example

const csvString = 'kasun,33,male\nsteve,35,male'
const customHeader = ['user_name', 'user_age', 'user_gender']
const result = csv().noHeaders().headers(customHeader).parseData(csvString) // custom headers wil be used as the headers of the csv content

csv.headers ⇒ Csv

Adds headers to use as the headers of the csv content. Specifying headers will override the headers in the csv content. When provided header list is insufficient, headers in the csv content are considered

Kind: instance property of Csv
Returns: Csv - new instance of Csv object with the same options

Param	Type	Description
headers	array	Custom header array to be used as headers of the csv content

Example

const csvString = 'kasun,33,male\nsteve,35,male'
const customHeader = ['user_name', 'user_age', 'user_gender']
const result = csv().headers(customHeader).parseData(csvString)

csv.parseFile ⇒ Csv

CSV file read and parse to javascript data structure , 'parseFile' method read and convert the csv file into the javascript array object.

Kind: instance property of Csv
Returns: Csv - new instance of Csv object with the same options

Param	Type	Description
csvFile	string	valid csv file path , the path passes as a parameter and read the file in that file is exist

Example

const path = './resources/csvFile.csv'           // csv file directory path
csv().parseFile(csvFile)                           // [{ name: 'kasun', age: '33', sex: 'male' }, { name: 'steve', age: '35', sex: 'male' }]

csv.parseData ⇒ Csv

CSV parse to javascript data structure,'parse' method convert the csv string to the javascript array object.

Kind: instance property of Csv
Returns: Csv - new instance of Csv object with the same options

Param	Type	Description
csvString	string	valid string to passes as a parameter

Example

const csvString = "name,age,sex\nkasun,33,male\nsteve,35,male"
csv().parseData(csvString)                              // [{ name: 'kasun', age: '33', sex: 'male' }, { name: 'steve', age: '35', sex: 'male' }]

csv-to-json~csv([options]) ⇒ Csv

Create an Csv chain builder instance

Kind: inner method of csv-to-json
Returns: Csv - new instance of 'Csv' object

Param	Type	Description
[options]	object	optional configurations for the chain
[options.delimiter]	string	delimiter which csv fields are separated
[options.lineBreak]	string	line break character of csv rows
[options.noHeaders]	boolean	falg to indicate csv content has a header row or not
[options.headers]	object	custom headers for parsing csv content

Example

csv()
csv(options)

This is an auto generated file. Please don't make changes manually