1.0.0 (2026) #
The first release.
- A live Google map on the sheet, inserted like a chart and linked to a table or a block of cells with a header row.
- Finds the address columns (one address column, or street, city, postal code and country in separate columns) or existing latitude and longitude columns from the headers in English, German, French, Dutch and Spanish, and asks you to match the columns when it is not sure.
- Looks up missing coordinates once with your own Google Maps key and writes them into Latitude, Longitude and Match columns. Coordinates you typed yourself are never overwritten. Look up all addresses again looks up PinPop’s own rows again.
- Follows edits, new rows, sorts and filters. A click on a pin’s Select row selects its row in the sheet, and selecting a row in the sheet highlights its pin.
- Color by a column with a legend, popups with up to 6 columns, Group nearby pins for large lists, and the base maps Road, Light, Dark, Satellite and Satellite with labels (the Base map list in Style).
- Download PNG with Google’s logo and attribution kept, a saved picture of the map for colleagues without a key, Issues and Show list.
- Pro: up to 50,000 pins per map, unlimited maps per workbook, heat map, radius circles, a clean PNG and Place picture in sheet.
- Works in Excel on Windows, Mac and the web.
