How to convert a JSON file to CSV — PYTHON SCRIPT

Gabriel Pires
Dec 13, 2016 · 1 min read
import csv, json, sys
#if you are not using utf-8 files, remove the next line
sys.setdefaultencoding("UTF-8") #set the encode to utf8
#check if you pass the input file and output file
if sys.argv[1] is not None and sys.argv[2] is not None:
fileInput = sys.argv[1]
fileOutput = sys.argv[2]
inputFile = open(fileInput) #open json file
outputFile = open(fileOutput, 'w') #load csv file
data = json.load(inputFile) #load json content
inputFile.close() #close the input file
output = csv.writer(outputFile) #create a csv.write output.writerow(data[0].keys()) # header row for row in data:
output.writerow(row.values()) #values row

Gabriel Pires

Written by

Senior Back-end Engineer @ Helloprint. Tech Professional, Development, Data Science and more. Straight to the point without bullshit.

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade