How to Place a Pin on Google Maps & Save

Emojis have become essential for communication in our daily lives. While the most popular emojis help express tone or feeling, the round pushpin indicates something just as important: a location where you’ve been or where you want to go. It also happens to be the unofficial icon of one of the most popular web mapping services, Google Maps.

While most people are familiar with obtaining directions from the mega-mapping platform, users often have questions about how to drop a pin and save it. Attempts to drop a pin in Google Maps may result in a search for nearby places—without the option to save or even label it. But there’s another mapping platform where mapping and saving pins is more intuitive—and it utilizes the Google Maps API for its geocoding process.

Create a Spreadsheet of Locations to Pin

Of course, if you’re looking to place a pin on Google Maps, you must first have a location (or two!) in mind. You can take your desired locations, in the form of a spreadsheet, and easily map and display them on a custom Google Map with the help of BatchGeo. BatchGeo performs everything you need to put a pin or pins on Google Maps in just a few easy steps, as noted below.

  • Add the location of your desired pin(s) to a spreadsheet. Excel, Google Sheets, or any other spreadsheet tool will suffice, as long as you’re able to copy and paste.
  • Dedicate at least one column of your spreadsheet to the location information of your desired pin(s). Any of the following location data will work:
    • Addresses
    • City names
    • State names
    • Postal codes
    • Country names
    • Latitude and longitude coordinates

You can even map landmarks and business names. In fact, most of what you search for in Google Maps can be used in BatchGeo. Now let’s map your locations, whether the Eiffel tower landmark or your sister’s new address in Spain.

Map One or More of Your Pins

Once you have your spreadsheet with your location data, you’re ready to create a pinned map just like the one below.

View Single pin map in a full screen map

To do so:

  1. Open your spreadsheet
  2. Select (Ctrl+A or Cmd+A) and copy (Ctrl+C or Cmd+C) your data
  3. Navigate to batchgeo.com in your preferred web browser
  4. Click on the location data box with the example data in it, then paste (Ctrl+V or Cmd+V) your own data. Select “Map Now”
  5. Check to make sure you have the proper location data columns available by clicking “Validate & Set Options”
  6. Select the proper location column from each drop-down
  7. Click “Make Map” and watch as the geocoder performs its process

You can add multiple pins to the same map by adding additional locations to your spreadsheet. With this added data, you may also find it helpful to include more columns of information. One common example is a type column, a way to assign categories to your data. But you could also include separate columns for length, height, etc., depending on your information. After adding additional columns, follow the same steps noted above.

View Multi-pin map in a full screen map

Having multiple locations unlocks the ability to group and filter your map by any additional columns from your spreadsheet. And after you’ve created your map, there are just two things left to do. The first is to save your pins. Then, ultimately, you may wish to share your map.

Save & Share Your Pins on Google Maps

With your pins mapped, you’ll want to ensure you click Save. Once that’s done, you’ll be able to access your map on any device by visiting its custom URL. But your eyes don’t have to be the only ones that get to see your saved map. You may wish to share your pins of locations where you’ve been or where you want to go with friends, family, or followers.

You can share your maps on social media a handful of ways, the easiest being via URL. Copy the URL from your web browser (which always starts with batchgeo.com/map/). Paste the link into a text to your mom, an email to a buddy, or even a tweet to all your followers. And it’s just as simple to embed your maps into your website’s homepage or blog post with batchgeo.com.

US National Emergencies Mapped

The novel coronavirus has plagued the world and the United States throughout 2020 and beyond. With a death count surpassing even the highest of early estimates, COVID-19 is incomparable to previous diseases. Even the most recent pandemic, 2009’s H1N1 (also known as “Swine Flu”), resulted in much fewer deaths.

But these diseases do have something in common: they each resulted in the declaration of a national emergency by the President of the United States. When this is proclaimed, the government can perform actions not normally allowed. Throughout American history, presidents have declared 69 of these emergency orders. Of these, 34 have since expired while another 35 are currently in effect, each having been renewed annually by the president.

To gain a better understanding of these emergencies, we’ll cover their eight categories, those that are current, and the presidents who declared the most. You can also view this information, and the location of each, on the map below.

View National emergencies in the United States in a full screen map

Each marker on the map comes from Wikipedia’s List of national emergencies in the U.S.. Each of these emergencies has been categorized, which you can read more about below.

