How to convert JSON file to excel Python?

I want to convert json file to excel file using python.

I have tried a lot but I didn't find proper solution. Any help would be appreciated. I have used. Import json. Import requests. From bs4 import BeautifulSoup. Import pandas as pd. Import openpyxl. From openpyxl import loadworkbook. If name == "main": url = '. content = requests.get(url).text
soup = BeautifulSoup(content, "html.parser") #print (soup). data = soup.find('div', attrs=) print(data). print(type(data)). #print ("----End of JSON----"). df = pd.DataFrame(json.ExcelWriter('D:PyProjectTasks.xlsx')
df.toexcel(writer, sheetname='Sheet1') writer.save() Try the following code: content = requests.get(url).text
Soup = BeautifulSoup(content, "html.parser") data = json.loads(soup.text)

How to convert JSON to table in Python?

I want to use a Python Script to read a JSON file and convert it into Table.

For the first time I am trying it with Python 3.2. My Python Script contains these lines:
Import json. Import csv. #open json file. With open('inputdata.json') as jsonFile: data = json.load(jsonFile) for i, (todolist, idvalue, idname, iddescription, listdescription, listname. descriptionname, titlename, summary, duedate, imagepath, tasktags) in enumerate(data): a =. d =. #create empty table. table=csv.writer(open("output.csv", "wb"))
#write table into file. table.writerow(d) #save file with correct extension. filename = "output.csv" path = os.expanduser(os.join(
os.curdir, filename)) print(filename). os.rename(path, filename) But when I run it, there is an error saying: UnicodeEncodeError: 'ascii' codec can't encode characters in position 1-15: ordinal not in range(128). The error happens when I write the csv into file. When I open my script in Terminal I get this message: Traceback (most recent call last): File "csvtotable.py", line 14, in