Extract city names from addresses and location data.
Listing updated:April 11, 2024
Works with:
CityLookup finds and extracts city names from any cell.

Call CityLookup over a range of address data like this:

And it will output the city name from each cell.

The following functions are also included:

- CITYFROMZIP(input) outputs a city name for the US zip code contained within the input

- [Beta] NEARESTCITY(lat,long) outputs the city that's closest to the inputted US lat/long coordinates

CITYLOOKUP outputs a standardized city name from any text/address input.

Call CityLookup with an (optional) second argument of 1, and the output will include the complete city, state / province, and country. For example, if cell A1 contains "123 Main St Chicago IL" and you call CityLookup like this:

It will output:
Chicago, IL United States

For United States zip code data or US addresses where the zip code is at the end of the cell, consider using CITYFROMZIP(A1:A10). Call it over a cell or a range of cells and it will output the city name for the zip code contained within the address. CITYFROMZIP currently works with US addresses only; we plan to add support for other countries throughout 2023.

[Beta] NEARESTCITY Details
For US geolocation data (latitude and longitude), NEARESTCITY(lat,long) outputs the city that's closest to the geographical coordinates inputted. 

NEARESTCITY is in beta; it currently works with US geocoordinates only and it may have inaccuracies, though we are actively testing/improving it. In cases where the inputted geopoint lies close to the edge of a bordering city, the closer city will be returned. This means geopoints at the very edge of a city's boundary may return the adjacent city.

Uses and benefits:
* Normalize and categorize address and location data
* Extract city from address in any spreadsheet
* Analyze and dedupe real estate listings across multiple web sites
* Clean CRM and customer contact data to uncover new insights
* Consolidate and standardize separate input files prior to analyzing or plotting on a map
* De-dupe addresses
* Match city data from separate web sites
* Lookup state, province, or country information for a list of cities

CityLookup does not provide geocoding; it simply finds and outputs clean city, state, and country information. CityLookup can be used as an alternative to geocode APIs for city-level data because its full output will plot on most mapping services.

CityLookup currently finds and matches the largest cities across the world, and many smaller cities in the US. If CityLookup isn't finding your city, please suggest it via the Support link at the bottom of this page.
Additional information
PricingFree of charge with paid features
Privacy policy
Terms of service
CityLookup will ask for the permissions shown below. Learn more
CityLookup will need access to your Google account
This will allow CityLookup to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Ryan Hawkinson
September 16, 2022
Highly recommend this app. It did a great job pulling the information out of the address and did everything I was looking for. In very weird places a city was not found however, support had this fixed in less than 5 mins. They were very quick!
Is this review helpful?
1-1 of 1
Clear search
Close search
Google apps
Main menu