convert-csv-to-json

CSVtoJSON

Convert csv file to JSON file with Node.js.

This project is not dependent on others packages or libraries.

The cvs file must be semicolon (;) separated.

Give an input file like:

first_name	last_name	email	gender	age
Constantin	Langsdon	[e-mail]	Male	96
Norah	Raison	[e-mail]	Female	32

e.g. :

first_name;last_name;email;gender;age
Constantin;Langsdon;[e-mail];Male;96
Norah;Raison;[e-mail];Female;32

will generate:

[
 {
  "first_name": "Constantin",
  "last_name": "Langsdon",
  "email": "[e-mail]",
  "gender": "Male",
  "age": "96"
 },
 {
  "first_name": "Norah",
  "last_name": "Raison",
  "email": "[e-mail]",
  "gender": "Female",
  "age": "32"
 }
]

Prerequisites

NPM (see Installing Npm).

npm

Go to NPM package convert-csv-to-json.

Install

Install package in your package.json

$ npm install convert-csv-to-json --save

Install package on your machine

$ npm install -g convert-csv-to-json

Usage

Generate JSON file

let csvToJson = require('convert-csv-to-json');

let fileInputName = 'myInputFile.csv'; 
let fileOutputName = 'myOutputFile.json';

csvToJson.generateJsonFileFromCsv(fileInputName,fileOutputName);

Generate Array of Object in JSON format

let csvToJson = require('convert-csv-to-json');

let json = csvToJson.getJsonFromCsv("myInputFile.csv");
for(let i=0; i<json.length;i++){
    console.log(json[i]);
}

Format property value by type

If you want that a number will be printed as a Number type and not as a String type, use:

 csvToJson.formatValueByType().getJsonFromCsv(fileInputName)

In this case the result will be:

[
 {
  "first_name": "Constantin",
  "last_name": "Langsdon",
  "email": "[e-mail]",
  "gender": "Male",
  "age": 96
 },
 {
  "first_name": "Norah",
  "last_name": "Raison",
  "email": "[e-mail]",
  "gender": "Female",
  "age": 32
 }
]

The property age is printed as

 "age": 32

instead of

  "age": "32"

License

CSVtoJSON is licensed under the GNU General Public License v3.0 License.