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

Google Forms is a powerful tool for creating surveys, quizzes, or forms for data collection. When linked to Google Sheets, responses are automatically organized in a spreadsheet for easy analysis.

Google Sheets is great for calculations and data analysis, but it also offers several built-in tools for basic tracking of team projects.

You can create automated document workflows in most Google Workspace apps, including Google Docs, Sheets, Gmail, and Forms. How to automate document workflow: Apps Script vs. add-ons ...

Pivot tables let you parse raw spreadsheet data to display specific information in a concise, easy-to-digest format. Here’s how to use them in Google Sheets.

Another handy new feature closely links Sheets with Google's presentation app Slides. Last year, Google added the ability to automatically update data from Docs into Slides with one click.