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 linesys.setdefaultencoding(“UTF-8”) #set the encode to utf8#check if you pass the input file and output fileif 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!

No Responses

Write a response