National Emergency Categories

Most (46) of the U.S.’s national emergencies can be classified as sanctions (punishments one country puts on another country hoping for a change in behavior). Other common reasons for emergencies include:

  • Trade (8)
  • Military (5)
  • Arms (3)
  • Public health (2)
  • Maritime (2)
  • Economic (2)
  • Legal (1)

Only one of the eight trade emergencies has remained intact: the Continuation of Export Control Regulations. As for military emergency orders, two of the five are ongoing: one from the 9/11 terrorist attacks and the 2019 Declaring a National Emergency Concerning the Southern Border of the United States. You can group the map by the rest of the national emergencies to learn more. Otherwise, let’s take a closer look at how many emergency orders remain to this day.

The 35 Current National Emergencies

“Current” national emergencies include those that were created in the same year or emergency orders from previous years the current president renewed. As of early November 2020, 34 national emergencies have ended while 35 are current. Below you’ll find the current emergency declarations, starting with the most recent.

Emergency name Date Year Category President Country
Declaring a National Emergency Concerning the Novel Coronavirus Disease COVID-19 Outbreak March 13 2020 Public health Trump US
Blocking Property of Certain Persons Associated with the International Criminal Court June 11 2020 Sanctions Trump Afghanistan
Securing the Information and Communications Technology and Services Supply Chain May 15 2019 Sanctions Trump China
Declaring a National Emergency Concerning the Southern Border of the United States February 15 2019 Military Trump Mexico
Imposing Certain Sanctions in the Event of Foreign Interference in a United States Election September 12 2018 Sanctions Trump Russia
Blocking Property of Certain Persons Contributing to the Situation in Nicaragua November 27 2018 Sanctions Trump Nicaragua
Blocking the Property of Persons Involved in Serious Human Rights Abuse or Corruption December 20 2017 Sanctions Trump Myanmar
Blocking Property of Certain Persons Contributing to the Situation in Burundi November 22 2015 Sanctions Obama Burundi
Blocking Property and Suspending Entry of Certain Persons Contributing to the Situation in Venezuela March 8 2015 Sanctions Obama Venezuela
Blocking the Property of Certain Persons Engaging in Significant Malicious Cyber-Enabled Activities April 1 2015 Sanctions Obama North Korea
Blocking Property of Certain Persons Contributing to the Conflict in the Central African Republic May 12 2014 Sanctions Obama Central African Republic
Blocking Property of Certain Persons Contributing to the Situation in Ukraine March 6 2014 Sanctions Obama Ukraine
Blocking Property of Certain Persons With Respect to South Sudan April 3 2014 Sanctions Obama South Sudan
Blocking Property of Persons Threatening the Peace, Security, or Stability of Yemen May 16 2012 Sanctions Obama Yemen
Blocking Property of Transnational Criminal Organizations July 24 2011 Sanctions Obama Mexico
Blocking Property and Prohibiting Certain Transactions Related to Libya February 25 2011 Sanctions Obama Libya
Blocking Property of Certain Persons Contributing to the Conflict in Somalia April 12 2010 Sanctions Obama Somalia
Continuing Certain Restrictions With Respect to North Korea and North Korean Nationals June 26 2008 Sanctions Bush North Korea
Blocking Property of Persons Undermining the Sovereignty of Lebanon or Its Democratic Processes and Institutions August 1 2007 Sanctions Bush Lebanon
Blocking Property of Certain Persons Contributing to the Conflict in the Democratic Republic of the Congo October 27 2006 Sanctions Bush Democratic Republic of the Congo
Blocking Property of Certain Persons Undermining Democratic Processes or Institutions in Belarus June 16 2006 Sanctions Bush Belarus
Blocking Property of Certain Persons and Prohibiting the Export of Certain Goods to Syria May 11 2004 Sanctions Bush Syria
Protecting the Development Fund for Iraq and Certain Other Property in Which Iraq Has an Interest May 22 2003 Legal Bush Iraq
Blocking Property of Persons Undermining Democratic Processes or Institutions in Zimbabwe March 6 2003 Sanctions Bush Zimbabwe
Blocking Property and Prohibiting Transactions With Persons Who Commit, Threaten To Commit, or Support Terrorism September 23 2001 Sanctions Bush Afghanistan
Declaration of National Emergency by Reason of Certain Terrorist Attacks September 14 2001 Military Bush Afghanistan
Blocking Property of Persons Who Threaten International Stabilization Efforts in the Western Balkans June 26 2001 Sanctions Bush North Macedonia
Continuation of Export Control Regulations August 17 2001 Trade Bush US
Blocking Sudanese Government Property and Prohibiting Transactions With Sudan November 3 1997 Sanctions Clinton Sudan
Declaration of a National Emergency and Invocation of Emergency Authority Relating to the Regulation of the Anchorage and Movement of Vessels March 1 1996 Maritime Clinton Cuba
Blocking Assets and Prohibiting Transactions with Significant Narcotics Traffickers October 21 1995 Sanctions Clinton Colombia
Prohibiting Certain Transactions with Respect to the Development of Iranian Petroleum Resources March 15 1995 Sanctions Clinton Iran
Prohibiting Transactions With Terrorists Who Threaten To Disrupt the Middle East Peace Process January 23 1995 Sanctions Clinton Palestine
Proliferation of Weapons of Mass Destruction November 14 1994 Arms Clinton US
Blocking Iranian Government Property November 14 1979 Sanctions Carter Iran

