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.
3 Responses
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.
thank you for explaining how to implement dynamic data into google docs and online spreadsheets.
Thank you for this great info on search engine optimization. Keep up the postings on link bait.