Excel Power Query Web Connector: How to Import Data

How-to basics · Updated November 22, 2026

The Excel Power Query web connector is a built-in feature that lets you import data from a webpage directly into Excel, using the URL of the page as the connection source. You can pull tables, lists, and even entire pages, then transform and refresh the data as needed.

What Is the Power Query Web Connector?

Power Query (called “Get & Transform Data” in Excel) is a data connection and transformation tool built into Excel for Microsoft 365, Excel 2021, and Excel 2019. The web connector is one of its many data sources. It allows you to connect to a public webpage by entering its URL, then choose which parts of the page to import—usually tables or lists that Power Query detects automatically.

Once connected, you can load the data into an Excel worksheet, or keep it only in the Power Query editor for further cleaning. The connection is refreshable, meaning you can update the data from the same URL at any time without re-copying it manually.

How to Use the Web Connector in Excel (Step by Step)

Here’s the exact process for Excel for Microsoft 365 on Windows. The steps are similar on Mac, but the ribbon labels differ slightly (for example, “Data” tab is the same, but some buttons are in different locations).

  1. Open a blank or existing worksheet.
  2. Go to the Data tab.
  3. In the Get & Transform Data group, click From Web.
  4. In the dialog box, enter the full URL of the webpage (e.g., https://en.wikipedia.org/wiki/List_of_countries_by_population).
  5. Click OK. Excel will attempt to connect and show a preview of the page’s content.
  6. In the Navigator pane, you’ll see a list of detected tables and other elements. Select one to preview it on the right.
  7. Click Load to import it directly to a worksheet, or Transform Data to open the Power Query editor and clean it first.

On a Mac, the path is Data tab > From Web (in the Get & Transform group). The rest of the steps are the same.

What Types of Web Content Can You Import?

The web connector is designed for structured data. It works best with:

  • HTML tables – the most common, like data tables on Wikipedia or government statistics pages.
  • Lists – ordered or unordered lists (<ol> or <ul>) that appear as separate items.
  • Entire page as text – you can also choose “Document” in the Navigator to import all text content, but that is usually messy and harder to use.

It does not work well with JavaScript-rendered pages (like many modern dashboards) because Power Query only sees the static HTML that the server sends. If the data is loaded dynamically via JavaScript, the connector may show nothing or only the page’s shell.

Refreshing and Managing Your Web Connection

Once you load data, Excel stores the connection. To refresh it manually, right-click anywhere in the imported table and choose Refresh, or go to Data > Refresh All.

You can also set automatic refresh intervals, but only if the workbook is stored in OneDrive or SharePoint and you use Power Automate flows—a more advanced feature. In a regular local file, you can only refresh manually or when opening the file (if you set that option in the connection properties).

To manage the connection: go to Data > Queries & Connections (or Data > Connections on Mac). You can see all queries, edit them, or delete them.

Common Problems and How to Fix Them

Several issues are common when using the web connector:

  • Nothing appears in Navigator – the page is likely JavaScript-rendered. Try a different URL that serves static HTML, or use a browser extension to view the page source and check for tables.
  • “This webpage is not accessible” error – the site may block automated requests, or the URL is incorrect. Double-check the URL, and try opening it in a browser first.
  • Data changes every refresh – that’s normal if the site updates frequently. If you need a snapshot, consider copying the data as values (Paste Special > Values) after loading.
  • Tables are not detected – some pages use div-based layouts instead of proper HTML tables. Power Query can’t detect those as tables. You might need to use the “From Web” connector with a custom parser, but that requires M code.
  • Refresh fails after a while – the website may have changed its structure. Edit the query in the Power Query editor to re-map the columns.

Web Connector vs. Other Data Import Methods

Excel offers several ways to get web data. The Power Query web connector is the most flexible for ongoing, refreshable imports. Here’s how it compares:

  • From Web (legacy) – the old “From Web” wizard that used Internet Explorer components. It’s deprecated and less reliable.
  • Copy and paste – quick for one-time data, but not refreshable and often messy.
  • Power Query from other sources – you can also use APIs (via “From Web” with an API endpoint) or connect to databases, which is more stable but requires more setup.
  • Third-party add-ins – some paid tools offer more advanced scraping, but Power Query is free and built-in.

Costs and Safety Considerations

The web connector itself is free—it’s part of Excel. However, you need a version that includes Power Query: Excel 2016 or later, or Microsoft 365. There’s no extra cost for the feature.

Safety-wise, be cautious about importing data from untrusted websites. The connector only reads data; it does not execute scripts or download files. However, the data itself could contain malicious links or misleading information. Always verify the source and be careful if you later use that data in formulas that might trigger actions (like hyperlinks).

Also note that some websites prohibit automated access in their terms of service. While using Power Query to view public data is generally fine, avoid hammering a site with frequent refreshes, and respect robots.txt or rate limits if you’re building a large solution.

Frequently Asked Questions

Can I import data from a webpage that requires login?

Yes, but it’s tricky. The web connector doesn’t have a built-in login prompt. However, you can use the “From Web” connector with a URL that includes authentication tokens (like a session ID) if you have them. Alternatively, use Power Query’s “From Web” with an API endpoint that accepts an API key. For most sites, it’s easier to export the data manually.

Why does the web connector show “No tables found” for some sites?

Because the site may not use standard HTML tables—it might use JavaScript to render content, or use CSS grid/divs. Power Query only sees the initial HTML response, not the dynamically generated content. Try viewing the page source (right-click > View Page Source) and search for “

How do I refresh web data automatically every hour?

In a local Excel file, you can’t set a timer. However, you can create a Power Automate flow that refreshes the query on a schedule if the workbook is stored in SharePoint or OneDrive. Alternatively, you can use VBA to schedule a refresh using Application.OnTime, but that requires the workbook to be open.

Can I combine data from multiple web pages into one table?

Yes. In the Power Query editor, you can create a new query that references multiple web sources, then use the Append or Merge operations. For example, you could import two Wikipedia tables and combine them with “Append Queries” in the Home tab of the Power Query editor.

Is there a limit to how much data I can import from a web page?

Excel has a row limit of 1,048,576 rows per worksheet, but Power Query can handle more before loading. However, importing a huge table might slow down your workbook. It’s best to filter and reduce data in Power Query before loading.

Does the web connector work in Excel for the web?

No. The Power Query web connector is not available in Excel for the web. You can only use it in the desktop versions (Windows or Mac). If you need to refresh data in the browser, you’d need to use a different tool or an add-in.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.