Json to excel in Python and Read Json file content in Python

 

Below is the program to convert JSON file content into excel in Python.

For this, you need to import json

import json

import csv

import pandas as pd

from payLoad import *

json_file = {

    "key1":"Value1",

    "key2":"Value2",

    "key3":"Value3",

}

pd.DataFrame(json_file).to_excel("excel.xlsx")

=====================================================================

Below is the program to Read Json file content in Python

For this, you need to import JSON

import json

with open('C:\\Users\\my_json_test_file.json') as f:

    data = json.load(f)

print(data)