Connect to a web page

With Power Query, you can access and discover data in a web page that can be combined with data within your organization. To learn more about how to import data from a web page into Excel, see Power Query 101.

  1. In the POWER QUERY ribbon tab, click From Web.
  2. In the From Web dialog box, enter a Web page URL..
  3. Click OK.
  4. If the web page requires user credentials:
  1. In the Access Web dialog box, click a credentials option, and provide authentication values.
  2. Click Save.

Formula Example

= Web.Page
(Web.Contents("http://en.wikipedia.org/wiki/UEFA_European_Football_Championship"))

 
 
Applies to:
Excel 2013, Excel 2010