use google refine to export json
Google Refine is great at cleaning large sets of data. But one amazing under-documented feature is the ability to design and output JSON files. With Google Refine, you can turn a simple spreadsheet into a straight forward JSON dataset or multidimensional array quickly and easily.
Filed under: Data Visualization