use google refine to export json

Basic JSON structure

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:

google refine

When converted to JSON, each row of data is converted into an element in an array. The data will look like this:

json format

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.

refine export

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

json refine export

Clicking Export saves a text file.