How to load Complex Json Files into Excel

Struggling to process that Json with arrays and multiple hierarchies?
ExcelChef - 21/101 - Loading Json into Excel
This is the 21st video in the ExcelChef 101 Series. 80 more to go...
What excel topics would you like me to post? Share your feedback in the comments. 📢 Please share this post with friends and colleagues - Who knows you might help them decrease their excel workload!
Checkout my email course in Hands-On Business Analytics - hi.switchy.io/...
#excelskills #exceltips #exceltutorial #exceltricks #excel #msexcel #excelonline #exceltraining #excelformulas #exceltipsandtricks #exceldataentry #powerquery #PowerBI #PowerPivot #webscraping #Pivottables #datanalysis #datadna

[@karelsoukup2740]

Thank you. You helped me to make my query faster.

[@nathanmk5420]

nice details. Transpose, make top line column lines and the gold was pivot columns is game changer.

[@jreyscar]

Thank you. Your video helped me figure out how to extract json file from federal code of regularions. It had multiple lists and your methodology helped a lot.

[@Jennifer-yz8xw]

Thank you, It worked for me, was trying to figure it out for so long.

[@the-excel-chef]

Great to hear!

[@profanegardener]

Great video - very clearly explained. Thanks!

[@the-excel-chef]

Glad you enjoyed it!

[@rmznovali]

Thank you ver much this was really helpful.

[@joelcampos3073]

Thank you. Excellent explanation!

[@antojaj]

Thank you bro, This is super simple explanation for loading a complex json to excel. Easy to understand and apply. Thanks very much.

[@Kokhtyrev]

Thanks! I have been looking for this for a long time. I could not guess to use "Use First Row as Headers"

[@rolfvanstrien8725]

Super helpful - thank you very much!

[@the-excel-chef]

Thanks. Your comments are getting me charged to restart my series of videos. What are some topics you would love to see?

[@TheLevinski]

Really helpful, thanks!

[@Khan_2025]

thank you

[@AdvocateChamber]

Wonderful

[@dkishan8606]

Thanks man, Its very useful

[@BZaildar]

Thank you for the video. How do I Split Jason file to multiple CSV worksheets due to the very large size of JASON file?

[@sandeeepkiran1130]

This is perfectly what I needed.
Can someone link a different video on how to do the exact same.
But via python?
I.e, take the json file, and output should be the same at this video.

[@grahammacleod2906]

Thanks for this. The "top" results by google really didn't clearly and concisely explain how to flatten the various data structures in the JSON like you have done.

[@selviponnuswamy4303]

Do you have a video for converting from excel to Json?

[@hvanderveldeboz]

what version of Excel are you using ?

[@markbradwaybennett]

All the other videos missed the transpose step

[@kishanmaurya4865]

possible to write multiheader in excel usning node js

[@feverpa]

This still isn't working for me. You covered more than other videos, but I'm still not getting all of the data. When I bring in the JSON file, I'm seeing12 lines - and it's all of the information from the "header" section of the JSON. The actual important data just doesn't seem to be accessible. Even when I transpose the data, and go digging into each section - the important stuff just isn't there. Could this be because my data provider (what's kicking out the JSON) isn't formatting it quite correctly for this process?

[@susank6122]

I have same problem