title: Extract JSON data in cell a1, into b1, c1, d1 etc.. - Excel
body: <pre><code>{"fields":{"neTlAMGB-4yu9pN":"James","neTlAMGB-wmshSV":"james@mail.com","neTlAMGB-m446CO":"london, UK","neTlAMGB-0inhBf":"2016-12-15T12:00:00+00:00","neTlAMGB-TX6WrV":"07891122446699"}}
  </code></pre>
  
  <p>Ive exported some data from Trello into a CSV, some of the data have come in the above JSON format, if i have this data above in cell A1, id like to split it out into cells : b1, c2, d1, e1, f1, g1.</p>
  
  <p>Is that possible with either some form of extract or regex or is there a JSON parser built into google spreadsheets / excel.</p>
  
  <p>Ive created a demo google spreadsheet here for testing purposes : <a href="https://docs.google.com/spreadsheets/d/1rASBSSV4q9hC7IrxJNIFMlBOfYfkdLjJ7oyBVfniOPQ/edit#gid=0" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1rASBSSV4q9hC7IrxJNIFMlBOfYfkdLjJ7oyBVfniOPQ/edit#gid=0</a></p>
  
  <p>--</p>
  
  <p>Please note ive marked this question as "excel" and well as "google spreadsheets" as ive found in the past the majority of formula based scripts (non VBA) works cross platforms. </p>