Fix Excel Power Query Showing No Tables When Importing Web Data
Question details
The user needs to import website table data into Excel when Power Query no longer detects the expected tables.

- 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.
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.
Check the Website and Update Excel
Use these checks to determine whether the issue is specific to the website or related to Excel.
Open the source URL in your browser and verify that the table still exists and has not moved to another page.
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.
Where available, select File > Account > Update Options > Update Now, then restart Excel and try the web import again.
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.

Import the Website's Underlying Data
Use a data feed, API, or downloadable file when the visible web table is not detected.
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.

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.




