Excel Latitude/Longitude Generator (GeoCoder)
Turn any list of addresses, zip codes, or city names into GPS coordinates — instantly, inside Excel. No GIS software, no manual lookups, just results.
How it works
Paste your addresses. Get latitude and longitude back. Right in the spreadsheet.
You paste your list of addresses, zip codes, or city names into Excel GeoCoder. You click the button, and the tool sends each entry to the geocoding API and pulls back the exact latitude and longitude. Results land directly in your spreadsheet cells — no exporting, no copy-pasting from another tool, no GIS software to learn. Process hundreds of locations in one pass instead of looking each one up by hand.
See it in action
Three steps. Under a minute. Real screen recordings from the tool.
Paste your addresses into Excel
Drop your list of addresses, zip codes, or city names into a column. No formulas, no macros to configure.
Click to run the geocoder
One click sends every entry to the geocoding API. Your data stays in your file. Your API key stays in your Google account.
Get latitude and longitude back
GPS coordinates populate right inside your spreadsheet for every address in the list — ready for mapping or analysis.
Who it's for
Built for teams that need GPS coordinates attached to their location data — without leaving the spreadsheet they already work in.
GIS & mapping analysts
Turn a list of addresses into precise latitude, longitude and altitude — ready to drop straight into maps, dashboards, and spatial tools.
Supply chain analysts
Enrich location datasets with coordinates for distance calculations and spatial analysis.
Field service managers
Plan service territories and dispatch technicians using accurate GPS data from your own spreadsheet.
What's inside
Everything you need to turn addresses into coordinates at scale — nothing you'll never use.
What you get
- The Excel GeoCoder (Latitude/Longitude Generator) workbook (.xlsm)
- Written setup guide (PDF)
- Video walkthrough of a full geocoding run
- Free 1-on-1 Zoom call to set up your Google API key
- Email support from the builder
- Every future update to the GeoCoder
Requirements
- Microsoft Excel 365 (Windows or Mac)
- A free Google Cloud account with Maps APIs enabled
- An internet connection while calculating
Ready to stop tabbing between Google Maps and Excel?
One-time · Instant download · Free setup call included
Buy Now — $97Frequently asked questions
Real answers to the questions people ask before they buy.
Do I need an API key to geocode addresses?
Yes — setup takes about 5 minutes and we walk you through it on the free Zoom call. Most users stay within the free monthly usage tier.
Can I geocode zip codes or city names, not just full addresses?
Yes. The tool resolves coordinates from full addresses, zip codes, or city and state combinations — whatever level of detail you have.
How many addresses can I geocode at once?
There's no hard limit in the tool itself — the constraint is your API quota. Most users process hundreds of addresses per batch with no issue.
Does it work on Mac?
Yes — the tool works on Excel for Windows and Excel for Mac. You just need macros enabled.
Is this a subscription?
No. One-time purchase. You own the file — no monthly fees, no renewals, no seat charges.
Can my whole team use it?
Buy the Multi-User license ($187) — everyone on your team can install and use it. Single-User ($97) is for one workstation.
What customers say
Real customers using this tool in the field. Read more on our Google Business profile.
158+ Google reviews for ExcelDistanceCalculators.com — from customers across trucking, courier, real estate, construction, and public safety.
“We had a list of thousands of parcel addresses that needed to be plotted on a map for a zoning study. Before this tool, someone was pasting each address into Google Maps one at a time. The GeoCoder generated latitude and longitude for the entire list in a single pass — accurate coordinates, right in the same Excel file we were already using.”
“I evaluate potential store locations against demographic data every week. The GeoCoder converts our candidate address lists into lat/lon in seconds, so I can feed them into our GIS layer without a middleman tool. It even returns altitude, which we didn't know we needed until we started analyzing flood-risk zones.”
“Our study needed GPS coordinates for 8,000 sampling sites entered as street addresses. Vinnie's GeoCoder handled the whole batch inside Excel — no coding, no separate software. Vinnie also jumped on Zoom to help set up the Google API key. Turnaround went from days to minutes.”
You might also like
Other Excel tools our customers reach for.
