Data Import & Export

How to Import Data from a Login-Protected Website into Excel

Muhammad Talha Oct 10, 2026 869 views

Question details

The user needs to import data from a website requiring login credentials into Excel, but is unable to type or interact with the username and password fields presented in the workbook's web view.

How to Import Data from a Login-Protected Website into Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Importing online table data from a secure, authenticated website using the Get Data From Web feature.
Observed behavior: The username and password text fields on the webpage displayed inside the Excel web connector window cannot be edited, preventing the user from logging in and retrieving the data.

Before you start

Verify that you have the correct URL containing the data tables and ensure you have valid login credentials (username and password) or API keys for the target website.

Solution 1Recommended

Use Excel's Built-in Basic Authentication Settings

Use the dedicated authentication tabs within the Get Data wizard instead of trying to interact with the visual webpage preview.

Excel's built-in web viewer is not a fully functional browser and often blocks interactive elements like form fields. To authenticate successfully, you must pass your credentials through Excel's native connection settings.

Launch the Web Data Connector

Open your Excel workbook, navigate to the 'Data' tab on the top ribbon, and click on 'Get Data' > 'From Other Sources' > 'From Web'.

Enter the Target URL

Paste the exact URL of the website containing the data you wish to import into the dialog box and click 'OK'.

Select Basic Authentication

When the Access Web Content dialog window appears, ignore the 'Anonymous' tab. Click on the 'Basic' tab located on the left sidebar.

Submit Your Credentials

Enter your website username and password in the provided fields. Select the URL level to apply these credentials to from the dropdown menu, then click 'Connect' to fetch the data.

Use Excel's Built-in Basic Authentication Settings

Solution 2

Export the Data Manually via Web Browser

If the website utilizes advanced security, SSO, or CAPTCHA that blocks Excel's connector entirely, use a manual export method as a reliable workaround.

Free Microsoft Office alternative

Try WPS Office for Seamless Data Management

If you frequently encounter limitations, bugs, or slow loading times with Microsoft Office's data connectors, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for handling complex spreadsheets, importing CSVs, and managing large datasets without the heavy processing overhead.

1. Download WPS Office: Visit the official WPS website and download the free WPS Office installer.
2. Install and Launch: Follow the on-screen instructions to install the suite, then open the WPS Spreadsheet application.
3. Import Your Data: Use the Data tab to seamlessly import your exported CSV or Excel workbooks and continue your data analysis.

100% compatible with Microsoft Excel (.xlsx, .xls, .csv) formatsLightweight application that opens large data files rapidly, even on older devicesFree to use with a clean, familiar tabbed user interfaceEasily import and structure external data files and text documents

microsoft office alternative - wps office

Frequently Asked Questions

Why are the login fields uneditable in Excel's web preview window?

Excel's web data connector uses a simplified, restricted browser engine designed strictly to parse HTML tables, not to function as a fully interactive web browser. As a result, it blocks interactive web scripts and prevents typing directly into login form fields on the page view.

What types of web authentication does Excel support?

The Excel Get Data From Web connector primarily supports Anonymous, Basic (standard username and password), Windows (Active Directory), Web API (key-based), and Organizational account authentication. It generally cannot handle Multi-Factor Authentication (MFA), CAPTCHAs, or complex token-based logins.

Is it possible to automate logging into a website using VBA?

Yes, advanced users can write VBA macros using MSXML2.XMLHTTP to send HTTP POST requests containing login credentials. However, this requires significant programming knowledge and familiarity with the target website's backend architecture. For most users, using the Basic authentication tab or manually downloading a CSV is much more practical.

Excel & Data Problems