Both put a list of addresses on a map. They work in different places, and the right one depends on where your list lives and who needs to see the map. BatchGeo is a third-party service; what follows describes it at the time of writing, so check batchgeo.com for its current features and plans.
How each works #
- BatchGeo is a website. You copy your rows from the spreadsheet, paste them into BatchGeo, and it makes a map that lives on BatchGeo’s site. When the list changes, you paste it again.
- PinPop is an Excel add-in. The map sits on the sheet next to your table and follows it: edits, new rows, sorts and filters show up on the map, and a click on a pin selects its row.
Side by side #
| BatchGeo | PinPop | |
|---|---|---|
| Where the map lives | On BatchGeo’s website | In your Excel workbook |
| Getting the data in | Copy and paste into the website | Click a cell in the table |
| When the list changes | Paste the data again | The map follows the sheet |
| Address lookups | Done by BatchGeo, no key of your own | Done with your own Google Maps key, coordinates written into your table |
| Sharing | A link to the map on BatchGeo’s site | The workbook itself, or a PNG or a picture in the sheet; no share link in 1.0 |
| Pricing model | A free version and paid plans billed monthly | A free version and a one-time Pro license; Google bills your key’s usage, mostly inside its free allowance |
| Where your data goes | Your rows are uploaded to BatchGeo | Your table stays in your workbook; only addresses go to Google |
When BatchGeo fits better #
- You want a public or shareable map link that anyone can open in a browser, without Excel.
- You do not want to set up a Google Maps key.
- You map a list once and rarely touch it again.
When PinPop fits better #
- Your list lives in Excel and changes often, and you are tired of pasting it into a website.
- You want to filter, sort and edit in Excel and see the result on the map at once.
- The data should stay in your workbook instead of on a third-party website.
- You prefer one payment to a monthly plan.
Try PinPop with the free version: it maps the first 50 rows of a table, enough to see whether it fits your list. See Getting started.
