If the webpage contains live data, it will update the query with that live data each time we click refresh. Give the query a useful name, such as FXRatesĬlick Home -> Close and Load to push the data into Excel. When the Power Query Editor loads it contains all the currency data.
Once you have found the right table, click Transform Data. We must click through each until we find the one we want. As web tables from websites can have poor naming conventions, it’s not always clear which table we need. The next window to appear will be the Navigator window. Paste the URL we copied earlier into the URL box and click OK. Copy the URL, then in Excel click Data -> Get Data -> From Other Sources -> From Web Hmmm… I wonder if we could use that in a more advanced way? USD&date= Īnyway, before getting onto the more advanced, let’s start with the basics. If you look closely, it contains the currency code and the date within the URL. The most useful part of the screenshot above is the URL. The website contains pages which display the exchange rates for any currency on any date. Basic web importįor the purpose of this exercise, we will be using to import exchange rates into Power Query. Power Query can do a lot, but the website has to be in a reasonably usable format to begin with.Īnyway, enough talk, time to import some data from the web. While you might get excited at the thought of absorbing data from everywhere with the click of a button, it’s not a silver bullet. However, just because the data is there does not make it easy to get at In this post, we’ll look at how we can load web data into Power Query. The web is a vast place with so much information.
0 kommentar(er)
