Import JSON data to an Excel spreadsheet using Python

In this tutorial, we are going to learn how to import JSON data into an Excel spreadsheet using Python.

PS: To interact with an Excel spreadsheet, I will be using win32com Python library, which is Windows only.

Buy Me a Coffee? Your support is much appreciated!
----------------------------------------------------------------------------------------------------------------
Venmo: @Jie-Jenn

Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------

#Excel #Python #Tutorial #JSON

[timodobie]

Hey in 7:12, you insert 'tags' records if I do it with my json file my shell give back: "line 15, in <module>
tags = ', '.join(record['tags'])
TypeError: string indices must be integers

I hope you can help me and thank you

[pimalanda]

Hi Jie, thank you very instructive videos. What Color Theme do you use for VS Code ?

[candicefernandes]

What if my data type returns dict, how should I proceed?

[tahirkamal]

can you do a video about scraping data from a website with login on incognito mode, i don't know how

[sangeethnair]

Hello, please help with this error

number = record['number']
TypeError: string indices must be integers

[ahmaddanish]

hello can i ask, at minute 15:48, where do the 'enumarate' function come from? because when i run the code, it shows error saying that the 'enumarate' is not defined. pls help me thank you so much

[kakaji_cloud]

How can i get friends value id and name in separate column please help me

[aleksandrmolchanov]

hello, please tell me what to do if I have mail in one record and no mail in the other, but I want this field to be filled with a blank