Import a Second HTML Table into Excel from a Web Page with WPS Spreadsheet
Question details
The user needs to import a second HTML table from a web page into a spreadsheet because Excel Web Query only returns the first table and misses the second table.
- Product
- WPS Spreadsheet / Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user is importing data from a web page that contains multiple HTML tables and needs the second table for analysis in Excel or WPS Spreadsheet.
- Observed behavior
- Excel's standard Web Query imports the first table but does not detect or import the second table.
Open the target web page in a browser and confirm that the second table is visible in the rendered page or present in the page source. Copy the full page URL before starting, because the import tool needs the exact same address to fetch available tables.
Import the second HTML table with WPS Spreadsheet's From Web tool
Use this direct method when you want to stay in a spreadsheet and select the second table from the import preview instead of relying on Excel's default first-table behavior.
Excel Web Query often parses only the first simple <table> element and can miss a second table that is nested or structured differently. WPS Spreadsheet shows a table selection dialog, so you can choose the exact table to import.
In WPS Spreadsheet, open a blank workbook, click the Data tab, then choose Import Data > From Web.
Paste the full URL of the web page into the address field and click Go or OK to load the page preview.
When the table list or Navigator appears, look for the second table entry, select it, and preview the rows and columns to confirm it is the correct table.
Choose the destination cell or leave the default location, then click Load to import the selected second table.
Use Power BI Desktop's Web connector to detect both HTML tables
Use this method when the page is complex or generated and the spreadsheet importer still does not list the second table.
Import the Second HTML Table Directly in WPS Spreadsheet
WPS Spreadsheet gives you a table selection step when importing from the web, so you can load the second HTML table into a familiar spreadsheet and continue working without switching to Power BI.
- 1. Open the web import tool: Open WPS Spreadsheet and click Data > Import Data > From Web.
- 2. Load the page preview: Enter the web page URL and load the available table preview.
- 3. Select the second table: Select the second HTML table from the table list.
- 4. Import the table: Choose the destination cell and click Load to import it.
- 5. Save for Excel compatibility: Save the workbook in .xlsx format to keep Excel compatibility.
Frequently Asked Questions
Why does Excel Web Query only import the first HTML table?
Excel's standard Web Query often reads the first simple <table> element and does not expose a second table that is nested, dynamically generated, or skipped by its parser. A connector that shows a table list, such as WPS Spreadsheet's From Web import or Power BI Desktop, helps you select the second table manually.
How do I import the second table in WPS Spreadsheet?
Open WPS Spreadsheet, go to Data > Import Data > From Web, paste the page URL, and in the table preview or Navigator select the second table before clicking Load.
Can Excel 365's Power Query Web connector detect both tables?
In some Excel 365 versions, Data > Get Data > From Web may list additional tables in the Navigator. If the option is not available in your installation, use Power BI Desktop or WPS Spreadsheet as an alternative.
What if the second table is generated by JavaScript?
JavaScript-generated content may not be present in the initial HTML fetched by the import tool. Open the browser developer tools to find the underlying data request, or copy the rendered table from the browser and paste it into WPS Spreadsheet.
Does WPS Spreadsheet remain Excel-compatible after importing this table?
Yes. After the import, save the workbook as .xlsx, and the file remains compatible with Microsoft Excel while keeping the imported table structure and formatting.
