Summary
This post shows you how to use a website in Excel by displaying a live web page over the grid or importing its table data into cells.
Displaying an interactive page (such as a map) and importing rows for formulas use different tools. Choose one approach:
- Option A: Load a live page with Web Viewer 2.0. Insert Web Viewer 2.0, load the page's HTTPS or embed URL, and position the viewer beside your cells. You can interact with the live page, but its contents do not become worksheet cells.
- Option B: Import a web table with Power Query. In Excel for Windows, open Power Query's From Web connector, enter the page URL, select a detected HTML table, and select Load to populate worksheet cells.
Option A: Load a live page with Web Viewer 2.0
Insert Web Viewer 2.0 in your workbook
- Select a cell, then open Home > Add-ins.
- Enter Web Viewer 2.0 in the search box (1). Under More search results, select Add beside the matching result (2).
Complete any installation prompts. For other Office versions or organization-managed installation, see the full installation guide.
Load the page
- Select www at the top left of the viewer, paste the website's full HTTPS address into URL, and select Load. For a map, use the Google Maps embed address.
- Drag the viewer's border to position and resize it beside your data, then interact with the page inside the frame.
When starting from an HTML <iframe> snippet, paste only the
src="..." URL into the viewer rather than a worksheet cell. If a site blocks
embedding, select Load when
Web Viewer 2.0
offers a supported alternative, or
check why the site blocks embedding.
For help with Web Viewer 2.0, contact support.
Option B: Import a web table with Power Query
Open your workbook in Excel for Windows; the available Power Query connectors differ on Mac and the web. The worked example below imports World Cup results from Wikipedia.
- Select Data > From Web.
-
Enter the page URL (such as
https://en.wikipedia.org/wiki/FIFA_World_Cup) and select OK.
- In Navigator, select the table you need (such as Results) to preview its columns.
- Select Load to insert the data as a filterable Excel table.
Power Query imports structured rows rather than the website's layout or interactive controls. Select Data > Refresh All to pull updated rows from the source page.