Power Query Problems

Fix Excel Web Query Cannot Accept Cookie Pop-Up Error

Guest WriterGuest Writer Oct 8, 2026 874 views

Question details

Users are unable to extract web data using Excel's Get Data from Web connector because a cookie consent pop-up blocks the process.

How to Resolve Excel Web Query Failures Due to Cookie Pop-Ups
Product
Microsoft Excel
Device & OS
not provided
Scenario
Attempting to scrape or import data from a website into Excel using the built-in Power Query web connector.
Observed behavior
The web query stalls, returns incomplete data, or fails entirely because Excel's built-in connector cannot display or submit the required interactive cookie consent prompt.
Before you start

Verify that you have the proper rights to extract data from the target website, and check if the site offers an official API or direct export option.

Solution 1Recommended

Utilize Official Export Features or APIs

The most reliable way to bypass front-end interactive pop-ups is to use backend methods provided by the website.

Since Excel's Power Query engine cannot interact with dynamic website pop-ups, bypassing the user interface entirely is often the best solution. Many data-driven websites offer alternative ways to access their datasets without triggering cookie consent forms.

1
Search for an Export Button

Navigate to the webpage in your standard web browser. Look for native 'Export to CSV', 'Download Excel', or 'Download Data' buttons.

2
Check for a Developer API

Review the website's footer or developer documentation for an available API endpoint that delivers data in JSON or XML format.

3
Connect to the API in Excel

In Excel, go to the Data tab, click 'Get Data' > 'From Other Sources' > 'From Web', and enter the API URL instead of the standard webpage URL.

API Authentication: Connecting via an API may require an API key, which you can usually pass through the Web Query's Advanced settings under HTTP request headers.
Free Microsoft Office alternative

Experience Seamless Data Management with WPS Office

While Excel's web query tools may struggle with complex website cookie pop-ups, you can rely on WPS Office for a lightweight, free, and highly compatible alternative to handle your daily spreadsheet tasks, data formatting, and local file imports.

  1. 1. Download the Software: Visit the official WPS website and download the free WPS Office installer.
  2. 2. Install WPS Office: Run the setup file and follow the on-screen instructions to install the suite on your device.
  3. 3. Open Your Spreadsheets: Launch WPS Spreadsheet and seamlessly open any manually downloaded CSV or existing Excel files.
Free and lightweight alternative to Microsoft OfficeFully compatible with Microsoft Excel formats (.xlsx, .xls) and CSVFamiliar user interface requiring no steep learning curveRobust data analysis and local data management tools
microsoft office alternative - wps office

Frequently Asked Questions

Why does the Excel web query fail specifically on cookie pop-ups?

Excel's 'Get Data from Web' connector uses a background evaluation engine that does not support interactive front-end prompts. Because it cannot click 'Accept' or submit cookie consent forms, the data load process is blocked.

Can I use VBA to bypass the cookie consent prompt in Excel?

While traditional Power Query cannot bypass it, you can potentially write complex VBA scripts using Internet Explorer objects or modern Edge WebView controls to interact with the webpage. However, this requires advanced coding and is prone to breaking if the website updates its layout.

Will using Microsoft Power BI solve this cookie pop-up issue?

No. Power BI utilizes the same underlying Power Query engine as Excel. Consequently, it typically encounters the exact same limitations when confronted with interactive website cookie consent forms.

Are there any third-party add-ins that allow Excel to click cookie pop-ups?

There is no official add-in that allows Power Query to interact with cookie pop-ups natively. Users usually have to rely on external web scraping scripts, like Python with Selenium, to automate the extraction and save it as a local file for Excel to read.