What csv format is for json array, and how to convert them into json array, Nodejs

think of your CSV file just like an Excel sheet, where you only have Columns and Rows, so with your preferred structure, you need to define at least these columns:

|| email || contactNo || name || position ||

Those 4 are the most basic header columns your CSV needs, then you'll need a transformer function to handle the data structure you want.

In my experience, I'm using https://www.papaparse.com/ for the CSV Parser, you can have a look at the sample and try it yourself.

In your case, the parser function would be like this:

const parsed = await Papa.parse(csvString, {
  header: true,
  trimHeaders: true,
  skipEmptyLines: 'greedy',
  transformHeader: val => isString(val) ? trimAll(val) : val,
  transform: (val, headerName) => {
    return isString(val) ? trimAll(val) : val
  }
});

//
[
  {
    "email": "[email protected]",
    "contactNo": "1234-5678",
    "name": "Doe",
    "position": "doctor",
  },
  {
    "email": "[email protected]",
    "contactNo": "1234-5678",
    "name": "John",
    "position": "developer"
  },
  ...
]

Cheers,

This is the csv format to your JSON structure.you can use this Online converter to see how your csv look like.

This is how you can convert the csv to JSON. You can refer this good tutorial to learn how to convert the csv to JSON format. The function which is used there is below.

function csvJSON(csv){

    var lines=csv.split("\n");

    var result = [];

    var headers=lines[0].split(",");

    for(var i=1;i<lines.length;i++){

        var obj = {};
        var currentline=lines[i].split(",");

        for(var j=0;j<headers.length;j++){
            obj[headers[j]] = currentline[j];
        }

        result.push(obj);

    }


    return JSON.stringify(result); //JSON
}

You can use json2csv npm module http://www.mircozeiss.com/json2csv/

I found out that using npm csvtojson is much easier.

CSV:

email, contactNo, meta.0.key, meta.0.value, meta.0.type, meta.1.key, meta.1.value, meta.1.type
[email protected], 12345, Name, Kevin XYZ, string, Position, Chairman, string
[email protected], 321433, Name, John ABC, string, Position, Accountant, string

by using the following code:

const csv = require('csvtojson');

const csvStr = "The csv above"

csv()
  .fromString(csvStr)
  .subscribe((jsonObj) => {
    console.log(jsonObj);
  });

The result of the json will be:

{ email: '[email protected]',
  contactNo: '12345',
  meta:
   [ { key: 'Name', value: 'Kevin XYZ', type: 'string' },
     { key: 'Position', value: 'Chairman', type: 'string' } ] }
{ email: '[email protected]',
  contactNo: '321433',
  meta:
   [ { key: 'Name', value: 'John ABC', type: 'string' },
     { key: 'Position', value: 'Accountant', type: 'string' } ] }

In conclusion, using the header xx.0.yy is not so user friendly, I recommend just using what Duc Hong said.. header: email, contactNo, Name, Position and transform to the format that you want.