csv-file-to-json

csv-file-to-json

Reads a csv file or data variable having a table and returns an array of obects. In which each object consists of all headers as keys and there data as values.

Installation

npm i --save csv-file-to-json

Usage

csv-file-to-json support CommonJS.

In module system

Use filePath key to provide CSV data from file.

const csvToJson = require("csv-file-to-json");
const dataInJSON = csvToJSON({ filePath: "./filePath.csv" });

Use data key to provide CSV data from variable or directly.

const csvToJSON = require("csv-file-to-json");
const dataInJSON = csvToJSON({ data: someCSVData });

Sample input (csv data) :

FIRST_NAME,LAST_NAME,NUMBER,EMAIL,ADDRESS
Debra,Berks,880012XXXX,[e-mail],"9273 Thome Ave., Orchard Park, NY - 14127"
Kasha,Todd,null,[e-mail],"910, Vine Street, Campbell, CA - 95008"
Tameka,Fisher,8800111XXX,[e-mail],"7693 Honey Creek St., Redondo Beach, CA - 90278"
Debryl,Spence,990015XXXX,null,"988 Pearl Lane!!! (Uniondale), NY - 11553"
Charolette,Rice,720012XXXX,[e-mail],"107 ~ River Dr. `Sacramento`, ""CA""      95820"

Sample output (json data) :

[
  {
    FIRST_NAME: 'Debra',
    LAST_NAME: 'Burks',
    NUMBER: '880012XXXX',
    EMAIL: '[e-mail]',
    ADDRESS: '9273 Thome Ave., Orchard Park, NY - 14127'
  },
  {
    FIRST_NAME: 'Kasha',
    LAST_NAME: 'Todd',
    NUMBER: null,
    EMAIL: '[e-mail]',
    ADDRESS: '910, Vine Street, Campbell, CA - 95008'
  },
  {
    FIRST_NAME: 'Tameka',
    LAST_NAME: 'Fisher',
    NUMBER: '880111XXXX',
    EMAIL: '[e-mail]',
    ADDRESS: '7693 Honey Creek St., Redondo Beach, CA - 90278'
  },
  {
    FIRST_NAME: 'Daryl',
    LAST_NAME: 'Spence',
    NUMBER: '990015XXXX',
    EMAIL: null,
    ADDRESS: '988 Pearl Lane!!! (Uniondale), NY - 11553'
  },
  {
    FIRST_NAME: 'Charolette',
    LAST_NAME: 'Rice',
    NUMBER: '720012XXXX',
    EMAIL: '[e-mail]',
    ADDRESS: '107 ~ River Dr. `Sacramento`, "CA"      95820'
  }
]