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.