Fix Excel Web Query Cannot Accept Cookie Pop-Up Error
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.

- 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.
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.
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.
Navigate to the webpage in your standard web browser. Look for native 'Export to CSV', 'Download Excel', or 'Download Data' buttons.
Review the website's footer or developer documentation for an available API endpoint that delivers data in JSON or XML format.
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.
Manually Download and Import Data
If no API is available, download the web data manually through your browser and import the local file into Excel.
Automate with Power Automate Desktop
For workflows that require automation, use a dedicated RPA tool to simulate a browser interaction before saving the data to Excel.
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. Download the Software: Visit the official WPS website and download the free WPS Office installer.
- 2. Install WPS Office: Run the setup file and follow the on-screen instructions to install the suite on your device.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheet and seamlessly open any manually downloaded CSV or existing Excel files.

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.




