This video is brought to you by Profound Cloud

Google Sheets can be a great place to store data from websites for future reference, but it can be frustrating if you’re constantly updating your spreadsheet to reflect changing information. The importHTML function in Spreadsheets is a powerful tool that addresses this issue.

The importHTML function uses three queries to pull data. First, you’ll need to specify the URL where the information resides. Then you’ll need to determine if the data is in a list or table.

Finally, you can specify which list / table you would like to pull from the URL. You can do this by analyzing the page visually and specifying table 1, 2, 3 etc. If you’re having trouble determining which table you’re looking at, you’ll need to inspect the page element (which we cover in the video).

If you’d like to learn more about this powerful tool (specifically how to inspect the page element), take a look at this video.