Menu

Your address list on a live map, right in Excel

Plot customers, stores or jobs as pins, colour them by any column and keep the map in sync with your sheet. No upload, no monthly fee. Windows, Mac and the web.

  • Finds your address columns and looks up the coordinates once, with your own Google Maps key
  • Follows your sheet: edits, new rows and filters show on the map
  • Click a pin to see the row and select it in the sheet
See pricing

Coming soon to Microsoft Marketplace

Excel on Windows, Mac and the web.

From a list of addresses to pins on a map

Click a cell in your table and choose Insert map. PinPop finds the address columns, looks up the coordinates and puts every row on a live map that sits on the sheet like a chart.

A customer list in Excel with Name, Address, City, State and Region, and the Latitude, Longitude and Match columns PinPop wrote, marked 1. Next to it on the sheet, a live map with the pins coloured by region and a legend, marked 2. An open popup with the row's details and the Select row button, marked 3.
  1. Your list, as it isOne address column, or street, city, postcode and country in separate columns, or latitude and longitude. The coordinates PinPop looks up go into Latitude, Longitude and Match columns, so you can check every row.
  2. Colour by any columnPick a column such as Region, Status or Sales rep, and every pin takes its colour, with a legend. Clusters keep large lists readable.
  3. Click a pin, find the rowThe popup shows the columns you choose. Select row jumps to that row in the sheet, even after you sort.

Why map your list inside Excel

Web map tools want your list pasted or uploaded, and the map is out of date the moment the sheet changes. PinPop keeps the map in the workbook, next to the data it shows.

A web map tool

Copy, paste, repeat

  • Paste or upload the list into a website, and again after every change.
  • Your customer list sits on someone else's servers.
  • The map lives elsewhere, as a link or a picture, apart from the rows it came from.
  • A monthly plan for anything beyond a small list.

PinPop

A live map on your sheet

  • No copy and paste: click a cell in your table and the map is there.
  • Your data stays in your workbook. Addresses go only to Google, with your own key, to find the coordinates.
  • The map updates when the sheet does: edits, new rows, sorting and filters.
  • One payment instead of a monthly plan, and a free version for up to 250 pins.

How it works

Add your Google Maps key once. After that, a map is three steps away.

Click a cell

Click any cell in a table of customers, stores, jobs or properties. A header row is all PinPop needs.

Insert map

PinPop finds the address or coordinate columns, looks up what is missing and shows every row as a pin.

Colour by a column

Choose Colour by, pick the popup columns, and the map is ready to share, print or put in a slide.

Everything a list map needs, and nothing it does not

Defaults that look good with zero settings. The rest sits in the map's toolbar, with Pro features marked Pro.

See the list

Free
  • PinsFreeOne pin per row, coloured by any column, with a legend
  • PopupsFreeThe columns you choose, the address and how well it matched
  • ClustersFreeLarge lists stay readable; a click zooms in
  • Base mapsFreeRoad, light, dark, satellite and satellite with labels

Export and print

Free and Pro
  • Download PNGFreeA picture of the map for slides; Free adds a small Made with PinPop badge, Pro is clean
  • Place picture in sheetProA picture of the map next to your table, for printing and sharing

Stay in sync

Free
  • Follows filtersFreeFilter the table and the hidden rows leave the map
  • Follows editsFreeNew and changed addresses are looked up once, in one batch
  • Click to selectFreeSelect row in a popup selects that row in the sheet

Bigger lists, more insight

Pro
  • Heat mapProWhere your rows are densest, optionally weighted by a number column
  • Radius circlesProOne radius around every pin, in miles or kilometres
  • Up to 50,000 pinsProPer map, with as many maps per workbook as you like

The free version maps up to 250 pins, with one map per workbook.

Uses your own Google Maps key

Most people stay inside Google's free monthly allowance. Setting up the key is a one-time step of a few minutes, and the guide walks you through it.

  1. Create a key in Google CloudGoogle asks for a billing account with a card before the key works. Use beyond the free monthly allowance is billed by Google to your project, never by us.
  2. Turn on three APIsMaps JavaScript API for the map, Geocoding API for the coordinates and Maps Static API for pictures. A key you already use for our other Google Maps add-ins works once these are on.
  3. Paste it into PinPopSave and test checks each API and names any that is missing. The key stays in this device's browser storage for the add-in, never in the workbook.

Coordinates are looked up once and written into your table, so an unchanged row is never looked up again. How to get a Google Maps key

Coming to Microsoft Marketplace

PinPop installs from Microsoft's add-in store, inside Excel. It is on its way and not listed yet.

Once it is listed, this is the whole install:

  1. 1In Excel, go to Home → Add-ins → More Add-ins.
  2. 2On the Store tab, search for PinPop by Bosau Digital.
  3. 3Click Add. A map frame appears on the sheet: paste your Google Maps key, then insert a map from your table or start with a sample.
Coming soon to Microsoft Marketplace

Depending on your Excel version, look under Insert → Get Add-ins instead.

  • Windows, Mac and the web
  • No installer, no macros
  • Your table stays in your workbook
  • Your own Google Maps key

