use google refine to export json

JSON stands for JavaScript Object Notation and is an increasingly common way of incorporating data in JavaScript. Think of this text file as a cleaner, lighter version of XML. 

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.

A new window will open showing you the default export template. The default export will work with a lot of JavaScript templates. 

Clicking Export saves a text file.