Data Import & Export

How to Fix Excel Compatibility Errors When Importing Web Data

Adam DavisAdam Davis Nov 4, 2026 871 views

Question details

The user is encountering a compatibility error in Excel when attempting to import tabular data from a web page using the legacy web query tool.

How to Fix Excel Compatibility Errors When Importing Web Data
Product
Microsoft Excel
Device & OS
not provided
Scenario
Importing data from a web page into an Excel spreadsheet using the built-in Web Query Browser.
Observed behavior
Excel displays a compatibility error and fails to highlight or import the tables properly, primarily because the web query browser defaults to Internet Explorer Compatibility Mode.
Before you start

Verify that your computer has an active internet connection and that the target webpage contains properly structured HTML tables for extraction.

Solution 1Recommended

Disable Internet Explorer Compatibility Mode

Disabling Compatibility View in your system's internet settings prevents the legacy Excel web query tool from rendering pages using outdated browser engines.

Older versions of Excel rely on the underlying Internet Explorer engine to run web queries. When Compatibility Mode is triggered, the browser fails to support modern scripts and table highlighting functions, resulting in the import error.

1
Open Internet Options

Search for 'Internet Options' in your Windows Start menu and open the control panel applet.

2
Modify Compatibility View Settings

If you are using an older version of Windows with Internet Explorer installed, open IE, click on the Gear icon (Tools), and select 'Compatibility View settings'.

3
Remove Target Website

Under the 'Websites you've added to Compatibility View' list, select the website you are trying to import from and click 'Remove'.

4
Uncheck Intranet Settings

Uncheck the box labeled 'Display intranet sites in Compatibility View' and click 'Close'.

5
Restart Excel

Close Microsoft Excel entirely, reopen your workbook, and attempt the web query import again.

Legacy Browser Support: Because Microsoft has retired Internet Explorer, legacy web queries may still struggle with modern websites. Upgrading to a modern import method is highly recommended.
Seamless Web Data Import

Import Web Data Effortlessly with WPS Office

Avoid legacy browser compatibility errors by using WPS Spreadsheets to quickly, securely, and accurately import table data from web pages.

  1. 1. Open WPS Spreadsheets: Launch WPS Office, open a new or existing spreadsheet, and navigate to the 'Data' tab on the ribbon.
  2. 2. Select Import Data: Click the 'Import Data' button and choose the 'Import Data' option from the drop-down menu.
  3. 3. Choose Data Source: Select 'From Web' in the data import wizard and paste the URL of the target webpage.
  4. 4. Select the Table: Once the page loads, click the visual indicators (usually yellow arrows) next to the tables you wish to extract.
  5. 5. Confirm and Import: Click the 'Import' button, choose the destination cell in your worksheet, and click 'OK' to finish the process.
Bypass legacy Internet Explorer compatibility errorsFully compatible with Microsoft Excel (.xlsx) formatsLightweight, fast, and completely free to useIntuitive data import wizard for seamless extraction
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel use Internet Explorer for web queries?

Older versions of Microsoft Excel rely on the underlying Internet Explorer engine installed on Windows to render web pages and extract data. Since modern websites no longer support IE, this frequently leads to compatibility errors and script warnings.

How can I extract data without using the legacy web query tool?

In modern versions of Excel, you can use Power Query by navigating to the Data tab and selecting 'From Web'. This feature uses a current rendering engine that effectively avoids old compatibility mode limitations.

Can I import data from a password-protected website?

Yes, but you will need to authenticate first. When using modern import tools like Power Query, a prompt will appear asking for your credentials (such as a username and password or API key) before the tool can access and extract the private data.