{"id":1329,"date":"2014-06-05T13:40:17","date_gmt":"2014-06-05T13:40:17","guid":{"rendered":"http:\/\/blogs.library.duke.edu\/data\/?p=1329"},"modified":"2014-06-05T13:40:17","modified_gmt":"2014-06-05T13:40:17","slug":"mapping-in-google-spreadsheets","status":"publish","type":"post","link":"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/","title":{"rendered":"Mapping in Google Spreadsheets"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignright size-medium wp-image-1439\" src=\"http:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.33.57-PM1-280x300.png\" alt=\"Screen Shot 2014-06-04 at 4.33.57 PM\" width=\"280\" height=\"300\" srcset=\"https:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.33.57-PM1-280x300.png 280w, https:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.33.57-PM1.png 332w\" sizes=\"auto, (max-width: 280px) 100vw, 280px\" \/>Here at Data &amp; GIS Services, we love finding new ways to map things.\u00a0 Earlier this semester I was researching how the <a href=\"https:\/\/support.google.com\/docs\/topic\/20322?hl=en&amp;ref_topic=2811806\">Sheets<\/a> tool in <a href=\"http:\/\/drive.google.com\/\">Google Drive<\/a> could be used as a quick and easy visualization tool when I re-discovered its simple <a href=\"https:\/\/support.google.com\/docs\/answer\/1409802?hl=en&amp;ref_topic=30240\">map<\/a> functionality.\u00a0 While there are plenty of more powerful mapping tools if you want to have a lot of features (e.g., <a href=\"http:\/\/guides.library.duke.edu\/arcgis\">ArcGIS<\/a>, <a href=\"http:\/\/www.qgis.org\/en\/site\/\">QGIS<\/a>, <a href=\"http:\/\/guides.library.duke.edu\/fusion_tables\">Google Fusion Tables<\/a>, <a href=\"http:\/\/guides.library.duke.edu\/google_earth\">Google Earth<\/a>, <a href=\"http:\/\/guides.library.duke.edu\/geocommons\">GeoCommons<\/a>, <a href=\"http:\/\/guides.library.duke.edu\/tableau\">Tableau<\/a>, <a href=\"http:\/\/cartodb.com\/\">CartoDB<\/a>), you might consider just sticking with a spreadsheet for some of your simpler projects.<\/p>\n<p>I&#8217;ve created a few examples in a public <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1bmwIWh43y9T6HQK8ctSoCfdhIUBdaBs1fAsILg6hrBE\/edit?usp=sharing\">Google Sheet<\/a>, so you can see what the data and final maps look like.\u00a0 If you&#8217;d like to try creating these maps yourself, you can use this <a href=\"https:\/\/drive.google.com\/previewtemplate?id=0Agy_OAo_DS4PdHBmdUdOZm5VZ2ZDTFhHdHhyLXBRNmc&amp;mode=public\">template<\/a> (you&#8217;ll have to log into your Google account first, and then click on the &#8220;Use this template&#8221; button to get your own copy of the spreadsheet).<\/p>\n<h3>Organizing Your Data<\/h3>\n<p>The main thing to remember when trying to create any map or chart in a Google sheet is that the tool is very particular about the order of columns.\u00a0 For any map, you will need (exactly) two columns.\u00a0 According to the error message that pops up if your columns are problematic: &#8220;The first column should contain location names or addresses. The second column should contain numeric values.&#8221;<\/p>\n<p>Of course, I was curious about what counts as &#8220;location names&#8221; and wanted to test the limits of this GeoMap chart.\u00a0 If you have any experience with the <a href=\"https:\/\/developers.google.com\/chart\/\">Google Charts API<\/a>, you might expect the Google Sheet GeoMap chart to work like the <a href=\"https:\/\/code.google.com\/apis\/ajax\/playground\/?type=visualization#geo_chart\">Geo Chart<\/a> offered there.\u00a0 In the spreadsheet, however, you have only a small set of options compared to the charts API.\u00a0 You do have two map options &#8212; a &#8220;region&#8221; (or <a href=\"http:\/\/guides.library.duke.edu\/vis_types#planar\">choropleth<\/a>) map and a &#8220;marker&#8221; (or <a href=\"http:\/\/guides.library.duke.edu\/vis_types#planar\">proportional symbol<\/a>) map &#8212; but the choices for color shading and bubble size are built-in or limited.<\/p>\n<h4><img loading=\"lazy\" decoding=\"async\" class=\"alignright size-medium wp-image-1433\" src=\"http:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.36.54-PM-300x179.png\" alt=\"Screen Shot 2014-06-04 at 4.36.54 PM\" width=\"300\" height=\"179\" srcset=\"https:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.36.54-PM-300x179.png 300w, https:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.36.54-PM.png 563w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/>Region maps (Choropleths)<\/h4>\n<p>Region maps are fairly restrictive, because Google needs to know the exact boundary of the country or state that you&#8217;re interested in.\u00a0 In a nutshell, a region map can either use country names (or abbreviations) or state names (or abbreviations).\u00a0 The <a href=\"http:\/\/en.wikipedia.org\/wiki\/ISO_3166-1_alpha-2#Officially_assigned_code_elements\">ISO 3166-1 alpha-2 codes<\/a> seem to work exceptionally well for countries (blazing fast speeds!), but the full country name works well, too.\u00a0 For US states, I also recommend the two letter state abbreviation instead of the full state name. If you ever want to switch the map from &#8220;region&#8221; to &#8220;marker&#8221;, the abbreviations are much more specific than the name of the state.\u00a0 (For example, when I switch my &#8220;2008 US pres election&#8221; map to marker, Washington state turns into a bubble over Washington DC.)<\/p>\n<h4><img loading=\"lazy\" decoding=\"async\" class=\"alignright size-medium wp-image-1434\" src=\"http:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.37.57-PM-300x210.png\" alt=\"Screen Shot 2014-06-04 at 4.37.57 PM\" width=\"300\" height=\"210\" srcset=\"https:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.37.57-PM-300x210.png 300w, https:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.37.57-PM.png 315w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/>Marker maps (Proportional symbol maps)<\/h4>\n<p>Marker maps, on the other hand, allow for much more flexibility.\u00a0 In fact, the marker map in Google Sheets will actually geocode street addresses for you.\u00a0 In general, the marker map will work best if the first column (the location column) includes information that is as specific as possible.\u00a0 As I mentioned before, the word &#8220;Washington&#8221; will go through a search engine and will get matched to Washington DC before Washington state.\u00a0 Same with New York.\u00a0 But the marker map will basically do the search on any text, so the spreadsheet cell can say &#8220;NY&#8221;, or &#8220;100 State Street, Ithaca, NY&#8221;, or even the specific latitude and longitude of a place. (See the &#8220;World Capitals with lat\/lon&#8221; sheet; I just put latitude and longitude in a single column, separated with a comma.)\u00a0 As long as the location information is in a single column, it should work, but the more specific the information is, the better.<\/p>\n<h3>Procedure<\/h3>\n<p><a href=\"http:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.31.56-PM1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-1436 size-medium\" src=\"http:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.31.56-PM1-300x193.png\" alt=\"Screen Shot 2014-06-04 at 4.31.56 PM\" width=\"300\" height=\"193\" srcset=\"https:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.31.56-PM1-300x193.png 300w, https:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.31.56-PM1-1024x660.png 1024w, https:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.31.56-PM1.png 1049w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a>When you have your data ready and want to create a map, just select the correct two columns in your spreadsheet, making sure that the first one has appropriate location information and the second one has some kind of numerical data.\u00a0 Then click on the &#8220;Insert&#8221; menu and go down to &#8220;Chart&#8230;&#8221;\u00a0 You&#8217;ll get the chart editor.\u00a0 The first screen will be the &#8220;Start&#8221; tab, and Google will try to guess what chart you&#8217;re trying to use.\u00a0 It probably won&#8217;t guess a map on the first try, so just click on the &#8220;Charts&#8221; tab at the top to manually select a map.\u00a0 Map is one of the lower options on the left hand side, and then you&#8217;ll be given a choice between the regions and markers maps.\u00a0 After you select the map, you can either stick with the defaults or go straight to the final tab, &#8220;Customize,&#8221; to change the colors or to zoom your map into a different region.\u00a0 (NB: As far as I can tell, the only regions that actually work are &#8220;World,&#8221; &#8220;United States,&#8221; &#8220;Europe,&#8221; and &#8220;Asia&#8221;.)<\/p>\n<p><a href=\"http:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.33.35-PM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-1437 size-medium\" src=\"http:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.33.35-PM-300x199.png\" alt=\"Screen Shot 2014-06-04 at 4.33.35 PM\" width=\"300\" height=\"199\" srcset=\"https:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.33.35-PM-300x199.png 300w, https:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.33.35-PM.png 1013w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a>The default color scale goes from red to white to green.\u00a0 You&#8217;ll notice that the maps automatically have a &#8220;mid&#8221; value for the color.\u00a0 If you&#8217;d rather go straight from white to a dark color, just choose something in the middle for the &#8220;mid&#8221; color.<\/p>\n<p>And there you have it!\u00a0 You can&#8217;t change anything beyond the region and the colors, so once you&#8217;ve customized those you can click &#8220;Update&#8221; and check out your map.\u00a0 Don&#8217;t like something?\u00a0 Click on the map and a little arrow will appear in the upper right corner.\u00a0 Click there to open the menu, then click on &#8220;Advanced edit&#8230;&#8221; to get back to the chart editor.\u00a0 If you want a bigger version of the map, you can select &#8220;Move to own sheet&#8230;&#8221; from that same menu.<\/p>\n<h3>Pros and Cons<\/h3>\n<p>So, what are these maps good for?\u00a0 Well, firstly, they&#8217;re great if you have state or country data and you want a really quick view of the trends or errors in the data.\u00a0 Maybe you have a country missing and you didn&#8217;t even realize it.\u00a0 Maybe one of the values has an extra zero at the end and is much larger than expected.\u00a0 This kind of quick and dirty map might be exactly what you need to do some initial exploration of your data, all while staying in a spreadsheet program.<\/p>\n<p>Another good use of this tool is to make a map where you need to geocode addresses but also have proportional symbols.\u00a0 Google Fusion Tables will geocode addresses for you, but it is best for point maps where all the points are the same size or for density maps that calculate how tightly clusters those points are.\u00a0 If you want the points to be sized (and colored) according to a data variable, this is possibly the easiest geocoder I&#8217;ve found.\u00a0 It&#8217;ll take a while to search for all of the locations, though, and there is probably an upper limit of a couple of hundred rows.<\/p>\n<p>If this isn&#8217;t the tool for you, don&#8217;t despair!\u00a0 Make an appointment through email (<a href=\"mailto:askdata@duke.edu\">askdata@duke.edu<\/a>) or stop in to see us (<a href=\"http:\/\/library.duke.edu\/data\/about\/schedule\">walk-in schedule<\/a>) to learn about other mapping tools, or you can even check out these <a href=\"http:\/\/www.makeuseof.com\/tag\/7-ways-to-make-a-google-map-using-google-spreadsheet-data\/\">7 Ways to Make a Google Map Using Spreadsheet Data<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here at Data &amp; GIS Services, we love finding new ways to map things.\u00a0 Earlier this semester I was researching how the Sheets tool in Google Drive could be used as a quick and easy visualization tool when I re-discovered its simple map functionality.\u00a0 While there are plenty of more powerful mapping tools if you &hellip; <a href=\"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Mapping in Google Spreadsheets<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":175,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[16,7,27],"tags":[],"class_list":["post-1329","post","type-post","status-publish","format-standard","hentry","category-data-visualization","category-gis","category-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Mapping in Google Spreadsheets - Duke Libraries Center for Data and Visualization Sciences<\/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:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mapping in Google Spreadsheets - Duke Libraries Center for Data and Visualization Sciences\" \/>\n<meta property=\"og:description\" content=\"Here at Data &amp; GIS Services, we love finding new ways to map things.\u00a0 Earlier this semester I was researching how the Sheets tool in Google Drive could be used as a quick and easy visualization tool when I re-discovered its simple map functionality.\u00a0 While there are plenty of more powerful mapping tools if you &hellip; Continue reading Mapping in Google Spreadsheets &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Duke Libraries Center for Data and Visualization Sciences\" \/>\n<meta property=\"article:published_time\" content=\"2014-06-05T13:40:17+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.33.57-PM1-280x300.png\" \/>\n<meta name=\"author\" content=\"Angela Zoss\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@duke_data\" \/>\n<meta name=\"twitter:site\" content=\"@duke_data\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Angela Zoss\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/\"},\"author\":{\"name\":\"Angela Zoss\",\"@id\":\"https:\/\/blogs.library.duke.edu\/data\/#\/schema\/person\/beff977f881c7c1589cf40af66f2b1e7\"},\"headline\":\"Mapping in Google Spreadsheets\",\"datePublished\":\"2014-06-05T13:40:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/\"},\"wordCount\":1185,\"commentCount\":14,\"image\":{\"@id\":\"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.33.57-PM1-280x300.png\",\"articleSection\":[\"Data Visualization\",\"GIS\",\"tutorial\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/\",\"url\":\"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/\",\"name\":\"Mapping in Google Spreadsheets - Duke Libraries Center for Data and Visualization Sciences\",\"isPartOf\":{\"@id\":\"https:\/\/blogs.library.duke.edu\/data\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.33.57-PM1-280x300.png\",\"datePublished\":\"2014-06-05T13:40:17+00:00\",\"author\":{\"@id\":\"https:\/\/blogs.library.duke.edu\/data\/#\/schema\/person\/beff977f881c7c1589cf40af66f2b1e7\"},\"breadcrumb\":{\"@id\":\"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/#primaryimage\",\"url\":\"http:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.33.57-PM1-280x300.png\",\"contentUrl\":\"http:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.33.57-PM1-280x300.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/blogs.library.duke.edu\/data\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mapping in Google Spreadsheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blogs.library.duke.edu\/data\/#website\",\"url\":\"https:\/\/blogs.library.duke.edu\/data\/\",\"name\":\"Duke Libraries Center for Data and Visualization Sciences\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blogs.library.duke.edu\/data\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/blogs.library.duke.edu\/data\/#\/schema\/person\/beff977f881c7c1589cf40af66f2b1e7\",\"name\":\"Angela Zoss\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/blogs.library.duke.edu\/data\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/654dd0fde83d344da4d1c541960dee409fcf230f99b2efe7b110ae22ffe7f4b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/654dd0fde83d344da4d1c541960dee409fcf230f99b2efe7b110ae22ffe7f4b5?s=96&d=mm&r=g\",\"caption\":\"Angela Zoss\"},\"url\":\"https:\/\/blogs.library.duke.edu\/data\/author\/az49duke-edu\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Mapping in Google Spreadsheets - Duke Libraries Center for Data and Visualization Sciences","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:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/","og_locale":"en_US","og_type":"article","og_title":"Mapping in Google Spreadsheets - Duke Libraries Center for Data and Visualization Sciences","og_description":"Here at Data &amp; GIS Services, we love finding new ways to map things.\u00a0 Earlier this semester I was researching how the Sheets tool in Google Drive could be used as a quick and easy visualization tool when I re-discovered its simple map functionality.\u00a0 While there are plenty of more powerful mapping tools if you &hellip; Continue reading Mapping in Google Spreadsheets &rarr;","og_url":"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/","og_site_name":"Duke Libraries Center for Data and Visualization Sciences","article_published_time":"2014-06-05T13:40:17+00:00","og_image":[{"url":"http:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.33.57-PM1-280x300.png","type":"","width":"","height":""}],"author":"Angela Zoss","twitter_card":"summary_large_image","twitter_creator":"@duke_data","twitter_site":"@duke_data","twitter_misc":{"Written by":"Angela Zoss","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/#article","isPartOf":{"@id":"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/"},"author":{"name":"Angela Zoss","@id":"https:\/\/blogs.library.duke.edu\/data\/#\/schema\/person\/beff977f881c7c1589cf40af66f2b1e7"},"headline":"Mapping in Google Spreadsheets","datePublished":"2014-06-05T13:40:17+00:00","mainEntityOfPage":{"@id":"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/"},"wordCount":1185,"commentCount":14,"image":{"@id":"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/#primaryimage"},"thumbnailUrl":"http:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.33.57-PM1-280x300.png","articleSection":["Data Visualization","GIS","tutorial"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/","url":"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/","name":"Mapping in Google Spreadsheets - Duke Libraries Center for Data and Visualization Sciences","isPartOf":{"@id":"https:\/\/blogs.library.duke.edu\/data\/#website"},"primaryImageOfPage":{"@id":"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/#primaryimage"},"image":{"@id":"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/#primaryimage"},"thumbnailUrl":"http:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.33.57-PM1-280x300.png","datePublished":"2014-06-05T13:40:17+00:00","author":{"@id":"https:\/\/blogs.library.duke.edu\/data\/#\/schema\/person\/beff977f881c7c1589cf40af66f2b1e7"},"breadcrumb":{"@id":"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/#primaryimage","url":"http:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.33.57-PM1-280x300.png","contentUrl":"http:\/\/blogs.library.duke.edu\/data\/files\/2014\/06\/Screen-Shot-2014-06-04-at-4.33.57-PM1-280x300.png"},{"@type":"BreadcrumbList","@id":"https:\/\/blogs.library.duke.edu\/data\/2014\/06\/05\/mapping-in-google-spreadsheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blogs.library.duke.edu\/data\/"},{"@type":"ListItem","position":2,"name":"Mapping in Google Spreadsheets"}]},{"@type":"WebSite","@id":"https:\/\/blogs.library.duke.edu\/data\/#website","url":"https:\/\/blogs.library.duke.edu\/data\/","name":"Duke Libraries Center for Data and Visualization Sciences","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blogs.library.duke.edu\/data\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/blogs.library.duke.edu\/data\/#\/schema\/person\/beff977f881c7c1589cf40af66f2b1e7","name":"Angela Zoss","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blogs.library.duke.edu\/data\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/654dd0fde83d344da4d1c541960dee409fcf230f99b2efe7b110ae22ffe7f4b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/654dd0fde83d344da4d1c541960dee409fcf230f99b2efe7b110ae22ffe7f4b5?s=96&d=mm&r=g","caption":"Angela Zoss"},"url":"https:\/\/blogs.library.duke.edu\/data\/author\/az49duke-edu\/"}]}},"_links":{"self":[{"href":"https:\/\/blogs.library.duke.edu\/data\/wp-json\/wp\/v2\/posts\/1329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.library.duke.edu\/data\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.library.duke.edu\/data\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.library.duke.edu\/data\/wp-json\/wp\/v2\/users\/175"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.library.duke.edu\/data\/wp-json\/wp\/v2\/comments?post=1329"}],"version-history":[{"count":11,"href":"https:\/\/blogs.library.duke.edu\/data\/wp-json\/wp\/v2\/posts\/1329\/revisions"}],"predecessor-version":[{"id":1441,"href":"https:\/\/blogs.library.duke.edu\/data\/wp-json\/wp\/v2\/posts\/1329\/revisions\/1441"}],"wp:attachment":[{"href":"https:\/\/blogs.library.duke.edu\/data\/wp-json\/wp\/v2\/media?parent=1329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.library.duke.edu\/data\/wp-json\/wp\/v2\/categories?post=1329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.library.duke.edu\/data\/wp-json\/wp\/v2\/tags?post=1329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}