Google Sheets can import XML data from a web page even if the data is not in a table format.
In the below example, we have two tables in the middle of the web page that are in a proper table format. Excel would have no problem acquiring these tables.
However, the table in the upper-right is not in a table format and cannot be accessed by Excel.
Using the IMPORTXML function, we can dig deep into the HTML code to locate the node name or attribute name from the source code.
This gives us the ability to import pretty much any component of a web page into Sheets.
The IMPORTXML function requires the website address and the node name or attribute name of the desired component.
If we wanted to bring the other tables into Sheets, because these are proper tables, we can use the IMPORTHTML function.