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 how to bulk convert addresses and coordinates while keeping your source data, output location, and spreadsheet workflow under control.
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.
What you will learn
A reliable spreadsheet workflow, not a fragile formula.
- 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.
Try the workflow
Start with 100 geocodes free.
One-time allowance per Google account. No API key or credit card.