VBA to convert Excel to JSON [or CSV to JSON]

[writetoevv]

Hi Friends

Would you please help to create below JSON file format from Excel/CSV via VBA.

a) Excel Snapshot with input data is provided for your reference.

b) Here is final sample output of JSON file for your reference

[
   {
      "question":"150/3",
      "question_title":"",
      "question_image":"",
      "wrong_answer_text":"",
      "right_answer_text":"",
      "question_hint":"",
      "explanation":"",
      "user_explanation":"",
      "type":"radio",
      "published":"1",
      "create_date":"0000-00-00 00:00:00",
      "not_influence_to_score":"",
      "weight":"1",
      "options":"",
      "category":"Uncategorized",
      "answers":[
         {
            "answer":"60",
            "image":"",
            "correct":"0",
            "ordering":"1",
            "weight":"1",
            "keyword":"A",
            "placeholder":""
         },
         {
            "answer":"50",
            "image":"",
            "correct":"1",
            "ordering":"2",
            "weight":"2",
            "keyword":"A",
            "placeholder":""
         },
         {
            "answer":"100",
            "image":"",
            "correct":"0",
            "ordering":"3",
            "weight":"1",
            "keyword":"A",
            "placeholder":""
         }
      ]
   },
   {
      "question":"10+20",
      "question_title":"",
      "question_image":"",
      "wrong_answer_text":"",
      "right_answer_text":"",
      "question_hint":"",
      "explanation":"",
      "user_explanation":"",
      "type":"radio",
      "published":"1",
      "create_date":"0000-00-00 00:00:00",
      "not_influence_to_score":"",
      "weight":"1",
      "options":"",
      "category":"Uncategorized",
      "answers":[
         {
            "answer":"30",
            "image":"",
            "correct":"1",
            "ordering":"1",
            "weight":"2",
            "keyword":"A",
            "placeholder":""
         },
         {
            "answer":"40",
            "image":"",
            "correct":"0",
            "ordering":"2",
            "weight":"1",
            "keyword":"A",
            "placeholder":""
         },
         {
            "answer":"50",
            "image":"",
            "correct":"0",
            "ordering":"3",
            "weight":"1",
            "keyword":"A",
            "placeholder":""
         }
      ]
   }
]

Thanks.

 

[writetoevv]

Hi Friends

Could someone help on this. please.

 

[writetoevv]

Any Help on this is highly Appreciated..

Fyi, Need any input please reply back.

 

[writetoevv]

Friends, Could anyone help on this format of JSON. please.