How to Fix Excel Get Data From Web Preview Too Complex Error
Question details
The user needs to bypass an error preventing web data import because the target webpage uses JavaScript rendering instead of structured HTML.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Importing online tabular data into a spreadsheet using the Get Data from Web feature.
- Observed behavior
- The Power Query Navigator displays the message 'The current preview value is too complex to display' and fails to create a usable table.
Verify that the target webpage contains standard HTML tables; if the page requires interaction or takes time to load its text, it is likely JavaScript-heavy and incompatible with basic web scraping.
Use Alternative Data Sources (API or Direct Download)
Since Excel's Power Query cannot execute JavaScript to render dynamic pages, look for structured data files or APIs provided directly by the website.
When a webpage relies almost entirely on JavaScript, Power Query retrieves only the structural HTML code rather than the actual tabular data you see in your browser. To extract this information successfully, you must locate the raw data source the webpage itself is using.
Look around the webpage's data table for native 'Export to CSV', 'Download Excel', or 'Save Data' buttons provided by the site administrators.
Search the website for a 'Developer' or 'API' section. Many data-heavy websites offer free API endpoints that output clean JSON or XML.
In Excel, go to the Data tab. Instead of choosing 'From Web' for the webpage URL, select 'From Text/CSV' for downloaded files, or use 'From Web' to paste the specific JSON API endpoint URL.
Process Downloaded Web Data Seamlessly with WPS Office
While automated web scraping of dynamic sites requires specialized tools, WPS Spreadsheet provides a remarkably fast, free, and lightweight platform to clean, analyze, and format your downloaded CSV or JSON exports with full Microsoft Excel compatibility.
- 1. Install WPS Office: Download and install the free WPS Office suite on your computer.
- 2. Open WPS Spreadsheet: Launch WPS Spreadsheet and click on 'Open' to browse for your exported web data.
- 3. Import your CSV or JSON: Navigate to the Data tab and use the 'Import Data' function to easily parse and format your downloaded web files into a structured spreadsheet.

Frequently Asked Questions
Why does Excel say the preview value is too complex to display?
This message triggers when the Power Query Navigator encounters a webpage structure it cannot parse into a table. This almost always happens because the site uses JavaScript to load its data dynamically rather than embedding it directly in the static HTML source code.
Can Excel's Power Query execute JavaScript to scrape a site?
No. The standard 'Get Data from Web' feature only reads the static HTML returned from the initial page request. It does not contain a browser engine capable of running JavaScript or waiting for dynamic content to load.
How can I import data if 'Get Data from Web' doesn't work?
You can download the data manually if the site offers a CSV export, use a web scraping extension in your browser, connect directly to the site's API, or use a programming language like Python (with Selenium or Playwright) to scrape the data before importing it into Excel.




