convert a csv to json

convert.py

#!/usr/bin/python

import csv
import json


header = []
results = []
print "["
with open('data.csv', 'rb') as f:
    reader = csv.reader(f)
    for row in reader:
        if len(header) > 0:
            datarow = {}
            for key, value in (zip(header,row)):
                datarow[key] = value
            print json.dumps(datarow)
            print ","
        else:
            header = row

print "]"

Usage:

download script, save as convert.py
save your customer xls as data.csv

python convert.py | pbcopy