01
Address → coordinates
How to geocode addresses in Google Sheets
Turn one address column—or several adjacent address fields—into latitude and longitude without writing a formula or managing an API key.
Practical walkthroughs
Google Sheets geocoding guides
Learn the complete location-data workflow—from formulas, scripts and large batches to accuracy review, mapping, delivery, sales and store locators.
02
Coordinates → address
How to convert latitude and longitude to an address in Google Sheets
Reverse geocode decimal coordinate pairs into formatted addresses, city, region, postal code, country, and row-level status.
03
Product comparison
Best Google Sheets geocoding add-ons in 2026
Compare six options by free allowance, API-key setup, reverse geocoding, bulk jobs, permissions, pricing, row limits, and output fields.
04
Large batches
Bulk geocode thousands of addresses
A practical workflow for geocoding thousands of address rows in Google Sheets without losing row alignment, overwriting data, or hitting avoidable limits.
05
Formulas
Is there a GEOCODE formula?
Google Sheets has no native GEOCODE function. Compare an add-on, a custom Apps Script function, and a direct geocoding API before choosing a workflow.
06
Developer tutorial
Geocode with Google Apps Script
Build a menu-driven Google Apps Script that geocodes selected address rows, writes coordinates and statuses, and fails clearly when quotas or inputs are invalid.
07
Build or buy
Google Maps API vs a Sheets add-on
Compare a direct Google Maps Geocoding API integration with a managed Google Sheets add-on across setup, pricing, security, quotas, outputs and maintenance.
08
Mapping workflow
Map Sheets addresses in Google My Maps
Turn a Google Sheet of addresses into a shareable Google My Maps layer using reviewed latitude and longitude columns, stable labels and a repeatable import workflow.
09
Data preparation
Clean addresses before geocoding
Clean address columns in Google Sheets without destroying the original data, losing postal-code zeroes, or sending delivery notes and customer text to a geocoder.
10
Troubleshooting
Fix “No match found” results
Diagnose no-match geocoding results methodically by checking missing locality data, malformed rows, PO boxes, ambiguous place names and provider coverage.
11
Result quality
Understand geocoding accuracy
Understand what rooftop, range-interpolated, geometric-center and approximate geocodes mean—and why decimal precision is not the same as location accuracy.
12
Concepts
Geocoding vs address validation
Learn why finding coordinates does not prove an address is deliverable, and when a workflow needs geocoding, address validation, or both.
13
Input types
Geocode ZIP codes, PO boxes and landmarks
Understand what coordinate a geocoder is likely to return for ZIP codes, cities, PO boxes, landmarks and incomplete street addresses.
14
Real estate
Geocode a real estate property list
Turn a real estate property spreadsheet into reviewed coordinates for listing maps, comparable-property analysis, inspections and market research.
15
Sales operations
Map customers for sales territories
Prepare and geocode a CRM export in Google Sheets so sales operations teams can visualize customer coverage and make defensible territory decisions.
16
Delivery operations
Prepare delivery addresses for routing
Clean, geocode and quality-check delivery stops in Google Sheets before exporting them to route-planning or dispatch software.
17
Retail operations
Prepare store locator data
Build a clean, updateable store-location spreadsheet with stable IDs, reviewed coordinates, publishing fields and a repeatable quality-control process.
18
Coordinate analysis
Calculate distance between addresses
Geocode two addresses and calculate straight-line distance in Google Sheets using a tested Haversine formula, with clear limits for driving and route decisions.
What you will learn
Reliable location data, from raw address to final decision.
- Prepare address and coordinate columns for bulk processing.
- Select only the output fields your project needs.
- Write results to a specific starting cell without overwriting data.
- Understand blank, invalid, no-match, and quota statuses.
- Keep high-volume jobs running safely in the background.
- Compare Apps Script, direct APIs, add-ons and downstream mapping tools.
- Apply geocoding responsibly in real estate, sales, delivery and retail workflows.
Try the workflow
Start with 100 geocodes free.
One-time allowance per Google account. No API key or credit card.