How to convert a JSON file to CSV — PYTHON SCRIPT

Hi everybody, this is a simple snippet to help you convert your JSON file to a CSV file using a Python script.

Create a new Python file like: json_to_csv.py

Add this code:

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

After adding this, save the file and run at the terminal:

python json_to_csv.py input.txt output.csv

If you have any doubt, feel free to contact me at Twitter @gabrielpires or by e-mail eu at gabrielpires.com.br

SEEYA!

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