Data Import & Export

How to Fix Excel Web Import Not Showing Dynamic Web Data

Elise WilliamsElise Williams Nov 2, 2026 872 views

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.

How to Fix Excel Web Import Not Showing Dynamic Web Data
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.
Before you start

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.

Solution 1Recommended

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.

1
Locate the background data URL

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.

2
Connect Excel to the API URL

In Excel, go to Data > Get Data > From Other Sources > From Web, and paste the direct API URL instead of the main website URL.

3
Parse the data in Power Query

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.

Use an Official API or Direct Data Feed
Web Scraping Policies: Always ensure you comply with the website's Terms of Service when extracting data, as automated scraping or API usage may be restricted.
Free Microsoft Office alternative

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. 1. Download and Install WPS Office: Get the free WPS Office suite from the official website and install it on your device.
  2. 2. Open WPS Spreadsheets: Launch the application and select Spreadsheets to begin managing your data.
  3. 3. Import Your Data File: Go to Data > Import Data to seamlessly load the CSV or API data you extracted from the web.
Fully compatible with Microsoft Excel (.xlsx) and CSV formatsLightweight and fast data processing for large data setsBuilt-in data analysis, filtering, and pivot tablesFamiliar, user-friendly interface with no learning curve
microsoft office alternative - wps office

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.