Categories
Google

Import Web Data into Google Docs

I’ve been using Google Docs since long to create documents and spreadsheets but recently discovered that Google’s cloud-based Office suite provide us lot of other flexibilities.

A useful Google formula “ImportHTML” helps us to fetch tables and lists from an external web page into a Google Drive’s spreadsheet.

Create a spreadsheet inside Google Drive/Docs. Edit any of its cell to enter the formula/function as below.

=ImportHTML("http://en.wikipedia.org/wiki/List_of_Bollywood_films_of_2012", "table", 2)

Now come out of the cell and Google Docs will import the second table from the mentioned Wiki page into your sheet.

The 1st parameter of the function ImportHTML is nothing but the Target URL, 2nd parameter allows us to select which format of data we wish to import. This can be table (for tabular format), list (for ordered list) etc. The 3rd parameter says which index/number/position of the desired format data on the page that needs to be imported. If we put 4 instead of 2 in the third parameter of the above formula, then Docs API will import the forth table from the web page.

importHTMLThe beauty of these magical functions may help us in tracking web page changes. This may be utilized for tracking price fluctuations for a product on any eCommerce portal.

Google Docs is inbuilt with such amazing wonderful functions e.g.  ImportFeed, ImportHTML and ImportXML.

'Coz sharing is caring

By Swatantra Kumar

Swatantra is an engineering leader with a successful record in building, nurturing, managing, and leading a multi-disciplinary, diverse, and distributed team of engineers and managers developing and delivering solutions. Professionally, he oversees solution design-development-delivery, cloud transition, IT strategies, technical and organizational leadership, TOM, IT governance, digital transformation, Innovation, stakeholder management, management consulting, and technology vision & strategy. When he's not working, he enjoys reading about and working with new technologies, and trying to get his friends to make the move to new web trends. He has written, co-written, and published many articles in international journals, on various domains/topics including Open Source, Networks, Low-Code, Mobile Technologies, and Business Intelligence. He made a proposal for an information management system at the University level during his graduation days.

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.