How To Import A Table From A Website Using Power Query

For our example we’re going to pull the historical share prices for Apple Inc. These can be found here: https://www.google.com/finance/historical?q=NASDAQ%3AAAPL

We are going to import this entire table into Excel using Power Query. Power Query makes this type of data grabbing very easy, quick and painless.

To import the data:

In the Navigator window:

Now the data will appear in your sheet. If you need to refresh the data all you need to do is go to the Data tab and hit the Refresh button.