How to Fix Excel Web Import Not Showing Dynamic Web Data
Question details
The user is trying to import race card and odds data into Excel from a website, but the data does not appear in the web import tool.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Attempting to pull live or script-generated web data into a spreadsheet using the 'From Web' data connector.
- Observed behavior
- The Excel Web view only displays limited content and unrelated tables, failing to expose the dynamic horse and odds information visible in standard browsers.
Verify if the target website offers an official CSV/Excel export button or a public API, as these are the most reliable ways to import dynamically generated data.
Use an Official API or Direct Data Feed
Bypass the limitations of Excel's web scraper by connecting directly to the API that feeds the dynamic data to the webpage.
Excel's 'From Web' connector relies on static HTML tables. When a website uses JavaScript to load data dynamically (such as live odds or stock prices), Excel cannot render it. Relying on the underlying data feed or an official API ensures accurate and reliable data extraction.
Open the webpage in Chrome, press F12 to open Developer Tools, navigate to the 'Network' tab, refresh the page, and look for XHR/Fetch requests returning JSON or CSV data.
In Excel, go to Data > Get Data > From Other Sources > From Web, and paste the direct API URL instead of the main website URL.
Once connected, the Power Query Editor will open. Use the 'To Table' and 'Expand' buttons to convert the JSON records into a structured spreadsheet format.

Utilize Third-Party Web Scrapers
If no API or direct export is available, use a dedicated browser extension that can read JavaScript-rendered tables.
Manage Your Exported Data Easily with WPS Office
While extracting dynamic web data requires APIs or scraping tools, managing and analyzing your exported CSV files is seamless with WPS Office. Enjoy a free, lightweight spreadsheet tool that handles massive datasets with ease.
- 1. Download and Install WPS Office: Get the free WPS Office suite from the official website and install it on your device.
- 2. Open WPS Spreadsheets: Launch the application and select Spreadsheets to begin managing your data.
- 3. Import Your Data File: Go to Data > Import Data to seamlessly load the CSV or API data you extracted from the web.

Frequently Asked Questions
Why doesn't Excel's 'From Web' tool see all the tables on a webpage?
Excel's basic web connector parses static HTML source code. If a table is generated dynamically by JavaScript (which is common for live odds, dashboards, or stock sites), the connector cannot render or detect it.
Can Power Query execute JavaScript to load dynamic data?
Native Power Query does not have a browser engine to execute JavaScript and render dynamic web pages. You must connect directly to the background data source (like a JSON API) or use an external scraping tool to bypass this limitation.
How do I find the hidden API URL for a dynamic web table?
You can use your browser's Developer Tools (F12). Navigate to the Network tab, filter by 'Fetch/XHR', refresh the page, and inspect the files loading the data. Right-click the relevant request to copy its URL, which you can then plug directly into Excel's web import tool.




