Every community, alumni network, online course, professional association, mutual-aid group, eventually wants the same picture: all of us, on one map. It answers the first question a new member asks ('who else is near me?'), it makes the network feel real in a way a member count never does, and it is the one artifact members screenshot and share unprompted.
The standard advice online involves either enterprise alumni platforms or a decade-old tutorial pointing at BatchGeo. Neither is necessary. If your members are in a spreadsheet, the map is about ten minutes of work, free, with no pin limits, one community on our platform maps 8,698 graduates worldwide this way. Here is the exact method, including the cohort trick that makes the map tell a growth story.
- →A community map answers the question every member asks first: 'who else is near me?' — and it is the single most shareable artifact a community produces.
- →The method is three steps: export your member list, geocode the location column, publish the map with cohort colours. No code, no pin limits, free.
- →Cohort colouring is the trick most guides miss: statuses like 'New graduates (last 60 days)' turn a static pin map into a growth story you can screenshot every month.
- →City-level locations are enough — you do not need (and mostly should not publish) street addresses for members.
- →One community mapped this way on our platform tracks 8,698 graduates worldwide, coloured by graduation cohort, embedded on their site.
Step 1: The member list (city-level is enough)
Export your member list to a spreadsheet with three working columns: name (or first name only, see privacy below), location, and one grouping column (graduation year, cohort, membership tier, chapter). For location, city and country is the right granularity: 'Portland, Oregon' geocodes cleanly and doesn't publish anyone's home.
Privacy rule worth writing down: map what members gave you for the purpose of being found, chapter city, LinkedIn-level location, never billing addresses. If in doubt, first name plus city is plenty for a 'who's near me' map, and offer an opt-out before publishing.
Step 2: Geocode the whole column at once
Paste the location column into the free bulk geocoder linked below, you get back coordinates for every row and the enriched CSV. Or, in Google Sheets, write =GEOCODE(B2) and fill down: coordinates spill next to each member, live in the sheet, so next month's new members geocode themselves when you add rows.
City-level inputs geocode with near-perfect reliability, so a thousand-member list typically comes back clean in one pass, no manual fixing.
Step 3: The cohort trick — make the map tell a growth story
A flat pin map says 'we exist'. A cohort-coloured map says 'we are growing'. Use your grouping column as the map's status set, one community we host uses exactly two: 'Graduates' and 'New graduates (last 60 days)'. The recent cohort renders in its own colour, so every visitor sees not just the network but its newest growth ring.
This is also the monthly-content engine: screenshot the map when the 'last 60 days' cohort refreshes and you have a ready-made 'look who joined' post for the newsletter, every month, from data you already keep.
Step 4: Publish — the link and the embed
The live map gets a shareable link for the newsletter and an iframe embed for your site, and because it is fed by the spreadsheet, adding members updates the published map without touching the embed. No republish step, no export-import loop.
The map is where new members convert, so put it on the join page, not just the community page: 'members in 60 countries' as an interactive map outperforms the same claim as text.
Map your Salesforce accounts in under 5 minutes — no admin setup.
Paste your member list into the free geocoder — coordinates, live map and embed code in one pass. First 100 rows free, no login, no pin limits.
Open the free bulk geocoder