PinPop Privacy Policy
This Privacy Policy explains how the PinPop add-in for Microsoft Excel ("the Add-in"), published by Bosau Digital LLC ("we", "us", or "our"), which operates Python & VBA at pythonandvba.com, handles your data. It applies specifically to the Add-in. Our general website Privacy Policy, which also covers our website and its analytics, continues to apply to your use of our website.
1. In Short
- The Add-in reads your table on your own device, inside Microsoft Excel, and shows it on a map on the sheet. Your workbook is not uploaded to us.
- To find coordinates, the Add-in sends the addresses of the rows that have none directly to Google, using your own Google Maps API key. The coordinates are written into your workbook. We never receive your addresses.
- Your Google Maps API key stays in this device's browser storage for the Add-in. It is never stored in the workbook and never sent to us.
- A small picture of the map is saved in the workbook, so people who open it without a key still see the map.
- Download PNG outside Excel on the web (for example in Excel for Windows and Mac) encrypts the picture on your device, and our server (api.pythonandvba.com) stores only that encrypted copy for at most 10 minutes and deletes it the first time your browser reads it. Only your browser can decrypt it.
- The license check sends your license key, a random installation identifier, the Add-in version and a platform label. The Add-in and its export page contain no advertising, no cookies, no telemetry, and no third-party analytics or tracking.
2. Who We Are
The Add-in is published and operated by Bosau Digital LLC, the company behind Python & VBA (pythonandvba.com), founded by Sven Bosau. For any privacy-related questions, please contact us at contact@pythonandvba.com.
3. What Data the Add-in Processes
Your Spreadsheet Data
The Add-in reads the table you link it to (the address or coordinate columns and the columns you show on the map) locally, inside Excel, on your device, and draws the pins on your device. Your workbook is never uploaded to us. What can leave your device is described below: addresses sent to Google with your own key, and the encrypted picture when you use Download PNG outside Excel on the web.
The Add-in writes to your workbook only for the map you insert:
- Coordinates. For rows without coordinates, it adds Latitude, Longitude and Match columns to your table (or uses existing columns of those names) and writes the coordinates and how well each address matched. Coordinates you typed yourself are never overwritten.
- The map's setup and picture. The workbook's own settings hold the map's setup (the linked table, the matched columns and the style), a small picture of the map (at most 250 KB) for people who open the workbook without a key, and, while a lookup is running, its progress so it can continue if Excel reloads the map. These travel with the workbook, like any other content.
- Place picture in sheet (Pro) adds a picture of the map to the sheet, next to your table.
- Start with a sample adds a table with made-up names and addresses.
Google Maps Platform (With Your Own Key)
PinPop uses Google Maps Platform with your own Google Maps API key. All of these requests go from your device directly to Google, never through our servers:
- The map loads from Google (Maps JavaScript API), with map tiles for the area you look at.
- Coordinates. For each row without coordinates, the address from your table (the address column, or the street, city, postcode and country columns joined) is sent to Google's geocoding service, which returns the coordinates. Each address is looked up once; the result (a fingerprint of the address, its coordinates and the match quality) is kept in a cache on your device for up to 30 days, so an Undo or a re-added row is not looked up again.
- Pictures of the map (the saved picture, Download PNG and Place picture in sheet) use one map image from Google's Maps Static API per picture. That request contains only the map's center, zoom, map type and style, never your rows. The pins are drawn onto the picture on your device.
Google handles that data under its own terms and your relationship with Google; see the Google Privacy Policy. We do not receive, store, or have any access to your addresses or the coordinates Google returns.
The Encrypted Picture (Download PNG, Outside Excel on the Web)
Desktop Excel cannot save a file from inside the map frame, so the Add-in opens an export page in your browser, which offers the download there. To hand the picture over, it works like this:
- The Add-in puts the PNG picture of the map and its file name together on your device.
- It encrypts them on your device with a fresh AES-GCM 256-bit key and a random initialization vector (IV), using the Web Crypto API of your computer.
- It sends only the encrypted file (with its random initialization vector) to api.pythonandvba.com. The key and the picture in readable form are not sent.
- Our server stores the encrypted file for at most 10 minutes and deletes it the first time it is fetched.
- The Add-in opens the export page in your browser with a link whose fragment (the part after the # sign) carries the file's reference and the key. Browsers never send the fragment to a server, so the key never reaches us and only your browser can decrypt the picture.
- Apart from its own code from addins.pythonandvba.com, the export page makes one request, to fetch the encrypted file. It decrypts the picture in your browser, and it loads no analytics and no third-party content.
Our server never logs the content of these files. In Excel on the web, the picture downloads directly in your browser: nothing is uploaded, and no file is created on our server. Place picture in sheet uploads nothing either.
License Validation Data
To confirm that you hold a valid license, the Add-in sends the following to our license server (api.pythonandvba.com) over an encrypted connection. It never sends any workbook content:
- Your license key;
- A random installation identifier generated on your device. It contains no name, email, or hardware information, but it is tied to your license, so it is not anonymous. It is used only to enforce the per-installation activation limit of your license;
- The Add-in version;
- A short platform label, such as "Excel for Windows" or "Excel on the web · Chrome", so the device list in your account is readable. It never contains a user name, a computer name or the full browser identification.
The check runs when the map opens and a license key is stored on the device, and when you add a key. When you remove a key, the Add-in sends the key and the installation identifier once more, so the device's slot is freed. If you never enter a license key, these requests are never made. A record of your last successful check is stored on your device so licensed features keep working for a short offline grace period (currently 7 days) if the license server cannot be reached, and then re-verifies once you are back online. Someone who only views a map made with a Pro license needs no license key.
Like any web server, our server also receives your IP address with each request, for the license check and for the encrypted picture. It appears in our server logs, which are deleted after 14 days (90 days for warnings and errors). The installation identifiers registered to your license are kept with your license record (when each was first seen and last used) for as long as the license exists. If a check fails, we keep the license key, IP address, approximate country, installation identifier and Add-in version for up to 90 days to detect misuse of keys.
Loading the Add-in
Like every Office add-in, the Add-in loads its program code when the map frame starts: the PinPop code from our server addins.pythonandvba.com, and Microsoft's standard add-in library (office.js) from Microsoft. These are ordinary web requests for code. They carry no workbook content, and we do not use them to track you. Because the code and the map load from the web, the Add-in needs an internet connection.
Data Stored Locally on Your Device
The following are saved only on your device, in the browser's local storage of the Add-in (under keys that start with pp.): your Google Maps API key, the cache of coordinates already looked up (up to 30 days), your license key, the random installation identifier, the record of your last successful license check, pictures of up to 4 recent maps, with their pins, kept for up to 30 days so a map appears instantly, and your settings, such as your answer to the export notice. Your Google key is kept per device and per Excel, and it is never written into the workbook or into a link. You can remove your Google key and your license key in the Add-in at any time (Remove key from this device). Removing a key does not clear the coordinates cache or the map pictures: they expire after 30 days, or you delete them earlier by clearing the browser's site data for the Add-in (in Excel on the web, the site data of addins.pythonandvba.com in your browser; in Excel for Windows and Mac, the Office add-in cache).
Purchases
Licenses are bought on our own checkout at buy.pythonandvba.com (payments by Stripe or PayPal). Your license key is sent to you by email. We receive your name, email address, billing country, and order details from the checkout, and a VAT ID if you enter one. We never see your full card details. This is covered in more detail by our general website Privacy Policy.
Data Handled by Microsoft Excel
The Add-in runs inside Microsoft Excel on Windows, Mac and the web. Microsoft's handling of your Office documents and account data is governed by Microsoft's own privacy terms. See the Microsoft Privacy Statement.
4. Third-Party Services
- Microsoft Excel / Microsoft 365: the host application in which the Add-in runs, and the source of office.js.
- Google Maps Platform: the map, the coordinates for your addresses and the map images, through your own API key, as described in Section 3. Your use of Google's services is governed by the Google Privacy Policy and the Google Maps Platform Terms of Service.
- Our server (api.pythonandvba.com, operated by us): checks license keys and holds the encrypted picture for up to 10 minutes, as described in Section 3.
- Stripe and PayPal: payment processing when you buy a license.
No other third parties receive any data through the Add-in. We do not sell your personal data.
5. What the Add-in Does Not Do
- It does not include advertising, cookies, telemetry, or third-party analytics or tracking, in the map frame or on the export page.
- It does not upload your workbook, and it does not send your addresses or rows to us. Addresses go only to Google, with your own key. It does not send them to an AI service.
- It does not send your Google Maps API key to us, and it never puts it into the workbook or into a link.
- It does not send automatic error reports. Error messages are shown in the Add-in only; if you contact support, you can choose to copy the diagnostic details from the Add-in and include them yourself. Those details never contain cell contents, addresses or keys.
- It does not change cells you did not ask it to change, and it never overwrites coordinates you typed yourself.
- It does not access your location, hardware identifiers, your contacts, Microsoft Graph, SharePoint, OneDrive, or files other than the workbook you have open.
6. How We Use Data
- To validate and manage your license and enforce its device limit.
- To show your devices in your account, so you can free a device yourself.
- To let licensed features keep working during a short offline grace period after a successful license check.
- To pass the encrypted picture from the Add-in to your browser, outside Excel on the web (for example on Excel for Windows and Mac).
- To deliver your license key and handle purchases and support requests.
That is the complete list. We cannot read the encrypted picture, and we do not use it for anything else.
7. Legal Basis for Processing (GDPR)
If you are located in the European Economic Area (EEA) or the United Kingdom, we process the limited license, export and purchase data described above under the following legal bases:
- Contract performance: Verifying your license, handing your picture to your browser and delivering your purchase so we can provide the features.
- Legitimate interests: Enforcing license limits and preventing misuse of our software.
- Legal obligation: Keeping purchase records as tax and accounting law requires.
The addresses you send to Google with your own key are processed by Google under your own account and Google's terms; we are not involved in that processing.
8. International Data Transfers
Bosau Digital LLC and our server are located in the United States or process data there. If you use the Add-in from outside the United States, the license validation data and, when you use Download PNG outside Excel on the web (for example on Excel for Windows and Mac), the encrypted picture described above are transferred to the United States. The picture is encrypted on your device and we cannot read it. Your workbook is never transferred to us. Where personal data of EEA or UK residents is transferred internationally, we and our service providers rely on appropriate safeguards such as the EU-U.S. Data Privacy Framework and/or Standard Contractual Clauses.
9. Data Retention
- Encrypted pictures: At most 10 minutes, and deleted the first time they are fetched.
- License records: Retained for as long as necessary to support your license and comply with legal obligations.
- Server logs: Deleted after 14 days (90 days for warnings and errors). They never contain the content of the encrypted pictures.
- Failed license checks: Deleted after 90 days.
- Locally stored keys, cache and settings: Remain on your device until you remove them or clear the browser's site data for the Add-in; looked-up coordinates and the pictures of recent maps expire after 30 days.
- Worksheet contents and addresses: Not retained, and not received by us.
10. Your Rights
If you are located in the EEA or UK, you have the following rights under GDPR in respect of the personal data we hold (essentially, your license record and your purchase details):
- Access: Request a copy of the data we hold about you
- Rectification: Request correction of inaccurate data
- Erasure: Request deletion of your data ("right to be forgotten")
- Restriction: Request that we limit how we use your data
- Portability: Request your data in a machine-readable format
- Objection: Object to processing based on legitimate interests
To exercise any of these rights, please contact us at contact@pythonandvba.com. We will respond within 30 days. Because your workbook is never uploaded to us and encrypted pictures are deleted within minutes, there is no workbook data of yours for us to return or delete. For the addresses you sent to Google, contact Google under your Google account.
You also have the right to lodge a complaint with your local data protection supervisory authority. In the UK this is the Information Commissioner's Office (ico.org.uk); in the EEA you can find your national authority through the European Data Protection Board (edpb.europa.eu). We would welcome the chance to resolve your concern first, so please consider contacting us before you do.
11. Data Security
We take reasonable technical and organizational measures to protect your data against unauthorized access, loss, or disclosure. The Add-in's program code, the export page, the encrypted picture transfer, the license check and the requests to Google are transmitted over encrypted (HTTPS) connections, and the picture is additionally encrypted on your device before it is sent. We recommend you restrict your Google Maps API key in the Google Cloud console to the APIs PinPop needs.
12. Children's Privacy
The Add-in is not directed at children under the age of 16. We do not knowingly collect personal data from children.
13. Changes to This Policy
We may update this Privacy Policy from time to time. The "Last updated" date at the top of this page will reflect any changes. Continued use of the Add-in after changes are posted constitutes acceptance of the updated policy.
14. Contact
For any privacy-related questions or to exercise your rights, please contact:
1209 Mountain Road Pl NE, Ste N, Albuquerque, NM 87110, USA
Python & VBA · Sven Bosau
Email: contact@pythonandvba.com
Website: pythonandvba.com
