To obtain very specific bits of that HTML, Google Sheets uses a structured data format called XML and a related query language called XPath.

How to access automation add-ons If you want to browse add-ons for Google Sheets, Docs, Gmail, or Forms, you can find them in the Google web store.

It has a nifty little formula which allows you to grab a web page’s list or table of data into your sheet of choice. It’s called importhtml, and it works as follows: ...