Import from Web in Excel with Power Query

In this video, we will import exchange rate data from the web using Power Query.

This tool makes it easy to grab tabular data from a webpage. And then we can refresh this data in the future at the click of a button.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[robertreed]

I've been messing about trying to build a horse race system for 35 years but in 3days I'm finding things I never new keep up the good work

[robertreed]

I learn something new every time I look at your channel

[boza-fpmw]

Brilliant, but how do you get data that doesnt import with the url, for example, a home and away table in football. Any ideas would be great. I am stuck

[wayneedmondson]

Hi Alan.. great video. I'll be using this technique soon to pull US Consumer Price Index data which I previously did by Cut and Paste. Thanks for the great tips! Thumbs up!

[MrFreestyler]

Great video. Thanks a lot. I am working on something similar. I want to make a graph, displaying the values develop over over time, without having to plot the data manually. This video was a great help.

[ericrogers]

Hi, is there `away of doing this on a mac V16.26 as imported from the web is not there only import from HTML file, many thanks and regards

[mohideenthassim]

An excellent and useful video, many thanks Alan Cheers Mohideen

[origamicrane]

Can you do a video showing how to use VBA to go to a web page (for example, Yahoo Finance for company XYZ), download or import a .csv file on that page (of historical price data), return the .csv file contents to an Excel worksheet, find the closing price on a certain day, put that data into a column on another sheet and then repeat for one hundred or so other stocks?

[abt]

Sir i am facing a problem in powerquery while pulling data from web
it shows proxy server problem
what do i do sir ? i do my all work through power query

[DB-mglh]

Another doozy Alan, seems every other day you're multiplying my productivity! I've been tediously dragging and highlight for a copy/paste process, not much fun!

Bit of a hiccup on one of my main pages that I source data from however, being that the query only seems to return the top table from the page and doesn't seem to acknowledge the other 6 or so that i grab each day. Can this be overcome somehow, or is it just a symptom of that particular website's layout and can't be helped? Thanks either way, this will be useful on plenty of other sites!

[giftfurnito]

How can we fetch extract data table of orders from WordPress website, using power query, if website has credentials??

[TheSuvankarKundu]

It was so excellent.. But could you please help me in exporting the data if the website is password protected..

[Mahibul]

Which Excel version are you using please?

[norbertosanchez]

Can I use PowerQuery to access a web site that requires login and password? If so, how?