use google refine to export json

Export JSON to match templates

The real power of Refine is that it gives you control over how the JSON will be formatted. You can edit once and make sure the changes are applied to huge data sets. This makes it very easy to make sure your data matches your custom templates. Lets make this data match the data used in the External Data Protovis tutorial.  Here's what the top of the file looks like:

population data top

To get the same thing in our file, we edit the prefix. Notice that the preview on the right will update to show you how your data will appear.

edit json template

We also need to make sure the suffix matches. The template file ends like this:

pop data end

Edit the suffix to match.

edit suffix refine

We can now export and use this is the external data tutorial example. The dollar amount can display in the chart and the related information as text.