How to Parse JSON Data using Excel and PowerQuery

Показать описание

#excel #powerquery #json
Excel is a powerful tool that allows you to connect to JSON data and read it. However, sometimes this data might require a little manipulation to be fully understood and analyzed in Excel.
In this video you will learn how to Parse JSON data using Excel and Powerquery.
You can download the data to practice along with this video from the blog.

Sign up to our newsletter

Watch more Power BI videos

Watch more Excel Videos

#excel #json #steem #exceltips #tutorial
#powerquery

Рекомендации по теме

Комментарии

This was very helpful. My boss was impressed with me.

kalpeshghadigaonkar

Thank you, +1 in my learning. I used to do the same thing but I used to load data in PBI do the parsing and then download the data, here I learned how I can directly do the same thing without having PBI installed in my machine. Thanks a lot Paula for making this video tutorial

chandrakantkumar

Very interesting. Thanks. Pardon me for pointing this out, but you are using the work "phrase" when you should be saying "parse" which means to break apart. It confused me at first until I realized when I zoomed in what menu option you were clicking.

pbv

This was super helpful. Thank you so much for doing this!

peteallennh

This was very helpful! What I did was to duplicate a column and then use different method to get the data in the metadata column. Thinking back, I think your method is better with this example data.

cyeungko

Paula when I dont know the data in json file, How would I know column headings and data type in each cell while transforming in power query ? Also when I converted json file to excel multiple work sheets are there. HOw can I get to know in power query that data exists in multiple work sheets.

Sai-jhti

How would you then reverse this back into JSON and re-import back into the originating system as a way to update the data?

scottgoessling

Thank you Very much. This helped me a lot

kishore

Thank you, it's working for my case.

YugoGautomo

Link doesn't work and file doesn't exist in drop box. Would be very grateful to have them updated

joshuariley

Thank you so much!! Your video was a great help to me :D

jinalkhakharia

Thanks for sharing. It solved a thorny problem :).
The blog link you shared above is blocked by Chrome with the message "this page is trying to load scripts from unauthenticated sources". You might want to look into that.

varunsharda

Thank you for this tutorial. My json is array of pairs, field_name and field_value.How to parse that field_names become columns and field_value is the value in those columns? Thank you!

VenelinUstabashiev

Thank you, this is very helpful!!! <3

StriderAngel

Great. Thanks. Btw nice Irish accent. :-)

e.istvan

4:06 lolwat? It's "parse" not "phrase" 🤣

aditsu

How to Parse JSON Data using Excel and PowerQuery

JavaScript JSON Parse Tutorial - What is it and how to use it?

Learn JSON in 10 Minutes

Python JSON Parsing: A Step-by-Step Guide to Extract Data from JSON

How to Parse JSON with Power Query in Excel

Parse JSON in PHP | How to validate and process nested JSON data

How to Parse JSON in Python - JSON Tutorial for Python Beginners

How to Parse JSON Data in C# - Coding Gems

Parse and Query JSON Data with SQL

JSON Tutorial For Beginners - Full Course

IMPORTJSON: A simple Google Sheets function to parse JSON data in a flash

Parse JSON Into Class In Python - The Clean Way

JSON Python tutorial: what is JSON and how to parse JSON data with Python | Python tutorial

3 Simple & Easy Ways To Parse JSON in JAVA/ How to Parse JSON in Java in 2020

How to Parse JSON in Java Spring Boot

Extract or Parse JSON Data with Power Query

Integromat: How to 'Parse Json' (for beginners)

How To Use JSON In Python

Parsing Json in Java Tutorial - Part 1: Jackson and Simple Objects

How to parse JSON with VBA-JSON

Parsing JSON strings : JSON.parse()

Faster apps with JSON.parse (Chrome Dev Summit 2019)

How to parse JSON data using C# 🔥🔥

Parse JSON document using JSON functions provided by SQL Server

Import and parse JSON in Power BI