How to import the contents of a html table found on a website. Into a Google sheet.
- In cell A1 of a Google Sheet, paste the following formula.
=IMPORTHTML("https://www.somewebsite.com","table",2)- The 2 above denotes the 2nd HTML table on the website.