CSVtoJSON
This project is not dependent on others packages or libraries.
Table of Contents
Description
Converts csv files to JSON files with Node.js.
Give an input file like:
first_name | last_name | gender | age | |
---|---|---|---|---|
Constantin | Langsdon | clangsdon0@hc360.com | Male | 96 |
Norah | Raison | nraison1@wired.com | Female | 32 |
e.g. :
first_name;last_name;email;gender;ageConstantin;Langsdon;clangsdon0@hc360.com;Male;96Norah;Raison;nraison1@wired.com;Female;32
will generate:
Prerequisites
NPM (see Installing Npm).
Install npm convert-csv-to-json package
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 = ; let fileInputName = 'myInputFile.csv'; let fileOutputName = 'myOutputFile.json'; csvToJson;
Generate Array of Object in JSON format
let csvToJson = ; let json = csvToJson;forlet i=0; i<jsonlength;i++ console;
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 ~:
csvToJson ;
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;
In this case the result will be:
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.
Buy me a Coffee
Just if you want to support this repository:
- BTC tip address: 3KCCK292a61AHrKuVCFZ8Agr3j31Zw8Mzg