CSVtoJSON

 

This project is not dependent on others packages or libraries.

Table of Contents

1. Description
1. Prerequisites
1. Install npm convert-csv-to-json package
1. Usage
* Generate JSON file
* Generate Array of Object in JSON format
* Define field delimiter
* Format property value by type
1. License
1. Buy me a Coffee

Description

Converts csv files to JSON files with Node.js.

Give an input file like:

|first_name|last_name|email|gender|age|
|:----------:|:-------:|:---:|:----:|:---:|
|Constantin|Langsdon|clangsdon0@hc360.com|Male|96|
|Norah|Raison|nraison1@wired.com|Female|32|

e.g. :
``json
first_name;last_name;email;gender;age
Constantin;Langsdon;clangsdon0@hc360.com;Male;96
Norah;Raison;nraison1@wired.com;Female;32
`

will generate:


`json
[
{
"first_name": "Constantin",
"last_name": "Langsdon",
"email": "clangsdon0@hc360.com",
"gender": "Male",
"age": "96"
},
{
"first_name": "Norah",
"last_name": "Raison",
"email": "nraison1@wired.com",
"gender": "Female",
"age": "32"
}
]
`

Prerequisites

NPM (see Installing Npm).

Install npm convert-csv-to-json package

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

$3

Install package in your package.json
`bash
$ npm install convert-csv-to-json --save
`
Install package on your machine
`bash
$ npm install -g convert-csv-to-json
`

$3

#### Generate JSON file
`js
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
`js
let csvToJson = require('convert-csv-to-json');

let json = csvToJson.getJsonFromCsv("myInputFile.csv");
for(let i=0; i console.log(json[i]);
}
`
#### Define field delimiter
As default the filed delimiter is the semicolon (;). You can define another field delimiter
by call the function `fieldDelimiter(myDilimiter)`.
If you want that the field delimiter is a ~:

`js
csvToJson.fieldDelimiter('~') .getJsonFromCsv(fileInputName);
`


#### 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:
`js
csvToJson.formatValueByType().getJsonFromCsv(fileInputName);
`
In this case the result will be:

`json
[
{
"first_name": "Constantin",
"last_name": "Langsdon",
"email": "clangsdon0@hc360.com",
"gender": "Male",
"age": 96
},
{
"first_name": "Norah",
"last_name": "Raison",
"email": "nraison1@wired.com",
"gender": "Female",
"age": 32
}
]
`
The property age is printed as
`json
"age": 32
`
instead of
`json
"age": "32"
``

License

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

Buy me a Coffee

Just if you want to support this repository:
* BTC tip address: 3KCCK292a61AHrKuVCFZ8Agr3j31Zw8Mzg