title: how to convert CSV (with array and dictionary) values to JSON
body: <p>can someone please advice how I can convert a CSV file with arrays and dictionaries to JSON.
  I've looked at some similar questions without much success, since they don't address conversion of arrays and dictionaries.</p>
  
  <p>here is a sample CSV text which has arrays and dictionaries, also find excel file (shown as image) from which I created this CSV text.</p>
  
  <p>For explanation purposes, I have limited number of fields and the complexity. I wonder if there is a snippet of code or tool converter that can do the job of conversion. </p>
  
  <p>FYI: I am collecting the info in excel file, converting into CSV file to load it on to the database. </p>
  
  <pre><code>firstName,lastName,address
  John,Baker,Newyork
  Paul,Fisher,Paris
  Gabriel,Solksi,[location:London, postcode:EC17DC]
  Laurene,smith,{location:Beijing, pincode:512389, alternateNames:[risingCity, futureCity]}
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/Xabmw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Xabmw.png" alt="excel file that used to convert to CSV"></a></p>