Fix Excel Get Data from Web Login Problems
Question details
The user needs to retrieve website data in Excel when the Get Data from Web login does not authenticate successfully.
- Product
- Microsoft Excel Get Data from Web and Power Query
- Device & OS
- not provided
- Scenario
- The user is connecting Excel to a website that requires interactive sign-in, modern authentication, JavaScript, cookies, or multi-factor authentication.
- Observed behavior
- The web query cannot complete the login or retrieve data from the protected website.
Open the website in a regular browser and confirm that the account can sign in successfully, including any multi-factor authentication step. Also check whether the site offers an official API, downloadable export, ODBC connection, or dedicated Power Query connector.
Use a supported data connection instead of a legacy web login
Use this approach when the website blocks Excel's legacy web query authentication or requires browser-based security features.
The Legacy Web Query tool cannot reliably handle many modern login systems. A supported API, downloadable file, ODBC connection, or dedicated Power Query connector is usually more reliable than submitting credentials through a web query.
Contact the website administrator or review its developer and export documentation for an official API, CSV or Excel download, ODBC connection, or Power Query connector.
In Excel, open the Data tab, select Get Data, and choose the available connector or source type instead of using a legacy Web Query connection.
When Excel displays an authentication window, choose the required account or organizational sign-in method and complete the browser-based or multi-factor authentication prompts.
Ask the website administrator to confirm that the account and endpoint permit automated data access and that the requested data is available through the selected connector.
Use a browser export when the website only supports interactive login
Use this workaround when no API or connector is available but the site allows an authenticated user to download the required data.
Switch to WPS Office for Lightweight Excel-Compatible Data Work
WPS Office is a free, lightweight Microsoft Office alternative with a familiar interface and strong compatibility with Excel workbooks. Use it to open, review, edit, and share downloaded XLSX or CSV data after completing website authentication in a supported browser, while keeping your existing Office workflow easy to migrate.
- 1. Download WPS Office: Select Download WPS Office Free and install WPS Office on your computer.
- 2. Open the exported data: In WPS Spreadsheet, select Menu, Open, and choose the downloaded XLSX, XLS, or CSV file.
- 3. Review and clean the worksheet: Use the Data and Home tabs to filter, format, sort, and prepare the imported web data.
- 4. Save in an Excel-compatible format: Select Menu, Save As, and choose Excel Workbook (*.xlsx) when you need to share the file with Microsoft Excel users.
Frequently Asked Questions
Why does Excel Get Data from Web fail after I can log in successfully in my browser?
Excel's legacy web query may not support the site's JavaScript, cookies, security tokens, modern authentication, or multi-factor authentication. A browser login therefore does not guarantee that an automated Excel request can authenticate.
Can I fix a Power Query web login by entering my username and password again?
Only if the site uses a supported basic authentication flow. For modern or interactive sign-in, repeated credential entry usually will not help; use the site's official connector, API, downloadable export, or approved ODBC connection instead.
What should I use if the website does not provide an Excel or Power Query connector?
Sign in through a supported browser and use the site's CSV or Excel export if available. If no export exists, ask the website administrator for an API, ODBC connection, or permission for automated access.
Does WPS Office fix Excel Power Query web authentication errors?
No. The authentication issue belongs to Excel's web-query workflow and the website's security system. WPS Office can open and edit the XLSX or CSV file after you obtain the data through a browser export or another supported connection.
