Extract city names from addresses and location data.
Informações atualizadas:22 de junho de 2024
Compatível com:
6 mil+
Visão geral
CityLookup finds and extracts city names from any cell.

Call CityLookup over a range of address data like this:
=CITYLOOKUP(A1:A10)

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 Details
----------------------------------
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:
=CITYLOOKUP(A1, 1) 

It will output:
Chicago, IL United States

CITYFROMZIP Details
----------------------------------
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 in the future.

[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.
Informações adicionais
PreçosSem custo financeiro com recursos pagos
Desenvolvedor
Não empreendedor
Política de Privacidade
Termos de Serviço
O CityLookup pedirá as permissões abaixo. Saiba mais
O CityLookup precisará de acesso à sua Conta do Google
Isso permite que o CityLookup faça o seguinte:
Ver e gerenciar planilhas nas quais este aplicativo foi instalado
Exiba e execute conteúdo da Web de terceiros em prompts e barras laterais dentro dos aplicativos do Google
Conectar a um serviço externo
Ver o endereço de e-mail principal da sua Conta do Google
Ver suas informações pessoais, inclusive aquelas que você disponibilizou publicamente
Comentários
Idioma:
Ordenar por:
O Google não verifica avaliações nem classificações. Saiba mais sobre as avaliações
Nenhum comentário
Pesquisa
Limpar pesquisa
Fechar pesquisa
Google Apps
Menu principal