Automate your document workflow with Google Sheets, Docs, Gmail, and Forms for a smoother business operation.

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

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: ...