Home » Uncategorized

Google Spreadsheet can Import Online.

6 September 2007 No Comment

This feature is really really cool.

Google Spreadsheets wins the prize for the coolest new features launched this summer in Google’s web applications.

The magical autofill lets you type the first elements from a series, select them, drag the fill handle (a small blue square) across the range that you want to fill and obtain the rest of the items automatically. It works for time series (days of the week, months), numerical series (arithmetical progressions), a combination between text and numbers (for example: type Q1, Q2 and Google Spreadsheets will add Q3, Q4 etc.) or dates.

Autofill Spreadsheet
You can also try entering related words, products, companies, countries and you may get surprising results; just press Ctrl while dragging the fill handle. It seems that autofill uses data from Google Sets. Look what I got when I typed “pop”, “rock”, “rap”:

Autofill Spreadsheet 2
The other great new feature uses the “online” part from from “online spreadsheet”. Now you can add data from many different sources available online: feeds, HTML files or simply text files (CSV/TSV).

For HTML or XML files, you have to type an XPath expression to describe the data:
=importXML(“URL”,”XPath expression”)

For example, to get the Google search results for [live], you need to check the source code and notice that the class attribute has the value “l”:
=importXML(“http://www.google.com/search?q=live”, “//a[@class=’l’]/@href”)

Import Html Data In Google Spreadsheets
There’s a special function to import tables and lists from HTML files:
=importHtml(URL, element, index)

Element can be either “list” or “table”, while the index tells an element’s order in the page. Here’s how to import all the definitions for [live] found by Google:
=importHTML(“http://www.google.com/search?q=define:live”, “list”, 1)

To import structured text files, use this function:

This is especially useful if you want to import data from multiple CSV files available online.

Atom and RSS feeds can be imported using this function:

The function has an advanced form that lets you add only some of the items from the feed. For example, here’s how to obtain the latest headline from New York Times:
=GoogleReader (“http://graphics8.nytimes.com/services/xml/rss/nyt/HomePage.xml”, “items title”, “false”, 1)

Google could improve this feature by adding an option to automatically refresh the data. Google could also make it easy to import search results.

If we couple these new additions with the two other functions that retrieve information from the web and consider that each published spreadsheet is available as a feed, it’s clear that you can connect multiple spreadsheets and easily reference data available online.

Via – {Google Operating System Blog}

You will find these in my blog: Coffee, Fun, Carnatic Music, Mridangam, Google, Random thoughts, Business ideas, Start ups, Videos, Blogposts, Cricket, India, Philosophy, Real life Experience.. The list goes on…..



Comments are closed.