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

📝 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

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[klsov]

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

[maxight]

Thank you a lot, all examples are very useful!

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

[TheLaopi]

Very good, Can you share the data ? Thks