For instance, you can directly import data from web pages and edit it inside Google Docs. You can translate the text of a cell from one language to another. You can read RSS feeds inside Google Docs. You can even use Google Docs for monitoring web page changes - this is handy for tracking price fluctuations for a product on any shopping website.
You don’t have to be a geek nor do you have to write any scripts to do such amazing stuff inside Google Docs. All you need to know is a couple of Google functions - ImportFeed, ImportHTML and ImportXML – and you’ll have a head start. Ready?
Import Web Data into Google Docs
Today we’ll discuss ImportHTML, a useful Google formula that will help you fetch tables and lists from an external web pages into a Google Sheet.
Let’s start with an example. Open a new spreadsheet inside Google Docs, double-click any cell to enter the Edit mode and copy-paste the following function:
When you press Return, Google Docs will instantly import the second table from the corresponding Wikipedia page into your current sheet. If you replace the value of the third parameter in the above formula from 2 to, say, 4, Google Docs will import the forth table from the Wikipedia page.
In addition to <tables>, you can also import HTML lists into Google Sheets that are created using the <ol> or <ul> tags. Try the next function on your Google Sheet:
The 25 start-up tips are listed using an Ordered HTML List and you can import the entire list into your Google Sheet with one formula. If there are multiple lists on a page, you can change the third parameter with the index of the list that you wish to fetch inside Google Docs.
It is important to note that once a table or list has been imported into Google Docs, the table won’t update itself even if the data on the source page has changed. Also, Google imports the tables as plain text and all the formatting and links will be lost.
KOMPUTER FUN
ReplyDeleteKomputerFun on Facebook
KomputerFun on Twitter
KomputerFun on Twitter
TECHNOLOGY MANIAS
Technology Manias on Facebook
Technology Manias on Youtube
Technology Manias on Youtube
AIRTEL FREE 3G TRICK WORKING November 2015 AIRTEL TCP VPN TRICK
Saintly Rows
Mike Trout continues to tear the league apart. So why isn’t he winning MVPs to match?
3rd Test, Day 1: Ashwin, Jadeja strike after India fold for 215
I never said India is intolerant: Shah Rukh Khan
Shah Rukh Khan finally opens up about his extreme intolerance statement!
Is India tolerant? It doesn’t matter because the reactions to Aamir Khan’s remark justify his fears
KomputerFun is Back, We are back in action !
Penfold
ROAM
FIDLAR
Koji
GIVE
Tomorrowland HdBrrip 720P Movie
How To Hack Airtel 3G November 2015
How To Hack Airtel 3G October 2015
Govt blocks 2 websites, FB pages for carrying IS propaganda
How does a ticket for texting affect car insurance rates?
How to Earn Money With TrafficMonsoon PTC Program
Tata Docomo 3G Hack 2014
Full Method To Earn Bitcoin By Mining pool