🚀 Big News: Socket Acquires Coana to Bring Reachability Analysis to Every Appsec Team.Learn more

csv-file-to-json

Advanced tools

Socket logo

Install Socket

Detect and block malicious and high-risk dependencies

Install

csv-file-to-json

Converts a csv file to a json.

4.0.3
Version published
Weekly downloads
1.6K
-28.78%
Maintainers
1
Weekly downloads
 
Created

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

FAQs

Package last updated on 27 Jan 2020

Did you know?

Socket

Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.

Install

Related posts