Data Import & Export

Fix the Missing Advanced Option in Excel 2016 From Web

Elise WilliamsElise Williams Nov 14, 2026 868 views

Question details

The user wants to find or restore the Advanced option when importing web data into Excel 2016.

Fix the Missing Advanced Option in Excel 2016 From Web
Product
Microsoft Excel 2016
Device & OS
not provided
Scenario
Import web data using the From Web connector and access its advanced options.
Observed behavior
A different import window opens, and the Advanced option the user expects is missing.
Before you start

Identify the web address you want to import and check whether you need advanced settings such as URL parts or HTTP request headers. Menu names and available dialogs can vary by Excel 2016 build and installation.

Solution 1Recommended

Open the newer From Web connector

Use the Get Data command to check whether your Excel build offers the Basic and Advanced choices in the newer connector.

1
Open From Web

In Excel, select Data > Get Data > From Other Sources > From Web. In some builds, look for Data > New Query > From Other Sources > From Web instead.

2
Look for Advanced

In the From Web dialog, select Advanced if it is available. Enter the URL parts and any required HTTP request headers, then select OK.

3
Choose the data

If prompted, select an authentication method. In Navigator, select the table you need and choose Load or Transform Data.

Dialog differs by build: If the connector opens without an Advanced choice, check your Office version and updates. The option may not be available in every Excel 2016 installation.
Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Microsoft Office formats, making it easier to move existing files. It does not restore Excel's missing From Web option.

Open and edit Microsoft Excel XLSX and XLS filesReview and work with spreadsheet data in a familiar interfaceUse a lightweight office suite with free core toolsMove existing Office documents without starting from scratch
microsoft office alternative - wps office

Frequently Asked Questions

Where is the Advanced option in Excel's From Web connector?

Open Data > Get Data > From Other Sources > From Web and look for Advanced in the dialog. Its availability depends on your Excel edition and build.

How do I enable From Web (Legacy)?

Go to File > Options > Data, select From Web (Legacy) under Show legacy data import wizards, and select OK. Then open it from Data > Get Data > Legacy Wizards.

Will enabling the legacy wizard restore the Advanced option?

Not necessarily. The legacy wizard is a separate import workflow with a different interface; enabling it does not guarantee the newer connector's Advanced settings.

What if Update Options is missing from my Office account page?

Your Office installation may use a different update method or be managed by an administrator. Check with your administrator or the provider of your Office installation.

Can WPS Office fix the missing Excel From Web option?

No. The option is part of Microsoft Excel. WPS Office can open and edit Excel files as an alternative, but Excel-specific queries may not work or refresh in WPS.