How to Embed a Website in Excel

A spreadsheet grid

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 in your workbook

  1. Select a cell, then open Home > Add-ins.
Excel web Home and Add-ins controls marked 1 and 2
  1. Enter Web Viewer 2.0 in the search box (1). Under More search results, select Add beside the matching result (2).
Excel quick Add-ins menu with Web Viewer 2.0 search and Add highlighted

Complete any installation prompts. For other Office versions or organization-managed installation, see the full installation guide.

Load the page

  1. 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.
Excel worksheet with a Web Viewer 2.0 URL field containing a Google Maps embed address
  1. Drag the viewer's border to position and resize it beside your data, then interact with the page inside the frame.
Google Maps displayed as a live content add-in on an Excel worksheet

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.

  1. Select Data > From Web.
Excel for Windows Data ribbon with From Web selected
  1. Enter the page URL (such as https://en.wikipedia.org/wiki/FIFA_World_Cup) and select OK.
From Web dialog with the Wikipedia FIFA World Cup URL entered
  1. In Navigator, select the table you need (such as Results) to preview its columns.
Excel Navigator with the Results table selected and World Cup data previewed
  1. Select Load to insert the data as a filterable Excel table.
World Cup results imported into a filterable Excel worksheet 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.

Web Viewer 2.0 ยท 4.7 (111 reviews) on AppSource