Subscribe Bookmark RSS Feed



Jun 23, 2011

JSON Importer Add-in for JMP 12

This JMP 12 add-in converts a JSON file into a JMP data table, building on the JSON parsing JSL functions by Xan Gregg and Craige Hales. This add-in was written by JMP summer intern Matthew Wolfe and provides a dialog for picking a file to import.

For JMP 13 and later, JSON parsing is included with JMP. You can pick a .json file from the File Open dialog or use the JSON JSL functions.

Example JSON from Wikipedia entry:


  "firstName": "John",

  "lastName": "Smith",

  "isAlive": true,

  "age": 25,

  "address": {

   "streetAddress": "21 2nd Street",

   "city": "New York",

   "state": "NY",

   "postalCode": "10021-3100"


  "phoneNumbers": [


   "type": "home",

   "number": "212 555-1234"



   "type": "office",

   "number": "646 555-4567"



  "children": [],

  "spouse": null


Here is the data table after import. Notice that nesting is reflecting in the column names.


Article Labels
Article Tags