Overview

ExtractCity finds and extracts city names from any cell in Google Sheets™.
Call ExtractCity over a range of address data like this:
=EXTRACTCITY(A1:A10)
And it will output the city name from each cell.
EXTRACTCITY Details
EXTRACTCITY outputs a standardized city name from any text or address input.
The add-on automatically detects city names within messy or formatted address strings — no API keys, no setup, and no external lookups required. It works seamlessly across individual cells or full column ranges.
You can also call ExtractCity with an optional second argument of 1, and the output will include the complete city, state / province, and country (when available).
For example, if cell A1 contains:
123 Main St Chicago IL
and you call:
=EXTRACTCITY(A1, 1)
It will output:
Chicago, IL United States
Uses and Benefits
Normalize and categorize address or location data
Extract cities from freeform text in Sheets™
Clean CRM or contact lists for analytics
Prepare real estate or eCommerce datasets
Standardize city data for map plotting
De-duplicate and merge datasets by city

ExtractCity does not perform geocoding; it simply identifies and outputs clean city information, making it a fast, privacy-safe alternative to traditional location APIs.
ExtractCity supports thousands of cities worldwide, from major metropolitan areas to smaller towns. If ExtractCity doesn’t yet recognize a specific city, you can suggest it via the Support link at the bottom of this page.