JSON Dataframe to Excel with Python Aug 30, 2019 Requirements pip3 install openpyxl pandas Convert import pandas as pd import json data = json.load(open('computers.json')) computers = pd.DataFrame(data["computers"]) computers.to_excel("output.xlsx") Please enable JavaScript to view the comments powered by Disqus.