Of the 35 current national emergencies, seven were enacted by the recent Trump administration. That leaves 28 emergency orders in effect from past administrations the current president has continuously renewed. The oldest of these is the: Blocking Iranian Government Property (Executive Order 12170) from Jimmy Carter, who ordered the freezing of Iranian assets as part of the U.S. response during the Iran hostage crisis on November 14th, 1979.

The most recent national emergency is, of course, Declaring a National Emergency Concerning the Novel Coronavirus Disease COVID-19 Outbreak (Proclamation 9994) proclaimed by Donald Trump on March 13, 2020. Let’s see how the numbers of national emergencies of the recent president compare to his predecessors.

Presidents Who Declared the Most Emergency Orders

While ‘most national emergencies’ isn’t a typical goal of a new POTUS, there’s no denying some U.S. presidents declared more than others. And only one has proclaimed 15+ national emergencies throughout his terms. So which president was the host with the most? That honor goes to #42—Bill Clinton.

  • Clinton – 17 national emergencies
  • Bush – 13
  • Obama – 12
  • Trump – 7
  • Reagan – 6
  • Bush (H.W.) – 5

Of the 17 national emergencies Bill Clinton declared, 11 are no longer in effect. That leaves six that remain to this day. These can further be broken down into four of the national emergency categories: sanctions (11), trade (3), arms (2), and maritime (1) emergencies.

Aside from Clinton, both George W. Bush and Barack Obama declared more than ten national emergencies throughout their time in office. Two of Bush’s 13 proclamations followed the September 11 attacks. The first was the Declaration of National Emergency by Reason of Certain Terrorist Attacks on September 14 which was followed on September 23 by the Blocking Property and Prohibiting Transactions With Persons Who Commit, Threaten To Commit, or Support Terrorism. Both of these are still in effect, along with nine others.

Find More Meaning in Location Data

Each of the U.S.’s 69 Executive Orders or Proclamations were passed by the U.S. President to protect the country. Many were a result of issues inside the U.S. like Declaring a National Emergency Concerning the Novel Coronavirus Disease COVID-19 Outbreak (Proclamation 9994). However, some were in response to international incidents, i.e. Blocking Property of Persons Threatening the Peace, Security, or Stability of Yemen (Executive Order 13611).

As you saw on the map, Afghanistan and Russia were the subjects of the most emergency orders at four each while Iran was a hot topic of three. This is the sort of insight we may have missed had we just kept the data stored in Google Sheets or Excel.

When your spreadsheet contains geographic data like addresses, coordinates, or even just countries and the occasional city, how can you be expected to analyze the information? In these instances, free mapping tools like BatchGeo can help you find more meaning in your data with customizable maps.

The Path to Presidency: 2020 Election Results

As Joe Biden ascends the steps of the White House, many are looking back at his path to the United States presidency. How did he beat the incumbent to the highest office in the nation, something that hadn’t been done since Bill Clinton trumped George H. W. Bush in 1992? The electoral votes determined the race, Biden: 306, Trump: 232, but let’s take a look behind those votes in Biden’s road to 270+. Which states were nearly unanimous and how did third parties fare this election cycle? All are shown on the map below.

