Fix Excel Web Data Import Script Errors with the From Web Connector
Question details
The user needs to resolve a script error that appears when Excel retrieves data from a website.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Importing or refreshing web-based data in an Excel workbook.
- Observed behavior
- Excel displays a script error while attempting to retrieve data from the web.
Open the source URL in a regular web browser first to confirm that the page loads and that you can sign in if required. Copy the direct page or data URL you want Excel to access.
Import the webpage with Excel's current From Web connector
Use this method when a legacy web query or older import workflow produces a script error.
Modern Excel versions use the Power Query web connector for web imports. It is more compatible with current websites than legacy web-query methods.
In Excel, select the Data tab, then choose Get Data > From Other Sources > From Web. In some Excel versions, select Data > From Web directly.
Paste the webpage URL into the From Web dialog box, then select OK to connect to the site.
Choose the appropriate access method, such as Anonymous, Windows, Basic, Organizational Account, or Web API, and sign in if the website requires credentials.
In the Navigator window, select the available table or page content, choose Transform Data if cleanup is needed, or select Load to import it into the worksheet.
Use a supported downloadable file or API instead of an interactive webpage
Choose this option when the website blocks automated requests or relies on outdated browser components and client-side scripts.
Work with Imported Excel Data in Free WPS Spreadsheet
If Microsoft Excel web imports continue to fail because of a legacy connector or site-specific script behavior, WPS Office provides a free, lightweight spreadsheet alternative with a familiar interface. Open your downloaded or exported data files in WPS Spreadsheet and continue sorting, filtering, calculating, and reporting with a smooth migration experience.
- 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheet from the WPS Office home screen.
- 2. Open the exported data file: Select Menu > Open and choose the CSV, XLSX, or XLS file downloaded from the website or data provider.
- 3. Review and analyze the data: Use the Data tab to sort and filter records, then use formulas, tables, and charts to analyze the imported information.
Frequently Asked Questions
Why does Excel show a script error when importing data from a website?
The error commonly occurs when a legacy web-import method encounters a modern webpage that uses JavaScript, unsupported browser components, sign-in controls, or blocked automated requests. Use Data > Get Data > From Other Sources > From Web to try the current connector.
Where is the From Web option in Excel?
Go to the Data tab. Depending on your Excel version, choose Get Data > From Other Sources > From Web, or select Data > From Web directly.
Can Excel import data from a website that requires a login?
Yes, if the site supports a compatible authentication method. After entering the URL in Data > From Web, select the authentication type offered in the access dialog and sign in with authorized credentials.
What should I do if the web page opens in my browser but not in Excel?
Check whether the site blocks automated traffic, requires browser cookies, or loads data only through interactive scripts. Look for a CSV, XLSX, JSON download, or official API and import that source instead.
Can I open an Excel web-data export in WPS Spreadsheet?
Yes. WPS Spreadsheet can open common exported data formats, including Microsoft Excel .xlsx and .xls files as well as CSV files. Use Menu > Open to select the downloaded file.
