How to load Complex Json Files into Excel

[@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!

[@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"

[@joelcampos3073]

Thank you. Excellent explanation!

[@rmznovali]

Thank you ver much this was really helpful.

[@Khan_2025]

thank you

[@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?

[@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!

[@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.

[@dkishan8606]

Thanks man, Its very useful

[@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.

[@AdvocateChamber]

Wonderful

[@markbradwaybennett]

All the other videos missed the transpose step

[@selviponnuswamy4303]

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

[@hvanderveldeboz]

what version of Excel are you using ?

[@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