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:
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.
We also need to make sure the suffix matches. The template file ends like this:
Edit the suffix to match.
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.