Data Import & Export

How to Change the Default URL in Excel Data From Web

Phi Hung VoPhi Hung Vo Nov 2, 2026 869 views

Question details

The user wants to replace or remove the default Bing URL that automatically opens in Excel's Data From Web query tool and set it to a frequently used website.

How to Change the Default URL in Excel Data From Web
Product
Microsoft Excel
Device & OS
not provided
Scenario
Creating a New Web Query to import data from a specific, frequently used website.
Observed behavior
Excel opens a default Bing URL in the New Web Query window, and there is no standard configuration setting to change this starting URL.
Before you start

Ensure you have the exact URL of the website from which you want to extract data copied to your clipboard before starting the query process.

Solution 1Recommended

Reuse an Existing Web Connection

Since Excel does not provide a standard setting to change the default URL in the 'From Web' command, manually entering your website once and reusing the connection is the best workaround.

The classic New Web Query dialog in Excel hardcodes a default search engine URL (like Bing) to load initially. While you cannot modify this default starting page in standard settings, saving your custom web query as an existing connection bypasses the need to type it every time.

1
Open New Web Query

Navigate to the 'Data' tab, click on 'From Web', and allow the dialog to load the default URL.

2
Enter Your Custom URL

Clear the default Bing URL from the address bar at the top of the dialog, type or paste your frequently accessed website URL, and click 'Go'.

3
Import the Data

Select the specific data tables you want to import from the loaded webpage using the yellow arrow icons, then click 'Import'.

4
Reuse the Saved Connection

For future imports, instead of clicking 'From Web', go to the 'Data' tab and click 'Existing Connections'. Select your previously saved web connection from the list to bypass the default URL entirely.

Reuse an Existing Web Connection
System Limitation: Microsoft Excel does not offer a built-in feature to permanently overwrite the default Bing URL in the classic 'From Web' legacy dialog.
Advanced Data Tools

Seamlessly Import Web Data using WPS Spreadsheet

WPS Spreadsheet offers powerful data import capabilities that let you pull information from web pages quickly. It simplifies data connection management, ensuring you can update your spreadsheets effortlessly.

  1. 1. Open WPS Spreadsheet: Launch WPS Office and open a new or existing workbook where you want to import data.
  2. 2. Access Data Import: Navigate to the 'Data' tab on the top ribbon and select 'Import Data'.
  3. 3. Create a Web Query: Choose the option to import from the web, paste your specific URL into the address bar, and execute the search.
  4. 4. Select and Import: Select the tables or data ranges you wish to retrieve from the webpage and confirm to import them into your sheet.
Directly import web data and manage external connections easily.Fully compatible with Microsoft Excel (.xlsx) formats and queries.Lightweight software that runs smoothly without draining system resources.
microsoft office alternative - wps office

Frequently Asked Questions

Can I completely disable the Bing default URL in Excel Web Query?

No, Excel hardcodes the initial URL in the classic New Web Query dialog. It cannot be disabled or changed to a blank page through standard application options.

Does Power Query suffer from the same default URL issue?

No. If you use the modern 'Get Data > From Other Sources > From Web' (Power Query) method, Excel presents a blank URL field immediately, allowing you to paste your specific address without loading a default page first.

How do I refresh the data imported from the web connection?

Click any cell inside the imported data range, go to the 'Data' tab, and click 'Refresh All'. Excel will automatically connect to the saved URL and fetch the latest data.