Johntron Speaks

Here is a very simple script to convert CSV to JSON using Python. Writing a script like this is very trivial. You only need it once in a while, and sometimes you forget names of things. Hopefully this will save someone a few minutes of coding. csv2json.py requires Python 2.6 or greater. If you have any questions, please contact me.

import csv
import json

f = open( 'sample.csv', 'r' )
reader = csv.DictReader( f, fieldnames = ( "id","name","lat","lng" ) )
out = json.dumps( [ row for row in reader ] )
print out

Download csv2json.tar.gz

If you find this page helpful, check out some of my other posts on Johntron.com or consider leaving a comment.