{"id":265,"date":"2007-07-02T20:51:05","date_gmt":"2007-07-03T00:51:05","guid":{"rendered":"http:\/\/www.internettipoftheweek.com\/data-lookup-with-google-spreadsheets\/265\/"},"modified":"2007-07-02T20:51:05","modified_gmt":"2007-07-03T00:51:05","slug":"data-lookup-with-google-spreadsheets","status":"publish","type":"post","link":"https:\/\/www.surfnetkids.com\/tech\/265\/data-lookup-with-google-spreadsheets\/","title":{"rendered":"Data Lookup with Google Spreadsheets"},"content":{"rendered":"<p>One of the advantages <a href=\"http:\/\/docs.google.com\/ \" target=\"_blank\" >Google Spreadsheets<\/a> has over a client-side spreadsheet such as Microsoft Excel, is access to live data look ups.  Using the GoogleLookup function, data lookup for many kinds of standard facts is simple.    Standard facts include, for example, population figures for cities and countries, capitals for states and nations, and places of birth for famous people.   For exact syntax and more examples see the <a href=\"http:\/\/tinyurl.com\/28eok6 \" target=\"_blank\">Google Docs &#038; Spreadsheet Help Center <\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>One of the advantages Google Spreadsheets has over a client-side spreadsheet such as Microsoft Excel, is access to live data look ups. Using the GoogleLookup function, data lookup for many kinds of standard facts is simple. Standard facts include, for &#8230;<a href=\"https:\/\/www.surfnetkids.com\/tech\/265\/data-lookup-with-google-spreadsheets\/\">[Continue]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[48,4,66],"tags":[2633,2637],"class_list":{"0":"post-265","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-blogging","7":"category-google","8":"category-social-networks","9":"tag-online-publishing-2","10":"tag-web-2-0","11":"entry"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Data Lookup with Google Spreadsheets &#187; Tech Tips \u00bb Surfnetkids<\/title>\n<meta name=\"description\" content=\"One of the advantages Google Spreadsheets has over a client-side spreadsheet such as Microsoft Excel, is access to live data look ups. Using the\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.surfnetkids.com\/tech\/265\/data-lookup-with-google-spreadsheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Lookup with Google Spreadsheets &#187; Tech Tips \u00bb Surfnetkids\" \/>\n<meta property=\"og:description\" content=\"One of the advantages Google Spreadsheets has over a client-side spreadsheet such as Microsoft Excel, is access to live data look ups. Using the\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.surfnetkids.com\/tech\/265\/data-lookup-with-google-spreadsheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Tech Tips \u00bb Surfnetkids\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/surfnetkids\/\" \/>\n<meta property=\"article:published_time\" content=\"2007-07-03T00:51:05+00:00\" \/>\n<meta name=\"author\" content=\"Barbara J. Feldman\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@barbarafeldman\" \/>\n<meta name=\"twitter:site\" content=\"@barbarafeldman\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Barbara J. Feldman\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.surfnetkids.com\\\/tech\\\/265\\\/data-lookup-with-google-spreadsheets\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.surfnetkids.com\\\/tech\\\/265\\\/data-lookup-with-google-spreadsheets\\\/\"},\"author\":{\"name\":\"Barbara J. Feldman\",\"@id\":\"https:\\\/\\\/www.surfnetkids.com\\\/tech\\\/#\\\/schema\\\/person\\\/cdb196c6a51c0f75efece9d1acfc200a\"},\"headline\":\"Data Lookup with Google Spreadsheets\",\"datePublished\":\"2007-07-03T00:51:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.surfnetkids.com\\\/tech\\\/265\\\/data-lookup-with-google-spreadsheets\\\/\"},\"wordCount\":77,\"commentCount\":0,\"keywords\":[\"online publishing\",\"web 2.0\"],\"articleSection\":[\"Blogging\",\"Google\",\"Social Networks\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.surfnetkids.com\\\/tech\\\/265\\\/data-lookup-with-google-spreadsheets\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.surfnetkids.com\\\/tech\\\/265\\\/data-lookup-with-google-spreadsheets\\\/\",\"url\":\"https:\\\/\\\/www.surfnetkids.com\\\/tech\\\/265\\\/data-lookup-with-google-spreadsheets\\\/\",\"name\":\"Data Lookup with Google Spreadsheets &#187; Tech Tips \u00bb Surfnetkids\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.surfnetkids.com\\\/tech\\\/#website\"},\"datePublished\":\"2007-07-03T00:51:05+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.surfnetkids.com\\\/tech\\\/#\\\/schema\\\/person\\\/cdb196c6a51c0f75efece9d1acfc200a\"},\"description\":\"One of the advantages Google Spreadsheets has over a client-side spreadsheet such as Microsoft Excel, is access to live data look ups. Using the\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.surfnetkids.com\\\/tech\\\/265\\\/data-lookup-with-google-spreadsheets\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.surfnetkids.com\\\/tech\\\/265\\\/data-lookup-with-google-spreadsheets\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.surfnetkids.com\\\/tech\\\/265\\\/data-lookup-with-google-spreadsheets\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Tech Tips\",\"item\":\"https:\\\/\\\/www.surfnetkids.com\\\/tech\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Blogging\",\"item\":\"https:\\\/\\\/www.surfnetkids.com\\\/tech\\\/category\\\/blogging\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Data Lookup with Google Spreadsheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.surfnetkids.com\\\/tech\\\/#website\",\"url\":\"https:\\\/\\\/www.surfnetkids.com\\\/tech\\\/\",\"name\":\"Tech Tips \u00bb Surfnetkids\",\"description\":\"for families and classrooms from Surfnetkids.com\",\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.surfnetkids.com\\\/tech\\\/#\\\/schema\\\/person\\\/cdb196c6a51c0f75efece9d1acfc200a\",\"name\":\"Barbara J. Feldman\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f6e46f3b8086ff1944261ad7589f4953e61a09467d9352840df2b96d32ad45bb?s=96&d=wavatar&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f6e46f3b8086ff1944261ad7589f4953e61a09467d9352840df2b96d32ad45bb?s=96&d=wavatar&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f6e46f3b8086ff1944261ad7589f4953e61a09467d9352840df2b96d32ad45bb?s=96&d=wavatar&r=g\",\"caption\":\"Barbara J. Feldman\"},\"description\":\"Barbara J. Feldman is a syndicated columnist and online publisher at Feldman Publishing. She has a computer science degree from University of California, Irvine, and has been a nerd for more than forty years. Follow Barbara Feldman\",\"sameAs\":[\"http:\\\/\\\/www.barbarafeldman.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Lookup with Google Spreadsheets &#187; Tech Tips \u00bb Surfnetkids","description":"One of the advantages Google Spreadsheets has over a client-side spreadsheet such as Microsoft Excel, is access to live data look ups. Using the","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.surfnetkids.com\/tech\/265\/data-lookup-with-google-spreadsheets\/","og_locale":"en_US","og_type":"article","og_title":"Data Lookup with Google Spreadsheets &#187; Tech Tips \u00bb Surfnetkids","og_description":"One of the advantages Google Spreadsheets has over a client-side spreadsheet such as Microsoft Excel, is access to live data look ups. Using the","og_url":"https:\/\/www.surfnetkids.com\/tech\/265\/data-lookup-with-google-spreadsheets\/","og_site_name":"Tech Tips \u00bb Surfnetkids","article_publisher":"https:\/\/www.facebook.com\/surfnetkids\/","article_published_time":"2007-07-03T00:51:05+00:00","author":"Barbara J. Feldman","twitter_card":"summary_large_image","twitter_creator":"@barbarafeldman","twitter_site":"@barbarafeldman","twitter_misc":{"Written by":"Barbara J. Feldman"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.surfnetkids.com\/tech\/265\/data-lookup-with-google-spreadsheets\/#article","isPartOf":{"@id":"https:\/\/www.surfnetkids.com\/tech\/265\/data-lookup-with-google-spreadsheets\/"},"author":{"name":"Barbara J. Feldman","@id":"https:\/\/www.surfnetkids.com\/tech\/#\/schema\/person\/cdb196c6a51c0f75efece9d1acfc200a"},"headline":"Data Lookup with Google Spreadsheets","datePublished":"2007-07-03T00:51:05+00:00","mainEntityOfPage":{"@id":"https:\/\/www.surfnetkids.com\/tech\/265\/data-lookup-with-google-spreadsheets\/"},"wordCount":77,"commentCount":0,"keywords":["online publishing","web 2.0"],"articleSection":["Blogging","Google","Social Networks"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.surfnetkids.com\/tech\/265\/data-lookup-with-google-spreadsheets\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.surfnetkids.com\/tech\/265\/data-lookup-with-google-spreadsheets\/","url":"https:\/\/www.surfnetkids.com\/tech\/265\/data-lookup-with-google-spreadsheets\/","name":"Data Lookup with Google Spreadsheets &#187; Tech Tips \u00bb Surfnetkids","isPartOf":{"@id":"https:\/\/www.surfnetkids.com\/tech\/#website"},"datePublished":"2007-07-03T00:51:05+00:00","author":{"@id":"https:\/\/www.surfnetkids.com\/tech\/#\/schema\/person\/cdb196c6a51c0f75efece9d1acfc200a"},"description":"One of the advantages Google Spreadsheets has over a client-side spreadsheet such as Microsoft Excel, is access to live data look ups. Using the","breadcrumb":{"@id":"https:\/\/www.surfnetkids.com\/tech\/265\/data-lookup-with-google-spreadsheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.surfnetkids.com\/tech\/265\/data-lookup-with-google-spreadsheets\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.surfnetkids.com\/tech\/265\/data-lookup-with-google-spreadsheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Tech Tips","item":"https:\/\/www.surfnetkids.com\/tech\/"},{"@type":"ListItem","position":2,"name":"Blogging","item":"https:\/\/www.surfnetkids.com\/tech\/category\/blogging\/"},{"@type":"ListItem","position":3,"name":"Data Lookup with Google Spreadsheets"}]},{"@type":"WebSite","@id":"https:\/\/www.surfnetkids.com\/tech\/#website","url":"https:\/\/www.surfnetkids.com\/tech\/","name":"Tech Tips \u00bb Surfnetkids","description":"for families and classrooms from Surfnetkids.com","inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.surfnetkids.com\/tech\/#\/schema\/person\/cdb196c6a51c0f75efece9d1acfc200a","name":"Barbara J. Feldman","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f6e46f3b8086ff1944261ad7589f4953e61a09467d9352840df2b96d32ad45bb?s=96&d=wavatar&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f6e46f3b8086ff1944261ad7589f4953e61a09467d9352840df2b96d32ad45bb?s=96&d=wavatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f6e46f3b8086ff1944261ad7589f4953e61a09467d9352840df2b96d32ad45bb?s=96&d=wavatar&r=g","caption":"Barbara J. Feldman"},"description":"Barbara J. Feldman is a syndicated columnist and online publisher at Feldman Publishing. She has a computer science degree from University of California, Irvine, and has been a nerd for more than forty years. Follow Barbara Feldman","sameAs":["http:\/\/www.barbarafeldman.com"]}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.surfnetkids.com\/tech\/wp-json\/wp\/v2\/posts\/265","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.surfnetkids.com\/tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.surfnetkids.com\/tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.surfnetkids.com\/tech\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.surfnetkids.com\/tech\/wp-json\/wp\/v2\/comments?post=265"}],"version-history":[{"count":0,"href":"https:\/\/www.surfnetkids.com\/tech\/wp-json\/wp\/v2\/posts\/265\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.surfnetkids.com\/tech\/wp-json\/wp\/v2\/media?parent=265"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.surfnetkids.com\/tech\/wp-json\/wp\/v2\/categories?post=265"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.surfnetkids.com\/tech\/wp-json\/wp\/v2\/tags?post=265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}