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

This method of using Google Forms with Google Sheets was ostensibly designed to gather and analyze survey data, but with a few tweaks it works just as well to record your financial transactions ...

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.