{"id":260,"date":"2012-06-20T06:14:54","date_gmt":"2012-06-19T22:14:54","guid":{"rendered":"http:\/\/blog.zeemaps.com\/?p=260"},"modified":"2012-06-20T06:14:54","modified_gmt":"2012-06-19T22:14:54","slug":"improved-mapping-from-google-spreadsheets","status":"publish","type":"post","link":"https:\/\/www.zeemaps.com\/blog\/improved-mapping-from-google-spreadsheets\/","title":{"rendered":"Improved Mapping from Google Spreadsheets"},"content":{"rendered":"<p>We have removed the limitation on Google Spreadsheet names, and simplified how we access your spreadsheets using the standard OAuth access protocol.<br \/>\nTo upload a spreadsheet, use the <strong>Additions-&gt;Add (Upload) Multiple Markers<\/strong> menu item on your map, and select the <strong>Google Spreadsheets<\/strong> option. In the resulting dialog, click on the <strong>Fetch My Spreadsheets<\/strong> button to get a list of your current speeadsheets in Google.<br \/>\nYou will have to grant ZeeMaps access to your spreadsheets. We ask for permission to access your spreadsheets now, and in the future, in case you want ZeeMaps to periodically update your map as the spreadsheet changes. <a href=\"http:\/\/support.google.com\/accounts\/bin\/answer.py?hl=en&amp;answer=41236\">You can revoke this right, at any time.<\/a> <strong><em>Note that for the periodic updates to work, you must not change the header row of your spreadsheet.<\/em><\/strong><br \/>\nOnce you have selected the spreadsheet to use, ZeeMaps asks you to confirm the column headings to fields on the map. <strong>At this time you can also check the option to periodically update the map from the spreadsheet<\/strong>.<br \/>\nAfter you have confirmed the mappings, your data should get mapped. For small speeadsheets, it should get done in minutes or seconds. For larger spreadsheets (more than thousand or so entries) it can take a an hour or so. You will be notified by email when your data is uploaded. Alternatively, you can check your map in a little while to see how many rows were marked.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We have removed the limitation on Google Spreadsheet names, and simplified how we access your spreadsheets using the standard OAuth [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[2,9,33],"tags":[],"class_list":["post-260","post","type-post","status-publish","format-standard","hentry","category-add-markers","category-google-spreadsheets","category-upload-multiple-points"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.8 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Improved Mapping from Google Spreadsheets - Blog<\/title>\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.zeemaps.com\/blog\/improved-mapping-from-google-spreadsheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Improved Mapping from Google Spreadsheets\" \/>\n<meta property=\"og:description\" content=\"We have removed the limitation on Google Spreadsheet names, and simplified how we access your spreadsheets using the standard OAuth [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.zeemaps.com\/blog\/improved-mapping-from-google-spreadsheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/zeemaps\/?eid=ARAnw5BHDEcPHqlBzf_tUU6RxgnuKkzgzT5s5QMgIRYMwX0SqumGMVw2js5zh-5w0hMXyIK_SJuSQ3aN\" \/>\n<meta property=\"article:published_time\" content=\"2012-06-19T22:14:54+00:00\" \/>\n<meta name=\"author\" content=\"zeemaps\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@zeemaps\" \/>\n<meta name=\"twitter:site\" content=\"@zeemaps\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"zeemaps\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.zeemaps.com\\\/blog\\\/improved-mapping-from-google-spreadsheets\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.zeemaps.com\\\/blog\\\/improved-mapping-from-google-spreadsheets\\\/\"},\"author\":{\"name\":\"zeemaps\",\"@id\":\"https:\\\/\\\/www.zeemaps.com\\\/blog\\\/#\\\/schema\\\/person\\\/01ec07516b57be99c58bb304e3f62cdd\"},\"headline\":\"Improved Mapping from Google Spreadsheets\",\"datePublished\":\"2012-06-19T22:14:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.zeemaps.com\\\/blog\\\/improved-mapping-from-google-spreadsheets\\\/\"},\"wordCount\":239,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.zeemaps.com\\\/blog\\\/#organization\"},\"articleSection\":[\"Add markers\",\"Google Spreadsheets\",\"Upload multiple points\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.zeemaps.com\\\/blog\\\/improved-mapping-from-google-spreadsheets\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.zeemaps.com\\\/blog\\\/improved-mapping-from-google-spreadsheets\\\/\",\"url\":\"https:\\\/\\\/www.zeemaps.com\\\/blog\\\/improved-mapping-from-google-spreadsheets\\\/\",\"name\":\"Improved Mapping from Google Spreadsheets - Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.zeemaps.com\\\/blog\\\/#website\"},\"datePublished\":\"2012-06-19T22:14:54+00:00\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.zeemaps.com\\\/blog\\\/improved-mapping-from-google-spreadsheets\\\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.zeemaps.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.zeemaps.com\\\/blog\\\/\",\"name\":\"ZeeMaps Blog\",\"description\":\"News and tips for map maker -- ZeeMaps\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.zeemaps.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.zeemaps.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.zeemaps.com\\\/blog\\\/#organization\",\"name\":\"ZeeMaps\",\"url\":\"https:\\\/\\\/www.zeemaps.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.zeemaps.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.zeemaps.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/www.zeemaps.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/logo.png\",\"width\":150,\"height\":40,\"caption\":\"ZeeMaps\"},\"image\":{\"@id\":\"https:\\\/\\\/www.zeemaps.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/zeemaps\\\/?eid=ARAnw5BHDEcPHqlBzf_tUU6RxgnuKkzgzT5s5QMgIRYMwX0SqumGMVw2js5zh-5w0hMXyIK_SJuSQ3aN\",\"https:\\\/\\\/x.com\\\/zeemaps\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.zeemaps.com\\\/blog\\\/#\\\/schema\\\/person\\\/01ec07516b57be99c58bb304e3f62cdd\",\"name\":\"zeemaps\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d823061c30eb63d873dfbdd7c7cc5b7c6a4a5644c2e18512b220362f37e66ad8?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d823061c30eb63d873dfbdd7c7cc5b7c6a4a5644c2e18512b220362f37e66ad8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d823061c30eb63d873dfbdd7c7cc5b7c6a4a5644c2e18512b220362f37e66ad8?s=96&d=mm&r=g\",\"caption\":\"zeemaps\"},\"url\":\"https:\\\/\\\/www.zeemaps.com\\\/blog\\\/author\\\/zeemaps\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Improved Mapping from Google Spreadsheets - Blog","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.zeemaps.com\/blog\/improved-mapping-from-google-spreadsheets\/","og_locale":"en_US","og_type":"article","og_title":"Improved Mapping from Google Spreadsheets","og_description":"We have removed the limitation on Google Spreadsheet names, and simplified how we access your spreadsheets using the standard OAuth [&hellip;]","og_url":"https:\/\/www.zeemaps.com\/blog\/improved-mapping-from-google-spreadsheets\/","og_site_name":"Blog","article_publisher":"https:\/\/www.facebook.com\/zeemaps\/?eid=ARAnw5BHDEcPHqlBzf_tUU6RxgnuKkzgzT5s5QMgIRYMwX0SqumGMVw2js5zh-5w0hMXyIK_SJuSQ3aN","article_published_time":"2012-06-19T22:14:54+00:00","author":"zeemaps","twitter_card":"summary_large_image","twitter_creator":"@zeemaps","twitter_site":"@zeemaps","twitter_misc":{"Written by":"zeemaps","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.zeemaps.com\/blog\/improved-mapping-from-google-spreadsheets\/#article","isPartOf":{"@id":"https:\/\/www.zeemaps.com\/blog\/improved-mapping-from-google-spreadsheets\/"},"author":{"name":"zeemaps","@id":"https:\/\/www.zeemaps.com\/blog\/#\/schema\/person\/01ec07516b57be99c58bb304e3f62cdd"},"headline":"Improved Mapping from Google Spreadsheets","datePublished":"2012-06-19T22:14:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.zeemaps.com\/blog\/improved-mapping-from-google-spreadsheets\/"},"wordCount":239,"commentCount":0,"publisher":{"@id":"https:\/\/www.zeemaps.com\/blog\/#organization"},"articleSection":["Add markers","Google Spreadsheets","Upload multiple points"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.zeemaps.com\/blog\/improved-mapping-from-google-spreadsheets\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.zeemaps.com\/blog\/improved-mapping-from-google-spreadsheets\/","url":"https:\/\/www.zeemaps.com\/blog\/improved-mapping-from-google-spreadsheets\/","name":"Improved Mapping from Google Spreadsheets - Blog","isPartOf":{"@id":"https:\/\/www.zeemaps.com\/blog\/#website"},"datePublished":"2012-06-19T22:14:54+00:00","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.zeemaps.com\/blog\/improved-mapping-from-google-spreadsheets\/"]}]},{"@type":"WebSite","@id":"https:\/\/www.zeemaps.com\/blog\/#website","url":"https:\/\/www.zeemaps.com\/blog\/","name":"ZeeMaps Blog","description":"News and tips for map maker -- ZeeMaps","publisher":{"@id":"https:\/\/www.zeemaps.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.zeemaps.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.zeemaps.com\/blog\/#organization","name":"ZeeMaps","url":"https:\/\/www.zeemaps.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.zeemaps.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.zeemaps.com\/blog\/wp-content\/uploads\/2020\/08\/logo.png","contentUrl":"https:\/\/www.zeemaps.com\/blog\/wp-content\/uploads\/2020\/08\/logo.png","width":150,"height":40,"caption":"ZeeMaps"},"image":{"@id":"https:\/\/www.zeemaps.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/zeemaps\/?eid=ARAnw5BHDEcPHqlBzf_tUU6RxgnuKkzgzT5s5QMgIRYMwX0SqumGMVw2js5zh-5w0hMXyIK_SJuSQ3aN","https:\/\/x.com\/zeemaps"]},{"@type":"Person","@id":"https:\/\/www.zeemaps.com\/blog\/#\/schema\/person\/01ec07516b57be99c58bb304e3f62cdd","name":"zeemaps","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d823061c30eb63d873dfbdd7c7cc5b7c6a4a5644c2e18512b220362f37e66ad8?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d823061c30eb63d873dfbdd7c7cc5b7c6a4a5644c2e18512b220362f37e66ad8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d823061c30eb63d873dfbdd7c7cc5b7c6a4a5644c2e18512b220362f37e66ad8?s=96&d=mm&r=g","caption":"zeemaps"},"url":"https:\/\/www.zeemaps.com\/blog\/author\/zeemaps\/"}]}},"modified_by":null,"_links":{"self":[{"href":"https:\/\/www.zeemaps.com\/blog\/wp-json\/wp\/v2\/posts\/260","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.zeemaps.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.zeemaps.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.zeemaps.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.zeemaps.com\/blog\/wp-json\/wp\/v2\/comments?post=260"}],"version-history":[{"count":0,"href":"https:\/\/www.zeemaps.com\/blog\/wp-json\/wp\/v2\/posts\/260\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.zeemaps.com\/blog\/wp-json\/wp\/v2\/media?parent=260"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.zeemaps.com\/blog\/wp-json\/wp\/v2\/categories?post=260"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zeemaps.com\/blog\/wp-json\/wp\/v2\/tags?post=260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}