JSON to CSV

json-to-csv.py

#!/usr/bin/env python

# Reads JSON from a file or STDIN and outputs CSV to STDOUT.

import fileinput
import json
import sys
import csv

jsonstr = ''
for line in fileinput.input():
    jsonstr += line

dicts = json.loads(jsonstr)
header = sorted(set(k for d in dicts for (k, v) in d.items()))

with sys.stdout as out:
    dw = csv.DictWriter(out, header)
    dw.writeheader()
    for d in dicts:
        dw.writerow(d)