Pay once. No subscription.

Map up to 250 pins for free, one map per workbook. Pro removes the limits and adds heat maps, radius circles and clean exports.

Free
$0
Inside the add-in · no account
  • A live map that follows your sheet
  • Colour by a column, popups, clusters and the legend
  • Road, light, dark and satellite maps
  • Up to 250 pins, one map per workbook
Get it free
Personal
$69
One-time payment · one person
  • Lifetime license for 3 devices
  • Every Pro feature
  • Every future update included
  • 14-day money-back guarantee
Team
$199
One-time payment · your team
  • Lifetime license for 15 devices
  • Every Pro feature
  • Every future update included
  • 14-day money-back guarantee

Pro adds up to 50,000 pins per map, unlimited maps per workbook, heat maps, radius circles, a clean PNG without the badge and Place picture in sheet. Map and lookup use runs on your own Google Maps key, billed by Google, not part of the license.

Frequently asked questions

Yes. PinPop needs your own Google Maps Platform key, for which Google requires a Cloud billing account with a card; most use stays inside Google's free monthly allowance. Google bills the map and the address lookups to your Google Cloud project, not to us. Coordinates are looked up once and written into your table, so an unchanged row is never looked up again. The key needs the Maps JavaScript API, the Geocoding API and the Maps Static API; the key guide shows each step.
A table or a block of cells with a header row. PinPop reads one address column, or street, city, postcode and country in separate columns, or existing latitude and longitude columns, and finds them from the headers in English, German, French, Dutch and Spanish. When it is not sure, it asks you to match the columns once. Coordinates it looks up go into Latitude, Longitude and Match columns, and coordinates you typed yourself are never overwritten.
Yes. Edit a cell, add rows, sort or filter and the map follows. New or changed addresses are looked up in one batch, rows hidden by a filter leave the map, and Select row in a popup selects that row in the sheet, even after sorting.
Yes. PinPop runs in Excel for Windows (Microsoft 365, Excel 2021 and Excel 2024), Excel for Mac and Excel on the web. It will install from Microsoft Marketplace, where it is coming soon, or through your admin. There is no separate installer to download. A few older Excel 2021 installs on Windows still use an old browser engine that cannot draw the pins; PinPop says so, and Microsoft 365 or Excel on the web works instead.
Yes. The map is part of the workbook. A colleague who opens it sees the live map with their own Google Maps key, and needs no license to view a map made with Pro. Without a key, PinPop shows the last picture of the map saved in the workbook. For printing or a slide, Download PNG or Place picture in sheet (Pro) gives you a picture anyone can see.
Your table is read inside Excel on your device and stays in your workbook. The only data that leaves it are the addresses PinPop sends to Google, with your own key, to look up coordinates, which are written back into your table. Your Google key stays in this device's browser storage for the add-in, never in the workbook. PinPop also saves a small picture of the map in the workbook for people without a key. On your device, it keeps the coordinates it already looked up and pictures of your recent maps for up to 30 days, so nothing is looked up twice and a map appears right away; clearing the add-in's site data removes them, removing your Google key does not. The one other exception is Download PNG on Windows and Mac: it stores an encrypted copy of the picture on our server for up to 10 minutes and deletes it when your browser reads it, and only your browser holds the key. The details are in the privacy policy.
The free version shows up to 250 pins on one map per workbook and looks up coordinates only for those rows. Pro shows up to 50,000 pins per map, with as many maps per workbook as you like. Above 500 pins in view, clusters switch on so the map stays readable.
A live map of up to 250 pins with no account, no watermark on the map and no time limit: address lookup with your Google key, colour by a column, popups, clusters, the legend, road, light, dark and satellite maps, follow filters, click to select, and Download PNG with a small Made with PinPop badge. The limit is one map per workbook.
Up to 50,000 pins per map, unlimited maps per workbook, heat maps, radius circles, a clean PNG without the badge and Place picture in sheet for printing and slides. Pro features are visible in the free version, marked Pro. If Pro is not for you, email me within 14 days and you get your money back.
It is a one-time license with no subscription. Personal covers one person on up to 3 devices, and Team covers up to 15 devices. Both unlock every Pro feature and include future updates. You enter the key from your purchase email under More options > License on the map, and you manage your devices in your account. If it is not for you, email me at contact@pythonandvba.com within 14 days and you get your money back. The full policy is at pythonandvba.com/refund-policy.
Sven Bosau

Still have a question?

I’m Sven, the developer, and I usually reply within a day.

Please enter your first name.

Please enter a valid email address.

Please write a little more (at least 10 characters).

Your email is only used to reply. No newsletter. How I handle your message: Privacy Policy.

Your list, on a live map.

PinPop is on its way to Microsoft Marketplace. The free version will map up to 250 pins with your own Google Maps key, with no account.

Get it free

PinPop is made by Bosau Digital LLC and is not affiliated with or endorsed by Google or Microsoft. Google Maps is a trademark of Google LLC. Microsoft and Excel are trademarks of the Microsoft group of companies.