Import data from the web

What is the web connector for Excel?

The From Web connector in Excel (part of Get & Transform / Power Query) is a powerful tool that allows you to connect to websites and import data into your Excel workbook. The web connector leverages the strength of Power Query in Excel to connect to external web data sources, preview structured results, and load or transform the data in your workbook. You can also refresh your data connection to get the latest updates from the selected websites.

Advanced features in the web connector for Excel

Suggested Tables: Provides auto-detection of tables and will suggest tables, so you can easily structure your data.

Add Table Using Examples: Allows you to provide examples of what you want your data to look like, and select from AI-generated table structures based on the examples provided.

Note: These tools are also available in Power BI.

How to get started

The web connector is available as part of Excel Microsoft 365. You also need to have an internet connection to access the web data sources. The following instructions describe how to connect to a website, select data, and bring that data into Excel.

Open Excel and create a new workbook or open an existing one.
Go to the Data tab and select From Web (or Get Data > From Other Sources > From Web)
Enter the URL of the web page from which you'd like to extract data.
When you select OK, you're taken to the Navigator dialog box where you can see Suggested Tables, which are autodetected tables from the Web page. In the case shown in the image below, 5 tables were found.
Alternatively, you can use the Add Table Using Examples feature, which presents an interactive window, where you can preview the content of the Web page. Enter sample values of the data you want to extract.
In this example, you'll extract the Name and Price for each of the games on the page. You can do that by specifying a couple of examples from the page for each column. As you enter examples, Power Query extracts data that fits the pattern of example entries using smart data extraction algorithms. Note: For more information, see Get webpage data by providing examples.
Once you're happy with the data extracted from the Web page, select OK to add the data to the list, and select the custom table that was created
You can use Transform Data to shape your data with the Power Query Editor, or Load to load the data to the Excel grid. Your query connection can be refreshed to keep the imported data up to date. For more information about Power Query in Excel, see Power Query for Excel Help.