Naively Programmable Module

    csv-file-to-json

    4.0.3 • Public • Published

    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,Burks,880012XXXX,debra.burks@yahoo.com,"9273 Thome Ave., `Orchard Park`, NY - 14127"
    Kasha,Todd,null,kasha.todd@yahoo.com,"910, Vine Street!!!, (Campbell), CA - 95008"
    Tameka,Fisher,8800111XXX,null,"7693 ~ Honey Creek St., Redondo Beach, "CA"      90278"
    

    Sample output (json data) :

    [
      {
        FIRST_NAME: 'Debra',
        LAST_NAME: 'Burks',
        NUMBER: '880012XXXX',
        EMAIL: 'debra.burks@yahoo.com',
        ADDRESS: '9273 Thome Ave., `Orchard Park`, NY - 14127'
      },
      {
        FIRST_NAME: 'Kasha',
        LAST_NAME: 'Todd',
        NUMBER: null,
        EMAIL: 'kasha.todd@yahoo.com',
        ADDRESS: '910, Vine Street!!!, (Campbell), CA - 95008'
      },
      {
        FIRST_NAME: 'Tameka',
        LAST_NAME: 'Fisher',
        NUMBER: '880111XXXX',
        EMAIL: null,
        ADDRESS: '7693 ~ Honey Creek St., Redondo Beach, "CA"      90278'
      }
    ]
    

    Use separator key to specific your separator. Default separator is ",".

    const dataInJSON = csvToJSON({ filePath: "./filePath.txt", separator: "," });

    Use hasHeader key to specify if your file or data contains a header line or not.
    Default is true and first line will be taken has header line

    const dataInJSON = csvToJSON({ filePath: "./filePath.txt", hasHeader: true });

    Use headers key to specify your own headers.

    const dataInJSON = csvToJSON({ filePath: "./filePath.txt", hasHeader: false, headers: ["FIRST_NAME", "LAST_NAME", "NUMBER", "EMAIL", "ADDRESS"] });

    References

    Install

    npm i csv-file-to-json

    DownloadsWeekly Downloads

    210

    Version

    4.0.3

    License

    ISC

    Unpacked Size

    211 kB

    Total Files

    11

    Last publish

    Collaborators

    • vprince001