{"id":100,"date":"2013-06-06T21:59:56","date_gmt":"2013-06-06T21:59:56","guid":{"rendered":"http:\/\/content.zeemaps.com\/mapping\/?page_id=100"},"modified":"2013-06-06T21:59:56","modified_gmt":"2013-06-06T21:59:56","slug":"map-software-for-google-spreadsheets","status":"publish","type":"page","link":"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/map-software-for-google-spreadsheets\/","title":{"rendered":"How to map data using Cloud Drive spreadsheet"},"content":{"rendered":"

How do I upload my Cloud Drive spreadsheet data to a map?<\/strong><\/h3>\n

To upload a spreadsheet, go to your map and select ‘Additions’ then ‘Add (Upload) Multiple Markers’ from the menu. \u00a0Select the ‘Cloud Drive Spreadsheet’ option. You can choose to work with Google Drive or Microsoft One Drive in the ‘Provider’ drop-down.<\/p>\n

\"Choose<\/a>
Choose your provider to fetch a spreadsheet<\/figcaption><\/figure>\n

At this point, a window will be activated that asks you to sign-in to your Google Drive\/Microsoft OneDrive account and give ZeeMaps access (you can revoke this right at any time). Once you\u2019ve granted access, you should see a list of your spreadsheets and be able to select the spreadsheet that you want to upload to the map. From here on, follow the\u00a0<\/span>steps for uploading a spreadsheet to a map<\/a>.<\/span><\/p>\n

Can I set up automatic updates from a spreadsheet?<\/strong><\/h3>\n

Yes, ZeeMaps can\u00a0periodically update the map as the spreadsheet changes. You upload and attach your Google\/Microsoft spreadsheet to a map only once (as outlined above), making sure that you check the option for ‘Regularly update from Cloud Spreadsheet’ in the upload process. Your map will be automatically updated as your spreadsheet changes. This way, you do not have to worry about making changes to both your spreadsheet and your map.<\/p>\n

Why aren’t my automatic updates working?<\/strong><\/h3>\n

In order for the auto updates to work, you can’t change the name or location of the spreadsheet, or the columns of your spreadsheet.\u00a0If you need to make these changes to your spreadsheet, you must delete all data from your map and re-upload and attach your spreadsheet.<\/p>\n

How often are spreadsheets sync’d?<\/strong><\/h3>\n

We update the data on your map from your spreadsheet every 5 hours, starting at 0:00 UTC.<\/p>\n

If I change my map, will that be reflected in my spreadsheet?<\/strong><\/h3>\n

No, the automatic updates work from the spreadsheet to map, but not the other way around.<\/p>\n

\n

How do I see what spreadsheets are attached to my maps?<\/strong><\/h3>\n

Go into the map you want to find out about. Select ‘View’ then ‘Cloud Drive Spreadsheets’ from the menu.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

How do I upload my Cloud Drive spreadsheet data to a map? To upload a spreadsheet, go to your map […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":16,"menu_order":4,"comment_status":"closed","ping_status":"closed","template":"","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":"","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":""},"class_list":["post-100","page","type-page","status-publish","hentry"],"yoast_head":"\nUse Cloud Drive spreadsheet data to make a map - ZeeMaps<\/title>\n<meta name=\"description\" content=\"Attach a Cloud Drive spreadsheet to make a ZeeMaps map. Turn your location data into a map that is automatically updated as the spreadsheet changes.\" \/>\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\/mapping\/create-a-map\/map-software-for-google-spreadsheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to map data using Cloud Drive spreadsheet\" \/>\n<meta property=\"og:description\" content=\"Attach a Cloud Drive spreadsheet to make a ZeeMaps map. Turn your location data into a map that is automatically updated as the spreadsheet changes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/map-software-for-google-spreadsheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Help\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/zeemaps\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2013\/06\/Screen-Shot-2017-08-17-at-16.39.34-1024x463.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@zeemaps\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/map-software-for-google-spreadsheets\/\",\"url\":\"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/map-software-for-google-spreadsheets\/\",\"name\":\"Use Cloud Drive spreadsheet data to make a map - ZeeMaps\",\"isPartOf\":{\"@id\":\"https:\/\/www.zeemaps.com\/mapping\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/map-software-for-google-spreadsheets\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/map-software-for-google-spreadsheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2013\/06\/Screen-Shot-2017-08-17-at-16.39.34-1024x463.png\",\"datePublished\":\"2013-06-06T21:59:56+00:00\",\"description\":\"Attach a Cloud Drive spreadsheet to make a ZeeMaps map. Turn your location data into a map that is automatically updated as the spreadsheet changes.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/map-software-for-google-spreadsheets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/map-software-for-google-spreadsheets\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/map-software-for-google-spreadsheets\/#primaryimage\",\"url\":\"https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2013\/06\/Screen-Shot-2017-08-17-at-16.39.34.png\",\"contentUrl\":\"https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2013\/06\/Screen-Shot-2017-08-17-at-16.39.34.png\",\"width\":1606,\"height\":726},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/map-software-for-google-spreadsheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Create a Map – ZeeMaps How To\",\"item\":\"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to map data using Cloud Drive spreadsheet\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.zeemaps.com\/mapping\/#website\",\"url\":\"https:\/\/www.zeemaps.com\/mapping\/\",\"name\":\"ZeeMaps Help\",\"description\":\"Tutorials on using ZeeMaps\",\"publisher\":{\"@id\":\"https:\/\/www.zeemaps.com\/mapping\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.zeemaps.com\/mapping\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.zeemaps.com\/mapping\/#organization\",\"name\":\"ZeeMaps\",\"url\":\"https:\/\/www.zeemaps.com\/mapping\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.zeemaps.com\/mapping\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2020\/05\/logo.png\",\"contentUrl\":\"https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2020\/05\/logo.png\",\"width\":171,\"height\":41,\"caption\":\"ZeeMaps\"},\"image\":{\"@id\":\"https:\/\/www.zeemaps.com\/mapping\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/zeemaps\",\"https:\/\/x.com\/zeemaps\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Use Cloud Drive spreadsheet data to make a map - ZeeMaps","description":"Attach a Cloud Drive spreadsheet to make a ZeeMaps map. Turn your location data into a map that is automatically updated as the spreadsheet changes.","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\/mapping\/create-a-map\/map-software-for-google-spreadsheets\/","og_locale":"en_US","og_type":"article","og_title":"How to map data using Cloud Drive spreadsheet","og_description":"Attach a Cloud Drive spreadsheet to make a ZeeMaps map. Turn your location data into a map that is automatically updated as the spreadsheet changes.","og_url":"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/map-software-for-google-spreadsheets\/","og_site_name":"Help","article_publisher":"https:\/\/www.facebook.com\/zeemaps","og_image":[{"url":"https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2013\/06\/Screen-Shot-2017-08-17-at-16.39.34-1024x463.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@zeemaps","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/map-software-for-google-spreadsheets\/","url":"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/map-software-for-google-spreadsheets\/","name":"Use Cloud Drive spreadsheet data to make a map - ZeeMaps","isPartOf":{"@id":"https:\/\/www.zeemaps.com\/mapping\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/map-software-for-google-spreadsheets\/#primaryimage"},"image":{"@id":"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/map-software-for-google-spreadsheets\/#primaryimage"},"thumbnailUrl":"https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2013\/06\/Screen-Shot-2017-08-17-at-16.39.34-1024x463.png","datePublished":"2013-06-06T21:59:56+00:00","description":"Attach a Cloud Drive spreadsheet to make a ZeeMaps map. Turn your location data into a map that is automatically updated as the spreadsheet changes.","breadcrumb":{"@id":"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/map-software-for-google-spreadsheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.zeemaps.com\/mapping\/create-a-map\/map-software-for-google-spreadsheets\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/map-software-for-google-spreadsheets\/#primaryimage","url":"https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2013\/06\/Screen-Shot-2017-08-17-at-16.39.34.png","contentUrl":"https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2013\/06\/Screen-Shot-2017-08-17-at-16.39.34.png","width":1606,"height":726},{"@type":"BreadcrumbList","@id":"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/map-software-for-google-spreadsheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Create a Map – ZeeMaps How To","item":"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/"},{"@type":"ListItem","position":2,"name":"How to map data using Cloud Drive spreadsheet"}]},{"@type":"WebSite","@id":"https:\/\/www.zeemaps.com\/mapping\/#website","url":"https:\/\/www.zeemaps.com\/mapping\/","name":"ZeeMaps Help","description":"Tutorials on using ZeeMaps","publisher":{"@id":"https:\/\/www.zeemaps.com\/mapping\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.zeemaps.com\/mapping\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.zeemaps.com\/mapping\/#organization","name":"ZeeMaps","url":"https:\/\/www.zeemaps.com\/mapping\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.zeemaps.com\/mapping\/#\/schema\/logo\/image\/","url":"https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2020\/05\/logo.png","contentUrl":"https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2020\/05\/logo.png","width":171,"height":41,"caption":"ZeeMaps"},"image":{"@id":"https:\/\/www.zeemaps.com\/mapping\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/zeemaps","https:\/\/x.com\/zeemaps"]}]}},"_links":{"self":[{"href":"https:\/\/www.zeemaps.com\/mapping\/wp-json\/wp\/v2\/pages\/100","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.zeemaps.com\/mapping\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.zeemaps.com\/mapping\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.zeemaps.com\/mapping\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.zeemaps.com\/mapping\/wp-json\/wp\/v2\/comments?post=100"}],"version-history":[{"count":0,"href":"https:\/\/www.zeemaps.com\/mapping\/wp-json\/wp\/v2\/pages\/100\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.zeemaps.com\/mapping\/wp-json\/wp\/v2\/pages\/16"}],"wp:attachment":[{"href":"https:\/\/www.zeemaps.com\/mapping\/wp-json\/wp\/v2\/media?parent=100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}