How to Fix Excel Compatibility Errors When Importing Web Data
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.

- 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.
Verify that your computer has an active internet connection and that the target webpage contains properly structured HTML tables for extraction.
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.
Search for 'Internet Options' in your Windows Start menu and open the control panel applet.
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'.
Under the 'Websites you've added to Compatibility View' list, select the website you are trying to import from and click 'Remove'.
Uncheck the box labeled 'Display intranet sites in Compatibility View' and click 'Close'.
Close Microsoft Excel entirely, reopen your workbook, and attempt the web query import again.
Use Power Query to Extract Web Data
Modern Excel versions use Power Query for web data extraction, bypassing legacy Internet Explorer compatibility issues entirely.
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. Open WPS Spreadsheets: Launch WPS Office, open a new or existing spreadsheet, and navigate to the 'Data' tab on the ribbon.
- 2. Select Import Data: Click the 'Import Data' button and choose the 'Import Data' option from the drop-down menu.
- 3. Choose Data Source: Select 'From Web' in the data import wizard and paste the URL of the target webpage.
- 4. Select the Table: Once the page loads, click the visual indicators (usually yellow arrows) next to the tables you wish to extract.
- 5. Confirm and Import: Click the 'Import' button, choose the destination cell in your worksheet, and click 'OK' to finish the process.

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.




