csv-table-parser

how to install

 npm install csv-table-parser

what's this?

csv file convert to object array like below.

const { parser } = require('csv-table-parser')

const input = `name, age, email, isMember
alice, 15, [e-mail], true
bob, 25, [e-mail], false
`

parser(input)
/*
 *[
 *   { name: "alice", age: 15, email: "[e-mail]", isMember: true },
 *   { name: "bob", age: 25, email: "[e-mail]", isMember: false }
 *]
*/

you can also convert to array in array.

const { parser } = require('csv-table-parser')

const input = `alice, 15, [e-mail], true
bob, 25, [e-mail], false
`

parser(input, { type: 'array' })
/*
 *[
 *   [ "alice", 15, "[e-mail]", true ],
 *   [ "bob", 25, "[e-mail]", false ]
 *]
*/

options

second parameter is options. the example is below.

separator

const input = `name	age	email	isMember
alice	15	[e-mail]	true
bob	25	[e-mail]	false
`

parser(input, { separator: '\t' })
/*
 *[
 *   { name: "alice", age: 15, email: "[e-mail]", isMember: true },
 *   { name: "bob", age: 25, email: "[e-mail]", isMember: false }
 *]
*/

startRow

const input = `customer name, customer age, customer email for customer service, this user is member or not
name, age, email, isMember
alice, 15, [e-mail], true
bob, 25, [e-mail], false
`

parser(input, { startRow: 1 })
/*
 *[
 *   { name: "alice", age: 15, email: "[e-mail]", isMember: true },
 *   { name: "bob", age: 25, email: "[e-mail]", isMember: false }
 *]
*/

startColumn

const input = `no, name, age, email, isMember
1, alice, 15, [e-mail], true
2, bob, 25, [e-mail], false
`

parser(input, { startColumn: 1 })
/*
 *[
 *   { name: "alice", age: 15, email: "[e-mail]", isMember: true },
 *   { name: "bob", age: 25, email: "[e-mail]", isMember: false }
 *]
*/

numberOfColumn

const input = `name, age, email, isMember
alice, 15, [e-mail], true
bob, 25, [e-mail], false
`

parser(input, { numberOfColumn: 3 })
/*
 *[
 *   { name: "alice", age: 15, email: "[e-mail]" },
 *   { name: "bob", age: 25, email: "[e-mail]" }
 *]
*/

defaultValue

const input = `name, age, email, isMember
alice, 15, [e-mail],
bob, 25, [e-mail], true
`

parser(input, { defaultValue: false })
/*
 *[
 *   { name: "alice", age: 15, email: "[e-mail]", isMember: false },
 *   { name: "bob", age: 25, email: "[e-mail]", isMember: true }
 *]
*/