Posted on

How to Parse JSON Data using Excel and PowerQuery

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 analysed in Excel. You can download the data to practice along with this video from the blog.

The Excel Club Blog has been powered with #STEEM. That means we are a tokenized website and you can earn while you learn Excel, PowerBI and DAX. All you have to do is engage with the post on The Excel Club Blog, so if you have any questions or comments I would encourage you to post them on the blog and not here on the video

Sign up to our newsletter

Watch more Power BI videos

Watch more Excel Videos

#share2steem #excel #json #steem #exceltips #tutorial


Xem thêm bài viết khác:

2 thoughts on “How to Parse JSON Data using Excel and PowerQuery

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

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

Leave a Reply

Your email address will not be published. Required fields are marked *