use google refine to export json
Basic JSON structure
Let's start with a simple spreadsheet in Refine. Download the project files and import CaStimContracts.csv into Google Refine. You should see a straight forward spreads sheet that looks like this:
When converted to JSON, each row of data is converted into an element in an array. The data will look like this:
Converting your spreadsheet to JSON is easy. In the top-right corner, click the export button to get a drop-down menu and select Templating.
Clicking Export saves a text file.