Google Lookup in Spreadsheets

There is a new way to access the unlimited datastore of the internet using google docs and the web.

Google spreadsheets has a feature called GoogleLookup that lets you do real time automated lookups through their spreadsheet feature.

What makes GoogleLookup really cool is that it references data not only from your spreadsheet (as with functions like =SUM(A1:A12)), but searches that incredibly expansive body of published information directly from the web. By performing a specific websearch, GoogleLookup attempts to return facts about the entity you specify. City populations are a nice example. Entering =GoogleLookup(”Los Angeles”, “population”) in any spreadsheet cell will automatically retrieve the number of people living in Los Angeles.

It is not perfect, and if you choose a value with multiple locations such as Portland, it may be incorrect. It is important to verify any auto-generated data before using.

Google just created a simple API to access the unstructured data online.

Read more about GoogleLookup from beahburger.


27 Little-known Tips to GET TRAFFIC to your Website

Related Posts

3 Responses

  1. How to Choose a spreadsheet Product
    How to Decide Whether to Buy an internet Franchise
    How to Communicate in an online Business Crisis

    How to Insure a web-Based Business
    1. Determine what additional insurance coverage you will need to insure your webbased business.

    2. Check out insurance programs available through self-employment organizations or the local Chamber of Commerce.

    3. Contact the company that provides your business policy insurance to determine the riders and additions you need to insure your home-office data property.

    4. Investigate business interruption insurance, which reimburses you if you are suddenly unable to conduct your business.

    5. Conduct a daily backup of google docs data and transfer information to a safe place.

Leave a Reply

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

100 New Ideas to Boost Conversions

Get our ultimate guide to maximizing your ad campaigns.