Power Query Problems

Fix Excel Power Query Showing No Tables When Importing Web Data

Maira MehtabMaira Mehtab Nov 18, 2026 870 views

Question details

The user needs to import website table data into Excel when Power Query no longer detects the expected tables.

Fix Excel Power Query Showing No Tables When Importing Web Data
Product
Microsoft Excel Power Query
Device & OS
not provided
Scenario
Importing data from a website after an Office update.
Observed behavior
The Power Query Navigator may show only Document instead of the expected website tables.
Before you start

Open the website in a browser and confirm that the expected table is still available. Check whether the issue occurs with other websites and note when it began.

Solution 1Recommended

Check the Website and Update Excel

Use these checks to determine whether the issue is specific to the website or related to Excel.

1
Check the source page

Open the source URL in your browser and verify that the table still exists and has not moved to another page.

2
Test another website

In Excel, select Data > Get Data > From Other Sources > From Web and try a different page with a known HTML table. Menu names may vary by Excel version.

3
Install Office updates

Where available, select File > Account > Update Options > Update Now, then restart Excel and try the web import again.

4
Report a widespread issue

If the problem began after an update and affects multiple users, use Help > Feedback to report it to Microsoft. Ask your IT administrator about a supported rollback rather than attempting one without organizational guidance.

Check the Website and Update Excel
Dynamic pages may not expose tables: A table visible in a browser may be loaded by scripts after the page opens. The Power Query web connector may not detect it as an HTML table.
Free Microsoft Office alternative

Work With Imported Tables in WPS Spreadsheet

WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheet data. Open compatible Excel files or exported data in WPS Spreadsheet for an easy transition; it does not repair Excel's Power Query web connector.

Open and edit Microsoft Excel XLSX and XLS files.Work with website data exported to a spreadsheet or CSV file.Use a familiar spreadsheet interface for a smoother migration.Access a free, lightweight office suite.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Query show only Document instead of a table?

The website may have changed its structure, or the visible table may be loaded dynamically by scripts. Check the page in a browser and look for a data feed, API, or downloadable file.

How do I update Excel after this issue appears?

Where available, select File > Account > Update Options > Update Now. Restart Excel and retry Data > Get Data > From Other Sources > From Web.

Can I import website data without detecting an HTML table?

Yes. If the site offers a CSV file, data feed, or API, use the matching option under Data > Get Data. You can then transform the result in Power Query Editor.

Should I roll back Office if an update caused the problem?

If multiple users are affected, report the issue through Help > Feedback and consult your IT administrator. Use a supported rollback only under organizational guidance.