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!
----------------------------------------------------------------------------------------------------------------
PayPal Me: www.paypal.me/...
Venmo: @Jie-Jenn
JSON Data Generator: next.json-gene...
XlsxWriter: xlsxwriter.rea...
Source code: learndataanaly...
Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
Patreon: / jiejenn
By shopping on Amazon → amzn.to/2JkGeMD
More tutorial videos on my website → LearnDataAnaly...
Business Inquiring: [e-mail]
#Excel #Python #Tutorial #JSON

[@jasonphillips3817]

Awesome tutorial, I learned a lot!

[@ravenheartyajaira9930]

Great! Thank you

[@timodobie5968]

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

[@candicefernandes5455]

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

[@tahirkamal1878]

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

[@pimalanda7893]

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

[@jiejenn]

One Dark Pro + few customization.

[@pimalanda7893]

@@jiejenn Thanx Bro, can you explain customization ? I have install One Dark Pro but I dont have the same visual. I like this red blue and yello

[@sangeethnair4670]

Hello, please help with this error
number = record['number']
TypeError: string indices must be integers

[@aleksandrmolchanov1269]

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

[@jiejenn]

You Google.

[@ahmaddanish2664]

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

[@jiejenn]

Probably a typo. The function is "enumerate".

[@kakaji_cloud8106]

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

[@OmarGumaan]

did you find this

[@Imran20091990]

Wow

[@basthiaanathan]

share the json file

[@jiejenn]

Get your own.