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.

Shares

UP NEXT: Enable Auditing of Docs in Google Drive

Leave a Reply

1 Comment on "Import Data from Websites to Google Spreadsheets"

Notify of
avatar

Sort by:   newest | oldest | most voted
Randy Rapin
Guest
Randy Rapin
July 25, 2013 8:16 pm

How do I get this to work with QuickBase?

wpDiscuz
Loading Facebook Comments ...

REGISTER

FOR OUR WEBINAR TO GET
THE LATEST 451 RESEARCH REPORT


REGISTER HERE

DOWNLOAD

The Ultimate Guide to Google Drive

DOWNLOAD NOW