Extract or Parse JSON Data with Power Query

Did you know Power Query can talk JSON? Well no they don’t actually talk to each other….but if you’re trying to pull those name-value JSON pairs from a text file or log file to put into a spreadsheet, you don’t need to write some Python script do this. And hopefully you ARE thinking twice about putting your company’s data into one of those free services on the Internet.
0:00 Intro
0:36 .json file Name-Value Pairs
1:30 JSON text file into separate rows
3:00 JSON text file into CSV
3:35 JSON Nested join to table
5:12 Log file with JSON Name Value pairs
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to
www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

[@maxight]

Thank you a lot, all examples are very useful!

[@DougHExcel]

Glad to hear that!

[@Juan-Hdez]

Very useful. Thank you.

[@DougHExcel]

Glad it was helpful!

[@user-ds2rm7hr3o]

You saved me! Thanks a lot!

[@DougHExcel]

You're welcome!

[@z.719]

Awesome 👍. Leard something new!

[@DougHExcel]

Thanks Z.围炉夜话, glad you liked!

[@klsov14567]

Hi Doug, its a wonderful session, but i am getting an error while i am selecting extracting values option, can you pls help me on this

[@MrOptima]

Hi Doug, this was a great video where you showed great samples and said all the right things. The video is even better if I play it at 75% speed as it gives me time to actually see what you just did before you move on to the next item. It kind of feels like you had 2 cups of coffee right before the recording. May I suggest a slightly more relaxed approach where everything is the same but you give us some time to ingest as you go? Again, this was a great presentation that exactly addressed what I was looking for. Thanks.

[@DougHExcel]

Thanks for watching and for the constructive feedback. I appreciate you!

[@TheLaopi]

Very good, Can you share the data ? Thks

[@CarlosDalton-uq3xs]

show