json to excel python code example

Example 1: json to csv python

import pandas as pd
df = pd.read_json (r'C:\Users\Ron\Desktop\Test\Product_List.json')
export_csv = df.to_csv (r'C:\Users\Ron\Desktop\Test\New_Products.csv', index = None, header=True)

Example 2: excel to json python

$ pip install excel2json-3
import excel2json

excel2json.convert_from_file('records.xlsx')