does anybody know any other way to import my json file into excell?
import csv def import_to_csv(): json_file = open('exp.json', 'r') output = open('out.csv', 'w+) writer = csv.writer(output, dialect='excel') with json_file: for data in csv.reader(json_file, dialect='excel'): for row in data: writer.writerow(row) import_to_csv()
You can use pandas module.
Pandas readjson writeexcel
Обсуждают сегодня