Import JSON Data Into Excel 2016 Using a Get & Transform Query

Connecting Excel 2016 with JSON data is easy. Using Get & Transform (formerly PowerQuery) allows you to write a query to create a table from your JSON data.

[uKAADAAM]

5 years later and you still svaing people with this. Thank you broskie

[ChrisTurchin]

quite useful, i kept missing the "expand table" until watching your video, many thanks!

[abellavoz]

very helpful indeed, thank you. Im connected to the supervising banking authority here, after watching this I was able to convert the information we have access to into manageable excel data. once again I am greatly thankful

[aparnabravo]

Mannn! Thank you so much...I have made an API query whose results are in Json, have written several codes in python and have broken my head and spent 3 sleepless nights, didn't know the solution was in excel itself and is so simple and intuitive, you saved me so much time...Thanks a ton!!!

[scottnc]

Thank you for this. Microsoft documentation leaves out some critical steps, but you covered it clearly and concisely. Thank you.

[avreddy]

Thanks a lot it's very useful to me. After converted to excel and sent to my boss. She is appreciated to me.

Am trying to convert last five days.
But, finally today simply converted to excel.
blessed because of you.


Thank you much. God bless you man.

[Structed]

Thank you very much for this nice and short explanation! I like that you can also do sub-record expansions, too!

[gp]

Thanks for this awesome video! I used 'From Text' because I don't have the json choice, but it still worked as you describe.

[p.y.l]

JESUS Thank you so much I've been doing it for 3 hours straight and your video just nailed it.

[moreylongo]

You are an absolute lifesaver. Thank you man keep up the good work!

[ExcelDevious]

Hello Ryan, extremely helpful video with clear audio that is very well understood. A rarity on the web. Great job!

[NinjaLifeCrisis]

Thanks for this video... It helped a lot and was straight to the point! Great job!

[cd-uxot]

Thank you it took me forever to find the video I wanted.

[lucidresonance]

This is exactly what I needed to figure out! Thank you so much!!

[keepinitreal]

Very Helpful video. Thanks Brother. You should make tutorials more often, very descriptive, good speed and helpful.

[MarekVacek]

Descriptive, to the point and it worked. Thank you!

[hakannormann]

Good demo, short and spot on!
All steps there.

[billandpech]

Well explained for what I need now. Thanks!

[benstanhope]

This video was extremely helpful, thank you

[renegadeuvfunk]

This is really useful, I wasn't aware of the query editor in Excel.