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!