This video is brought to you by Profound Cloud

Google Spreadsheets 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.


Profound Cloud is a leading IT consulting firm specializing in Google Apps and other cloud services. Our staff is composed of seasoned business advisors, highly skilled and certified technology specialists, and award-winning customer service professionals. We are located in the heart of midtown New York City, however our reach has extended across six continents since our founding in 2007.



  1. Pingback: 6 things From Excel That You Didn't Know You Could Do In Google Sheets | The Gooru

Leave a Reply

Your email address will not be published. Required fields are marked *