eSpatial LogoeSpatial logoMenu

Create your pin map

  • Turn your Excel data into a pin map.
  • Use different icons for different items.
  • Choose colors and a base map that suits you.
  • Publish/share to the rest of your company.
  • All in a free trial with no credit card required.

What is a pin map?

A pin map is the simplest way to express data on a map. It plots a pin wherever there is a geographic location contained in your data: zip code, street, state, country, etc. Just upload an Excel spreadsheet with a column containing locations and – depending on the size of the data – it will be plotted on a pin map in seconds. You can then start to interact with your data or, alternatively, use the suite of features to analyze or enrich it.

Pin huge amounts of data

A pin map allows you to plot huge amounts of data to a single map. From there you can summarize and group pins – “cluster” them – according to geographic region. For instance, if you have 10 locations pinned in one city, then this will be summarized on the map by a number – the number “10”. This is a useful shorthand feature when you are dealing with massive amounts of data spread throughout a region.

Compare and contrast layers of data

You can create complex visualizations that reveal the different levels of data that impact your business. For instance, if you were a distribution company, you could create a 3-layer pin map revealing the location of customers, sales personnel, and warehouses. Each would be expressed using a different color. Layers can be switched on or off, as required.

Pack your pins with rich spreadsheet data & links

Each pin on your map contains the data contained in each row of your spreadsheet. This allows you to find information geographically, which is faster and more intuitive than simply reading a spreadsheet. You can also link to web pages or CRM pages, including that information in your original upload.

Filter your pin map

Pin maps are great, but sometimes it can be more interesting to see a smaller amount of data. By using a filter you can instantly change the map to show you only a particular group of your pins. This might be all the ones you have visited in the past year or all the ones who have paid you in the last 6 months. You decide the detail, the filtered pin map helps you to visualize the reality.

Choose different styles of pin or make your own

Why settle for basic pins? Use different icons to express different data on a pin map. You can also express volumes per pin by the actual size of the pin on the map – large for large volumes, small for small volumes. You can also have your logo – or another relevant graphic – attached to map pins.

Publish and share your pin map

Like most things in life, pin maps are better when they are shared. Thankfully sharing is easy. You can publish or embed a live version of your pin map. That means that not only can you update the uploaded data, but the user can also zoom in or out and move around the map to their heart’s content. Alternatively, you can export it as a flat image for printing or incorporating in something like a spreadsheet.

Create your pin map by following these 3 simple steps

1: Prepare Your Data

Save your data to a CSV file from Excel. Make sure that your columns have header rows including your location information. Include as a column any info you want to see on the map.

Prepare data for pin maps

2: Sign up for an eSpatial trial account

Register for a free trial by clicking the button below, the screen shown to the right will ask you for a business email address and password, but no credit card information. This will begin your free trial where you can create your map right away.

3: Upload your data

Log into eSpatial and follow the add data process. It’s as simple as clicking Upload new data and following the instructions. If you have any difficulties, you can get help from real mapping experts on our live chat system. Just click on the bottom right corner of the page.

Your pin map is ready!

eSpatial Pin Map

As soon as your data is uploaded, it will be plotted on a pin map as seen in the example above. Each pin on the map represents a row in your spreadsheet and all this data is contained within the information box which appears when a pin is clicked. This forms the basis for your data analysis. You can style your map, run various analysis and share your map from this point.

Watch this video to see a pin map being created

My pin map is created, what can I do next?

Pin maps are great, but they are really only the beginning. From there why not consider taking the basis of your pin maps and making your map more valuable for your business:

  • Regional heat map – Turn your pin map into a regional heat map to see what states or areas have the highest density of pins, or have the greatest value in some other way. Learn more about regional heat maps.
  • Hotspot heat map – Why not use a hot spot to understand the density of pins? This can help you get a feel for where things are really happening for your business. Learn more about hot spot heat maps.
  • Territory map – Your pin map shows you what’s happening across the nation. But what if you also want to break out who is responsible for the different areas? This is where territory maps come in handy. Learn more about territory maps.
  • Route map – Want to plan a route between your various pins? Route mapping can help you to optimize your travel by distance or time. This is often used by sales and services teams to make sure they aren’t wasting time. It can also be used alongside a filter to make sure they’re spending time with the right customers to maximize profit. Learn more about route maps.

Are you ready plot your business data on a pin map? Sign up for a free eSpatial trial with seven day’s access to our Pro License features to visualize and analyze your data on your very own pin map.

Sign up for a free seven-day trial

You appear to be offline at the moment, this notice will disappear once your device can connect to the internet again  

We use cookies to personalise content and analyse our website's traffic. This includes cookies from third party social media, advertising, and analytics partners. If you continue without changing your settings, we'll assume that you are happy to receive all cookies from the eSpatial website. However, you can change your cookie settings at any time.

Accept CookiesAccept website cookiesCookie SettingsCookie Settings