JAVASCRIPT

python convert json to csv

import json
import csv
 
with open('G:Akhiljsonoutput.json') as json_file:
    jsondata = json.load(json_file)
 
data_file = open('G:Akhiljsonoutput.csv', 'w', newline='')
csv_writer = csv.writer(data_file)
 
count = 0
for data in jsondata:
    if count == 0:
        header = data.keys()
        csv_writer.writerow(header)
        count += 1
    csv_writer.writerow(data.values())
 
data_file.close()

json to csv python

import pandas as pd

df = pd.read_json (r'my_file.json')
# content of my_file.json :
#
# {"Product":{"0":"Desktop Computer","1":"Tablet","2":"Printer","3":"Laptop"},"Price":{"0":700,"1":250,"2":100,"3":1200}}

df.to_csv (r'my_file.csv', index = None)
# content of my_file.json :
#
# Product,Price
# Desktop Computer,700
# Tablet,250
# Printer,100
# Laptop,1200

json to csv in python

'''
@author : alixaprodev.com
'''
import csv, json
input_json_file='json_file.json'
output_csv_file='csv_file.csv'
input = open(input_json_file)
data = json.load(input)
input.close()
output = csv.writer(open(output_csv_file,'w'))
output.writerow(data[0].keys())  # header row
for row in data:
    output.writerow(row.values())

convert json to csv

import pandas as pd
df = pd.read_json (r'input.json')
df.to_csv (r'output.csv', index = None)

json to csv

let myObj= [
  { "ean":1, "name":'prod1', "attibutes":[{"attr": 100,"color": "green"},{"attr": 200,"color": "red"}] },  
  { "ean":2, "name":'prod1', "attibutes":[{"attr": 100,"color": "white"},{"attr": 200,"color": "blu"}] }
];    

function toCsv(arrOfObj){
  // array of objects with nested objects
  // keys for arr of obj (rows) is numeric
  // key for elements of nested obj is a name
  // I transform each row in an array
  const csvString = [
    ...arrOfObj.map(item => [
       item.ean,
       item.name,
       //NO: passes 0:object,1:obj, Object.entries(item.attibutes).map(([k,v]) => `${k}:${v}`)
	   Object.keys(item.attibutes).map(row => [ Object.keys(item.attibutes[row]).map( elkey => elkey + ':' + item.attibutes[row][elkey]     )])
  ])]
   .map(e => e.join(";")) 
   .join("
");
console.log(csvString);  
return csvString;
}
//TEST
toCsv(myObj);

json to csv

# call csvkit (which is a Python tool) to convert json to csv:
# https://csvkit.readthedocs.io/en/latest/

in2csv data.json > data.csv

json to csv

const items = [
  {name: 'John', age: 31},
  {name: 'Maria', age: 25},
];

const replacer = (key, value) => value === null ? '' : value // specify how you want to handle null values here
const header = Object.keys(items[0]);
let csv = items.map(row => header.map(fieldName => row[fieldName], replacer).join(','));
csv.unshift(header.join(','));
csv = csv.join('
');

console.log(csv)

csv to json

python -c "import csv,json;print json.dumps(list(csv.reader(open('csv_file.csv'))))"

Convert JSON to CSV

import json
if __name__ == '__main__':
    try:
        with open('input.json', 'r') as f:
            data = json.loads(f.read())

        output = ','.join([*data[0]])
        for obj in data:
            output += f'
{obj["Name"]},{obj["age"]},{obj["birthyear"]}'
            
        with open('output.csv', 'w') as f:
            f.write(output)
    except Exception as ex:
        print(f'Error: {str(ex)}')