Power Query Problems

How to Fix Excel Get Data From Web Preview Too Complex Error

Muhammad TalhaMuhammad Talha Nov 11, 2026 869 views

Question details

The user needs to bypass an error preventing web data import because the target webpage uses JavaScript rendering instead of structured HTML.

How to Fix Excel 'Get Data from Web' Preview Too Complex Error
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.
Before you start

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.

Solution 1Recommended

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.

1
Check for export buttons

Look around the webpage's data table for native 'Export to CSV', 'Download Excel', or 'Save Data' buttons provided by the site administrators.

2
Locate an official API

Search the website for a 'Developer' or 'API' section. Many data-heavy websites offer free API endpoints that output clean JSON or XML.

3
Import the structured data

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.

Pro Tip for Advanced Users: You can press F12 in your web browser to open Developer Tools, go to the Network tab, and refresh the page to identify the exact background JSON data URLs the website calls. You can then feed that specific URL into Excel.
Free Microsoft Office alternative

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. 1. Install WPS Office: Download and install the free WPS Office suite on your computer.
  2. 2. Open WPS Spreadsheet: Launch WPS Spreadsheet and click on 'Open' to browse for your exported web data.
  3. 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.
Free to download and use for all essential data analysis tasksSeamlessly compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Lightweight architecture ensures fast loading of large data filesFamiliar ribbon interface requires zero learning curve
microsoft office alternative - wps office

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.