{"id":99,"date":"2013-06-06T21:59:29","date_gmt":"2013-06-06T21:59:29","guid":{"rendered":"http:\/\/content.zeemaps.com\/mapping\/?page_id=99"},"modified":"2013-06-06T21:59:29","modified_gmt":"2013-06-06T21:59:29","slug":"how-to-map-data-from-spreadsheet","status":"publish","type":"page","link":"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/how-to-map-data-from-spreadsheet\/","title":{"rendered":"How to map data from Excel"},"content":{"rendered":"<h2><strong>How do I map data using Excel spreadsheets?<\/strong><\/h2>\n<p>This video explains how to work with Excel spreadsheets in ZeeMaps:<\/p>\n<div class=\"ast-oembed-container \" style=\"height: 100%;\"><iframe loading=\"lazy\" title=\"How to Map a Spreadsheet in ZeeMaps\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/pWAyqxjFcL8?start=6&#038;feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/div>\n<h2><strong>How do I map data from other spreadsheets?<\/strong><\/h2>\n<p>ZeeMaps provides a flexible and easy way to map data from spreadsheets. You can upload your spreadsheet onto a map, copy a table and paste it into a form in ZeeMaps, or attach a Google Drive spreadsheet to a map.<\/p>\n<p>To upload a spreadsheet, select &#8216;Additions&#8217; from the menu on your map, then &#8216;Add (Upload) Multiple Markers&#8217;. Choose the &#8216;Upload Spreadsheet&#8217; option. You will get a dialog to browse and select your spreadsheet. If you want, you can also use the &#8216;Copy-and-Paste Table&#8217; option, or the &#8216;Cloud Drive Spreadsheet&#8217; option.<\/p>\n<figure id=\"attachment_374\" aria-describedby=\"caption-attachment-374\" style=\"width: 1024px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2013\/06\/Screen-Shot-2017-08-11-at-13.50.09.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-374 size-large\" title=\"How to upload your Excel spreadsheet to populate a ZeeMaps map\" src=\"https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2013\/06\/Screen-Shot-2017-08-11-at-13.50.09-1024x465.png\" alt=\"How to upload your Excel spreadsheet to populate a ZeeMaps map\" width=\"1024\" height=\"465\" srcset=\"https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2013\/06\/Screen-Shot-2017-08-11-at-13.50.09-1024x465.png 1024w, https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2013\/06\/Screen-Shot-2017-08-11-at-13.50.09-300x136.png 300w, https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2013\/06\/Screen-Shot-2017-08-11-at-13.50.09-768x349.png 768w, https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2013\/06\/Screen-Shot-2017-08-11-at-13.50.09-1536x698.png 1536w, https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2013\/06\/Screen-Shot-2017-08-11-at-13.50.09.png 1898w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption id=\"caption-attachment-374\" class=\"wp-caption-text\">How to upload your Excel spreadsheet to populate a ZeeMaps map<\/figcaption><\/figure>\n<p><span style=\"font-size: inherit;\">Your spreadsheet should have information on it that allows us to determine the location for each row, e.g., a post code, zip code, city, state, etc. Additionally, you can have as many columns as you need. Some columns, such as the &#8216;Name&#8217; column, will be utilized as one of the &#8220;standard&#8221; columns, while others will add fields to your markers.<\/span><\/p>\n<p>Spreadsheets can also contain street address, city, and state. You can provide latitude, longitude columns as well. The more information you provide, the better we&#8217;ll be able to position the pins.<\/p>\n<p>When you upload your spreadsheet, ZeeMaps uses the header row to determine how to use the data in each column. The standard columns names that ZeeMaps uses are described below. As noted above, you do not need to provide all columns. Just enough information for ZeeMaps to locate your entries. For example, you can provide just Name and Postal Code columns, or Name and City columns.<\/p>\n<h2><strong>What are the standard columns?<\/strong><\/h2>\n<ul>\n<li><strong>Address Street:<\/strong>\u00a0Street location, e.g, 1 Apple Loop. Can also be full location address.<\/li>\n<li><strong>City:<\/strong>\u00a0City, e.g, Cupertino<\/li>\n<li><strong>State:<\/strong>\u00a0State, e.g, CA or California<\/li>\n<li><strong>Country:<\/strong>\u00a0Country, e.g, US, UK, USA<\/li>\n<li><strong>Post Code:<\/strong>\u00a0Zip code or postal code, e.g., 95014 or<\/li>\n<li><strong>Name:<\/strong>\u00a0Title for the entry. If you do not provide a Name column, your entries will be called &#8220;Anonymous&#8221;<\/li>\n<li><strong>Category:<\/strong>\u00a0Grouping of your entry into different categories, e.g., Gold, Silver, Platinum. Each category will show as a different colored marker. ZeeMaps will also automatically create a legend based on the categories, in the order that they appeared in the spreadsheet. You can re-order them by selecting &#8216;Map&#8217; then &#8216;Legend&#8217; from the menu. We support up to 31 categories.<\/li>\n<li><strong>Latitude:<\/strong>\u00a0In decimals, e.g., 34.23<\/li>\n<li><strong>Longitude:<\/strong>\u00a0In decimals, e.g., -121.05<\/li>\n<li><strong>Photo URL:<\/strong>\u00a0If you want, you can specify a photo URL for each entry<\/li>\n<li><strong>Photo width:<\/strong>\u00a0Width of the photo element for an entry in pixels<\/li>\n<li><strong>Photo height:<\/strong>\u00a0Height in pixels<\/li>\n<li><strong>YouTube:<\/strong>\u00a0Specify a YouTube video ID for your entry. (Note that this is just the video ID and not the full URL).<\/li>\n<li><strong>Video width:<\/strong>\u00a0Width in pixels<\/li>\n<li><strong>Video height:<\/strong>\u00a0Height in pixels<\/li>\n<\/ul>\n<p>When you upload your Excel spreadsheet &#8211; or another spreadsheet &#8211; ZeeMaps will ask you to make assignments for the standard columns to your spreadsheet columns. You do not need to have all the columns, just enough information that we can figure out the location for your markers. All columns from your spreadsheet that do not get mapped to a standard column will be used as custom fields of information attached to each marker. You can use these fields later to search on your map.<\/p>\n<h2>Can I ignore data?<\/h2>\n<p>Yes. If you have more columns in your spreadsheet than you&#8217;d like to upload, you can use the &#8216;Ignore&#8217; tab in the spreadsheet uploader. Just select all the columns that you don&#8217;t want to see on the map.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How do I map data using Excel spreadsheets? This video explains how to work with Excel spreadsheets in ZeeMaps: How [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":16,"menu_order":3,"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-99","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.7.1 (Yoast SEO v25.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to map data from Excel and other spreadsheets - ZeeMaps<\/title>\n<meta name=\"description\" content=\"ZeeMaps allows you to use Excel and other spreadsheets to map your data with multiple locations. Flexible and easy, here&#039;s a step-by-step guide.\" \/>\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\/how-to-map-data-from-spreadsheet\/\" \/>\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 from Excel\" \/>\n<meta property=\"og:description\" content=\"ZeeMaps allows you to use Excel and other spreadsheets to map your data with multiple locations. Flexible and easy, here&#039;s a step-by-step guide.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/how-to-map-data-from-spreadsheet\/\" \/>\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-11-at-13.50.09-1024x465.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=\"3 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\/how-to-map-data-from-spreadsheet\/\",\"url\":\"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/how-to-map-data-from-spreadsheet\/\",\"name\":\"How to map data from Excel and other spreadsheets - ZeeMaps\",\"isPartOf\":{\"@id\":\"https:\/\/www.zeemaps.com\/mapping\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/how-to-map-data-from-spreadsheet\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/how-to-map-data-from-spreadsheet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2013\/06\/Screen-Shot-2017-08-11-at-13.50.09-1024x465.png\",\"datePublished\":\"2013-06-06T21:59:29+00:00\",\"description\":\"ZeeMaps allows you to use Excel and other spreadsheets to map your data with multiple locations. Flexible and easy, here's a step-by-step guide.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/how-to-map-data-from-spreadsheet\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/how-to-map-data-from-spreadsheet\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/how-to-map-data-from-spreadsheet\/#primaryimage\",\"url\":\"https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2013\/06\/Screen-Shot-2017-08-11-at-13.50.09.png\",\"contentUrl\":\"https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2013\/06\/Screen-Shot-2017-08-11-at-13.50.09.png\",\"width\":1898,\"height\":862},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/how-to-map-data-from-spreadsheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Create a Map &#8211; ZeeMaps How To\",\"item\":\"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to map data from Excel\"}]},{\"@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":"How to map data from Excel and other spreadsheets - ZeeMaps","description":"ZeeMaps allows you to use Excel and other spreadsheets to map your data with multiple locations. Flexible and easy, here's a step-by-step guide.","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\/how-to-map-data-from-spreadsheet\/","og_locale":"en_US","og_type":"article","og_title":"How to map data from Excel","og_description":"ZeeMaps allows you to use Excel and other spreadsheets to map your data with multiple locations. Flexible and easy, here's a step-by-step guide.","og_url":"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/how-to-map-data-from-spreadsheet\/","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-11-at-13.50.09-1024x465.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@zeemaps","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/how-to-map-data-from-spreadsheet\/","url":"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/how-to-map-data-from-spreadsheet\/","name":"How to map data from Excel and other spreadsheets - ZeeMaps","isPartOf":{"@id":"https:\/\/www.zeemaps.com\/mapping\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/how-to-map-data-from-spreadsheet\/#primaryimage"},"image":{"@id":"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/how-to-map-data-from-spreadsheet\/#primaryimage"},"thumbnailUrl":"https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2013\/06\/Screen-Shot-2017-08-11-at-13.50.09-1024x465.png","datePublished":"2013-06-06T21:59:29+00:00","description":"ZeeMaps allows you to use Excel and other spreadsheets to map your data with multiple locations. Flexible and easy, here's a step-by-step guide.","breadcrumb":{"@id":"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/how-to-map-data-from-spreadsheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.zeemaps.com\/mapping\/create-a-map\/how-to-map-data-from-spreadsheet\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/how-to-map-data-from-spreadsheet\/#primaryimage","url":"https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2013\/06\/Screen-Shot-2017-08-11-at-13.50.09.png","contentUrl":"https:\/\/www.zeemaps.com\/mapping\/wp-content\/uploads\/2013\/06\/Screen-Shot-2017-08-11-at-13.50.09.png","width":1898,"height":862},{"@type":"BreadcrumbList","@id":"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/how-to-map-data-from-spreadsheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Create a Map &#8211; ZeeMaps How To","item":"https:\/\/www.zeemaps.com\/mapping\/create-a-map\/"},{"@type":"ListItem","position":2,"name":"How to map data from Excel"}]},{"@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\/99","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=99"}],"version-history":[{"count":0,"href":"https:\/\/www.zeemaps.com\/mapping\/wp-json\/wp\/v2\/pages\/99\/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=99"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}