PinPop is coming soon to Microsoft Marketplace. Once it is listed, you add it from inside Excel in a minute, or ask your IT team to deploy it. Nothing is installed on your computer outside Excel: no installer and no macros. The PinPop page shows when the listing is live.
What you need #
- Excel on Windows with Microsoft 365, Excel 2021 or Excel 2024, Excel on Mac, or Excel on the web in a current browser. Excel 2019 and older cannot run PinPop.
- Your own Google Maps Platform API key with the Maps JavaScript API, the Geocoding API and the Maps Static API enabled. See Get a Google Maps API key.
- An internet connection. The add-in’s code is served from addins.pythonandvba.com, Microsoft’s Office script from appsforoffice.microsoft.com, and the map and the address lookups come from Google (maps.googleapis.com). The license check and Download PNG on Windows and Mac also reach api.pythonandvba.com; see Where is my data?
- No macros, no admin rights on your computer and no account with me.
Install it yourself once PinPop is listed #
These are the steps that will apply once PinPop is listed on Microsoft Marketplace:
- Open Excel and a workbook.
- On the Home tab, click Add-ins, then More Add-ins (on some versions: Insert > Get Add-ins).
- Search for PinPop (by Bosau Digital) and click Add.
- PinPop inserts a map frame on the current sheet. From then on it is in the Add-ins menu: click it there to insert another map.
You add it once per Microsoft account. It then shows up in Excel on Windows, Mac and the web wherever you sign in with that account.
Personal Microsoft account? Once PinPop is listed, install from inside Excel as shown above. The Get it now button on the Microsoft Marketplace website asks for a work or school account and stops personal accounts (Outlook.com, Hotmail and similar) at Switch to an account that has permission. The Add-ins menu in Excel works with every Microsoft account, including the free Excel on the web at office.com.
Deployed by your IT admin #
Many companies deploy add-ins centrally from the Microsoft 365 admin center. Once PinPop is listed and your admin deploys it, it appears in the Add-ins menu under your organization’s add-ins without you doing anything; it can take up to 24 hours after the deployment. If your organization blocks add-ins from the store, ask your IT team to deploy PinPop for you. A company firewall must let Excel reach maps.googleapis.com for the map.
Colleagues who open the file #
The map lives in the workbook. When a colleague opens the file, Excel loads PinPop in the map frame; the first time, Excel may ask them to trust or add the add-in. To see the live map they need their own Google Maps key; without one they see the last saved picture of the map. See Share a workbook with a map.
Updates #
There is nothing to update. PinPop loads its current version each time a map opens, so you always have the latest release. The changelog lists what changed.
Remove a map or PinPop #
To remove one map, click the edge of its frame and press Delete, like any object on the sheet. The table and the coordinates PinPop wrote into it stay.
To remove PinPop from Excel, open Home > Add-ins > More Add-ins > My Add-ins, open the menu of PinPop (the three dots) and choose Remove. If you have a license, remove the key from the device first (More options > License > Remove license key from this device) so the device slot is free again.