View 2020 Election in a full screen map

The data is from Wikipedia’s ‘Results by state’ section of the 2020 United States presidential election page. You’re able to sort the map by Ticket & Party, the number of votes, percentage, and electoral votes. Let’s see which states were closest to unanimous in this unprecedented election.

Nearly Unanimous States

The Biden/Harris duo won the 2020 election with 306 electoral votes and 51.31% of the vote. Meanwhile, the Trump/Pence team exits the oval office with 232 electoral votes and 46.86% of the vote. But we wondered which areas of the country leaned more unanimously towards one pair of candidates or the other (or perhaps a third-party?). Find out where in the U.S. below.

State or district Ticket & party %
Washington D.C. Biden/Harris Democratic 92.15%
Nebraska-3 Trump/Pence Republican 75.36%
Wyoming Trump/Pence Republican 69.94%
West Virginia Trump/Pence Republican 68.62%
Vermont Biden/Harris Democratic 66.09%
Massachusetts Biden/Harris Democratic 65.60%
Oklahoma Trump/Pence Republican 65.37%
Maryland Biden/Harris Democratic 65.36%
North Dakota Trump/Pence Republican 65.11%
Idaho Trump/Pence Republican 63.84%

Voters in the nation’s capital, Washington D.C., were 92.15% in favor of Joe Biden to be POTUS #46. This is up from 2016 in which 90.48% of D.C. voted blue. In fact, in all of the capital’s history as the only non-state to have electoral votes, theirs have never gone to the GOP. Both Maine and Nebraska split their electoral votes by congressional districts and Nebraska’s 3rd district had the second-highest percentage, in this case, 75.36% for Trump’s re-election.

The first state with a significant majority was Wyoming with 69.94% of voters casting ballots for Trump and Pence. West Virginia closely follows, along with Vermont, Massachusetts, Oklahoma, and Maryland for Biden. Meanwhile, North Dakotans and Idahoans showed up for Trump. Now let’s see how third parties did in 2020.

Third Parties With A Million Votes

A minor or third-party is one other than the two major parties, currently Democrat and Republican. In 2020, the largest third parties in the U.S. were the Libertarian Party, Green Party, and Constitution Party. So just how far did any third-party candidate make it in the 2020 election? No minor party took away electoral votes from either the Biden/Harris ticket or that of Trump/Pence (all 538 went to one or the other). However, a third-party ticket did score 1,865,720 votes.

Libertarian Party

The third-party ticket with 1,865,720 votes was Jo Jorgensen and Spike Cohen of the Libertarian Party. While that may seem like a lot, those million-plus votes make up just 1.18% of the total votes. Additionally, in comparison, Libertarian candidate Gary Johnson gained 4,489,221 votes in 2016 (3.28%).

Percentage-wise, Jorgensen and Cohen did best (over 2%) in the following 10 states: South Dakota (2.63%), North Dakota (2.60%), Utah (2.58%), Montana (2.53%), Alaska (2.47%), Nebraska’s 1st congressional district (2.33%), Kansas (2.23%), Nebraska (2.12%), Wyoming (2.08%), and Nebraska’s 2nd congressional district (2.03%). That leaves the other minor parties with thousands of votes in the 2020 presidential election.

The Green Party & Others

The other significant third-party player, Howie Hawkins and Angela Walker of the Green Party received 405,034 votes or 0.26% in total. In 2016, the Green Party’s Jill Stein had 1,457,216 or 1.07% total. The 2020 ticket did best in Maine’s 1st congressional district with 1.05% of the vote and the next best in Maine’s second district (0.95%).

Other parties, which amassed 627,567 votes (0.40%), included write-ins. To learn more about them, check out the map, or continue for how to make your own.

Publish Maps On Your Site

Maps are a useful tool to help you visualize your location data—addresses, cities, etc. You may even discover something you missed in your spreadsheet!

To make your own map, be it a historical look at 100 years ago in 1921 or political canvassing maps for door-to-door volunteers, just copy your spreadsheet data. Then, paste it into our simple mapping tool.

With your data newly displayed in your map, you can embed it in your website or share it with fellow map enthusiasts. Get started today with BatchGeo.