Philippines cities list with latitude and longitude in Excel, CSV, SQL, XML, JSON formats

Philippines
Philippines
Excel, CSV, SQL, XML, JSON

Last update : 16 December 2025.

Country
Philippines
Capital
Manila
Number of cities
41852
Download
Click here

This is the best list of 41852 cities in the Philippines available in 5 formats ( Excel, CSV, JSON, SQL, XML ). You will find only data associated with the cities of a country (capital, towns and villages). There is no information concerning the environment, such as the location of a river or a mountain, for example. All cities are associated with regions and sub-regions (where available).

Each file contains the following data: Geoname_ID, City, Alternate_Name, Country_Code, Region, Sub_region, Latitude, Longitude, Elevation, Population, Timezone, Fcode_Name. See the FAQ below for a detailed explanation.

Here is an example of the data from the Philippines file that you are going to retrieve. The data is displayed here in the form of a table:


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
1726506BasagBasagPHBicolProvince of Albay13.2678123.59610Asia/Manilapopulated place
1724244Bulo IlayaBolo Ilaya,Bulo Ilaya,Ilayang BoloPHCalabarzonProvince of Quezon13.8755121.956280Asia/Manilapopulated place
1721112CagangCagangPHCentral VisayasProvince of Negros Oriental9.9716123.18210Asia/Manilapopulated place
1685163SuyoSuyoPHIlocosProvince of La Union16.6120.466670Asia/Manilapopulated place
1707953LaketLaketPHSoccsksargenProvince of South Cotabato6.24856124.851440Asia/Manilapopulated place
1732146AgbalangaAgbalangaPHCentral VisayasProvince of Cebu9.92381123.462860Asia/Manilapopulated place
1690823SalogonSalogon,SalongonPHBicolProvince of Camarines Sur13.6586123.52252239Asia/Manilapopulated place
1687220SapismalSapismalPHDavaoDavao Occidental5.45556125.491390Asia/Manilapopulated place
7428484Hacienda San BaldomeroHacienda San BaldomeroPHWestern VisayasProvince of Negros Occidental10.59556123.05930Asia/Manilapopulated place
7090977Pasong Putik ProperPHMetro ManilaEastern Manila District14.738121.06910Asia/Manilapopulated place
7418630CapenayCapenayPHWestern VisayasProvince of Iloilo11.255122.91140Asia/Manilapopulated place
1721107CagaraCagaraPHBicolProvince of Masbate12.4598123.4830Asia/Manilapopulated place
1700194MatutumMatutumPHSoccsksargenProvince of South Cotabato6.2975125.127780Asia/Manilapopulated place
1696930OwacanOwacanPHCentral VisayasProvince of Negros Oriental10.0274123.15460Asia/Manilapopulated place
1690732SalvacionSalvacionPHMimaropaProvince of Palawan10.2103119.22970Asia/Manilapopulated place
1704525MaboloMaboloPHCentral VisayasBohol9.66667124.20Asia/Manilapopulated place
1710634InudalInudalPHAutonomous Region in Muslim MindanaoProvince of Maguindanao7.03333124.483330Asia/Manilapopulated place
1709122KatambuanKatambuanPHEastern VisayasProvince of Leyte10.9891124.45590Asia/Manilapopulated place
1706583LibtongLibtongPHBicolProvince of Sorsogon12.95123.90Asia/Manilapopulated place
1685205SorocSoroc,SurocPHEastern VisayasProvince of Eastern Samar10.98795125.796360Asia/Manilapopulated place
7091181PoblacionPHMetro ManilaEastern Manila District14.5832121.02860Asia/Manilapopulated place
1697105OngcaOngcaPHCentral VisayasProvince of Cebu10.0624123.55620Asia/Manilapopulated place
1696941OtonOtonPHMimaropaProvince of Palawan11.1214119.50160Asia/Manilapopulated place
1713960Ebcor TownEbcor Town,Edcor,Gallego EdcorPHAutonomous Region in Muslim MindanaoProvince of Maguindanao7.44056124.397222483Asia/Manilapopulated place
1721575CabirianCabirianPHMimaropaOccidental Mindoro12.42794121.108210Asia/Manilapopulated place
1725265BilicBilic,BillicPHCentral LuzonProvince of Nueva Ecija15.56917121.153610Asia/Manilapopulated place
1698295NangalisanNangalisanPHCagayan ValleyProvince of Nueva Vizcaya16.62708121.209040Asia/Manilapopulated place
1728378BalaticBalatic,BataticPHCentral VisayasProvince of Cebu9.8129123.54070Asia/Manilapopulated place
1687495SantuyoSantoyo,Santuy,SantuyoPHCentral LuzonProvince of Nueva Ecija15.38333121.083330Asia/Manilapopulated place
1679462YopuanYopuanPHCagayan ValleyProvince of Nueva Vizcaya16.46667120.933330Asia/Manilapopulated place
1690102San EugenioSan EugenioPHBicolProvince of Sorsogon12.6743124.12650Asia/Manilapopulated place
1688045Santa MariaSanta MariaPHCalabarzonProvince of Laguna14.0262121.31180Asia/Manilapopulated place
1958168LangusLangusPHAutonomous Region in Muslim MindanaoProvince of Sulu6.2875120.57520Asia/Manilapopulated place
1724175BonbonBonbom,BonbonPHCalabarzonProvince of Quezon15.04233121.918760Asia/Manilapopulated place
1698129NaraNaraPHAutonomous Region in Muslim MindanaoProvince of Maguindanao7.15124.216670Asia/Manilapopulated place
7567549Balong-AnitoBalong-AnitoPHCentral LuzonProvince of Bataan14.4424120.4760Asia/Manilapopulated place
1693976PiasPiasPHIlocosProvince of La Union16.63333120.350Asia/Manilapopulated place
1683195TangcarangCancaron,TangcarangPHCentral LuzonProvince of Tarlac15.54749120.378360Asia/Manilapopulated place
1701137MaraguitMaraguitPHWestern VisayasProvince of Iloilo10.8451122.44860Asia/Manilapopulated place
1701476MantalonanMantalonanPHMimaropaProvince of Romblon12.34444122.020280Asia/Manilapopulated place
8373788Bunsuran TerceroBunsuran,Bunsuran III,Bunsuran Tercero,Bunsuran TresPHCentral LuzonProvince of Bulacan14.861120.928560Asia/Manilapopulated place
1694978PantalPHIlocosProvince of Pangasinan16.05120.333330Asia/Manilapopulated place
1705129LumutanLumotan,LumutanPHCalabarzonProvince of Quezon13.9798121.97650Asia/Manilapopulated place
1699725MilavigaMilabiga,MilavigaPHBicolProvince of Catanduanes13.8719124.13650Asia/Manilapopulated place
1703496MainpisMainpisPHIlocosProvince of Pangasinan16.3428119.89220Asia/Manilapopulated place
1698366NamolinasNamolinasPHCordilleraProvince of Abra17.43333120.833330Asia/Manilapopulated place
1705396LubongPHCordilleraProvince of Abra17.58333120.650Asia/Manilapopulated place
1700008MaygnawayMaygnauay,MaygnawayPHBicolProvince of Catanduanes13.6864124.06580Asia/Manilapopulated place
7625812BalimbingBalimbingPHCalabarzonProvince of Rizal14.5237121.33840Asia/Manilapopulated place
1721807CabaritanCabaritan,CaratanPHCagayan ValleyProvince of Cagayan18.23333121.583330Asia/Manilapopulated place
1732472Abar 2Abar 2,Abar SegundoPHCentral LuzonProvince of Nueva Ecija15.7796120.96630Asia/Manilapopulated place
1681727TipoloTipoloPHWestern VisayasProvince of Iloilo10.95122.633330Asia/Manilapopulated place
8301358CanibunganCanibunganPHWestern VisayasProvince of Negros Occidental10.9457123.24780Asia/Manilapopulated place
1695022PanoypoyPanoypoyPHCentral VisayasProvince of Cebu10.41314123.929390Asia/Manilapopulated place
1716303DadataganDadataganPHCordilleraProvince of Abra17.2120.750Asia/Manilapopulated place
1703051MalapatanBayan ng Malapatan,Lungsod sa Malapatan,MalapatanPHSoccsksargenProvince of Sarangani5.96917125.2894419439Asia/Manilapopulated place
1704133MadrilenoMadrelino,MadrilenoPHCaragaProvince of Surigao del Sur9.30444126.181390Asia/Manilapopulated place
1706111LinomotLinomot,LinumutPHCagayan ValleyProvince of Isabela16.54424121.80560Asia/Manilapopulated place
8549645MalintaPHCagayan ValleyProvince of Cagayan18.09065121.617410Asia/Manilapopulated place
1730236ArarampangAr-Arumpang,ArarampangPHIlocosProvince of La Union16.7775120.41840Asia/Manilapopulated place
1731708AlakayganAlacaygan,AlakayganPHWestern VisayasProvince of Iloilo11122.80Asia/Manilapopulated place
1715415DatagDatagPHCentral VisayasProvince of Siquijor9.255123.59750Asia/Manilapopulated place
1687577Santo RosarioSanto RosarioPHCentral LuzonProvince of Pampanga15.06819120.733350Asia/Manilapopulated place
1707538LangobLangobPHCentral VisayasProvince of Cebu9.6881123.3430Asia/Manilapopulated place
7418782GimelonGimelonPHWestern VisayasProvince of Iloilo11.0972122.63660Asia/Manilapopulated place
1720308CalimbahanCalimbahan,CalimbajanPHWestern VisayasProvince of Aklan11.7378122.26260Asia/Manilapopulated place
1702970MalauliMalauliPHCentral LuzonProvince of Pampanga14.82965120.667840Asia/Manilapopulated place
1722509BurabodBurabod,BurabudPHEastern VisayasBiliran11.4782124.4540Asia/Manilapopulated place
1700111MauoMaua,Mauo,MawoPHEastern VisayasProvince of Northern Samar12.4451124.31360Asia/Manilapopulated place
1683447TamontakaTamontacaPHSoccsksargenCotabato City7.18056124.225565166Asia/Manilapopulated place
1699639MinangaMinangaPHCagayan ValleyProvince of Cagayan17.69501121.898150Asia/Manilapopulated place
1690076San FelipeSan FelipePHCagayan ValleyProvince of Isabela17.12384121.888740Asia/Manilapopulated place
1710006CabadianganCabadiangan,KabadianganPHEastern VisayasProvince of Southern Leyte9.9506125.28610Asia/Manilapopulated place
7411899CabatbuganCabatbuganPHWestern VisayasProvince of Iloilo10.6584122.29340Asia/Manilapopulated place
1724100Bonga BongaBonga BongaPHEastern VisayasProvince of Leyte11.11667124.883330Asia/Manilapopulated place
1697180OloOloPHCentral VisayasProvince of Siquijor9.21667123.516670Asia/Manilapopulated place
1702341MambaliliPHCaragaProvince of Agusan del Sur8.19556125.970Asia/Manilapopulated place
1697493Nouvilas OrientalInabilas,Nauvitas Oriental,Nouvilas Oriental,Nouviles Oriental,Nouvillas OrientalPHEastern VisayasProvince of Samar11.2775125.146670Asia/Manilapopulated place
1729078Bago-IngedBago-IngedPHAutonomous Region in Muslim MindanaoProvince of Maguindanao7.06667124.650Asia/Manilapopulated place
7428762SingalatSingalatPHCentral LuzonProvince of Nueva Ecija15.59033121.085820Asia/Manilapopulated place
1723137Bujong SanglayPHBicolProvince of Masbate12.36667123.80Asia/Manilapopulated place
1682979TapaconTapaconPHWestern VisayasProvince of Iloilo11.13333122.616670Asia/Manilapopulated place
1727196BaniBaniPHCentral LuzonProvince of Zambales15.5823119.93353066Asia/Manilapopulated place
7618862TucodTucodPHCagayan ValleyProvince of Quirino16.4041121.47290Asia/Manilapopulated place
1705625Looc LabuanLooc,Looc LabuanPHZamboanga PeninsulaProvince of Zamboanga Sibugay7.56058122.471290Asia/Manilapopulated place
1721014CagdaraoCagdaraoPHBicolProvince of Catanduanes13.9073124.35440Asia/Manilapopulated place
8656550Mataas Na LupaCheckpoint,Mataas Na LupaPHCalabarzonProvince of Cavite14.2273120.883110Asia/Manilapopulated place
8313844SinturisanPHCalabarzonProvince of Quezon13.89007121.311590Asia/Manilapopulated place
1723115BukalBukalPHCentral LuzonProvince of Bataan14.8120.516670Asia/Manilapopulated place
7415721MabunoMabunoPHCagayan ValleyProvince of Cagayan18.0517121.84550Asia/Manilapopulated place
1729435Bad-angBad-angPHCaragaProvince of Surigao del Norte9.63528125.919720Asia/Manilapopulated place
1691350SabangPHCalabarzonProvince of Batangas14.06333120.711112563Asia/Manilapopulated place
1720627CalangCalangPHWestern VisayasProvince of Iloilo11.0531122.60080Asia/Manilapopulated place
6569704BagangonBagangonPHNorthern MindanaoProvince of Misamis Oriental8.47139124.329720Asia/Manilapopulated place
1966760NabalasanNabalasanPHBicolProvince of Masbate12.1379123.59490Asia/Manilapopulated place
1707597LangasianLangasiaan,LangasianPHCaragaProvince of Agusan del Sur8.24806125.714720Asia/Manilapopulated place
1706626LiboLiboPHCentral VisayasProvince of Siquijor9.2544123.65210Asia/Manilapopulated place
1720210Cal-litangCal-litangPHIlocosProvince of Pangasinan15.94141120.653740Asia/Manilapopulated place
1709101KatibungKatibung,LuukPHAutonomous Region in Muslim MindanaoProvince of Sulu6.3422120.54820Asia/Manilapopulated place
1719701CamiaCamiaPHWestern VisayasProvince of Iloilo10.58333122.150Asia/Manilapopulated place

Exploring the Geography of the Philippines: A Geographer’s Perspective

The Philippines, an archipelago of more than 7,000 islands, offers one of the most complex and fascinating geographical landscapes in Southeast Asia. Situated in the Pacific Ocean, the country is known for its diverse ecosystems, rich cultural heritage, and significant geological activity, making it a crucial point of study for geographers. From its mountainous regions to its expansive coastlines, understanding the precise layout of cities, regions, and departments through detailed geographical data is essential for gaining insights into how the natural environment influences urban development, resource distribution, and regional connectivity across the nation.

A Complex Geography: The Philippine Archipelago

The Philippines is characterized by its archipelagic nature, meaning the country consists of multiple islands spread across a vast area in the Pacific. These islands are grouped into three major geographical divisions: Luzon, Visayas, and Mindanao. Each region presents its own unique physical and cultural geography, contributing to the diversity that defines the nation.

Luzon, the largest and most populous island, is home to the capital city, Manila, and the surrounding National Capital Region. It features diverse terrains, ranging from coastal plains to rugged mountains, including the Sierra Madre and Cordillera mountain ranges. This varied geography has a significant impact on agriculture, urban development, and transportation networks.

The Visayas, situated in the central part of the archipelago, consists of a series of islands with extensive coastal areas and fertile lands. This region is known for its tropical beaches, while cities like Cebu and Iloilo serve as major cultural and economic hubs. The Visayas also face geographical challenges, including typhoons and volcanic activity, which influence local infrastructure and development.

Mindanao, the southernmost island group, offers a contrasting landscape, with vast plains, mountain ranges, and rainforests. Mindanao is home to a number of cities with rich cultural histories, such as Davao and Zamboanga, and has considerable agricultural and mineral resources. The region’s geographical features impact everything from local economies to regional politics.

The Philippines' geographical diversity shapes its environmental conditions, from the tropical climate that spans the islands to the high vulnerability to natural disasters such as typhoons, earthquakes, and volcanic eruptions. Understanding the relationship between geography and the urban centers that emerge within these diverse landscapes is key to understanding the country's development trajectory.

Cities and Regions: A Mapping of Urban Distribution

The Philippines is divided into 17 regions, each consisting of provinces, cities, and municipalities. These regions are essential in understanding the spatial distribution of cities and their relationship to the surrounding environment. Manila, the capital, located on Luzon, represents the country’s economic and political center. However, urban areas like Quezon City, Makati, and Pasig also form critical parts of the urban core within the National Capital Region (NCR), where more than 12 million people live.

Outside the capital, cities such as Cebu City and Davao City represent key regional centers of commerce, culture, and governance. Cebu City is an important port city in the Visayas, while Davao serves as the primary economic driver for Mindanao. Both cities are strategically located along major transport routes, contributing to their significance in the national economy.

In addition to these urban centers, the Philippines is home to numerous smaller cities and towns scattered across the provinces. Cities like Baguio, Tagbilaran, and Cagayan de Oro offer insight into how geography influences settlement patterns and how local communities adapt to the challenges of mountainous regions, coastlines, or river valleys.

The distribution of cities across the archipelago reflects the natural environment in which they are located. From bustling metropolises to quieter provincial towns, each city in the Philippines has developed in response to its geographical surroundings, creating a complex mosaic of urban areas that vary in size, economic importance, and cultural identity.

Latitude and Longitude: Pinpointing the Urban Landscape

Precise geographical data, such as the latitude and longitude of cities in the Philippines, plays a crucial role in understanding how urban centers are positioned relative to key natural features. For example, Manila’s coordinates are vital for its strategic location as a port city along Manila Bay, while cities like Cebu and Davao provide insight into the economic importance of the coastal areas and proximity to trade routes.

Knowing the latitude and longitude of cities like Quezon City, Davao, and Iloilo allows for detailed spatial analysis, enabling geographers to understand urban growth patterns, infrastructure needs, and the regional distribution of resources. This data also helps urban planners make informed decisions about transportation systems, disaster preparedness, and environmental conservation. Mapping out cities using these precise coordinates also facilitates the development of regional connectivity, ensuring that cities are well-connected by roads, ports, and airports, thus supporting national and international trade.

By understanding the exact coordinates of key cities, one can also better analyze the vulnerability of urban areas to natural disasters. For instance, the positioning of cities like Tacloban, which was heavily impacted by Typhoon Haiyan, provides valuable information on how cities in coastal and low-lying areas are affected by such events and how to plan for resilience.

Unlocking Geospatial Data for the Philippines

Having access to comprehensive geospatial data for the Philippines, including the precise latitude and longitude of cities, regions, and provinces, is vital for a wide range of applications. Such data allows geographers, urban planners, and policymakers to create accurate maps, assess spatial relationships, and make informed decisions about urban development, resource allocation, and environmental management.

For example, a database containing data on the cities of the Philippines can help researchers analyze patterns of urbanization and regional growth, while also considering environmental factors such as access to water resources, vulnerability to natural disasters, and available agricultural land. Additionally, accurate geographical data aids in the development of efficient transport networks, which are essential for the economic integration of remote regions with urban hubs.

This type of data also enhances the ability to monitor environmental changes and assess how different regions of the country are affected by climate change, deforestation, and other human activities. For instance, tracking the geographical coordinates of cities in the Visayas can help in evaluating the impacts of rising sea levels or the occurrence of more frequent and intense storms.

Conclusion

The Philippines, with its varied geography and complex urban landscapes, offers a rich canvas for geographical study. From the mountainous terrains of Luzon to the tropical coastlines of Mindanao, the distribution of cities and regions reflects the country’s diverse natural environment and historical development. Access to detailed geographical data, including the latitude and longitude of cities and regions, is essential for understanding how these urban centers interact with their surroundings, how they develop, and how they can adapt to challenges such as natural disasters and climate change. By leveraging this data, the Philippines can better plan for sustainable growth, infrastructure development, and environmental management in the future.

FaQ about Philippines

Once you have placed your order, you can download the product straight away! You'll also immediately receive an order confirmation email in which you can download your product. Remember to check your spam.
Don't panic, just log back in to the site and click on "your account" in the menu. You'll be able to find all your orders and re-download them whenever you like.
Yes, of course, click here to retrieve an archive containing an extract of the 5 Excel, CSV, XML, JSON and SQL files for a country.
Absolutely! You can pay with paypal or stripe in total security.
  • Geoname_ID: This is a unique identifier for each place or geographical name in the Geoname database.
  • City: The name of the place, which can be a town, village or any other form of human settlement.
  • Alternate_Name: Other names or appellations that the place may have. These alternative names may be in different languages, dialects or even local names.
  • Country_Code: This is the ISO 3166-1 alpha-2 code for the country in which the place is located. For example, "US" for the United States, "FR" for France.
  • Region: This represents the first-order administrative division in which the location is situated. For example, this could be a state, province or territory.
  • Sub_region: This is a second-order administrative division, such as a county or district, within the region.
  • Latitude: The geographical latitude of the location, usually in decimal degrees.
  • Longitude: The geographical longitude of the location, also usually in decimal degrees.
  • Elevation: The elevation or altitude of the location in relation to sea level, usually measured in metres.
  • Population: The estimated number of inhabitants or population of the location.
  • Timezone: The time zone in which the location is located, in accordance with global time zone standards.
  • Fcode_Name: This is a code that categorises the type of location. For example, "PPL" could mean a populated place, while "PPLC" could be the capital of a political entity.
You will retrieve a .zip archive containing the country files in Excel, CSV, SQL, XML and JSON formats.
Yes, you'll be able to download the content you've purchased whenever you want, with no time limit.
Make sure your Internet connection is stable, as some files can be quite large and take a long time to download.
Yes! We have recently updated our data packs and included the Excel (.xlsx) format, the latest Excel format. Take advantage now of 5 formats instead of 4 at no extra cost!

List of countries :

h2020-flow.eu

With the aim of delivering reliable information, based on quality sources such as Geoname (used under CC BY 4.0), we, a team of passionate geographers, have created this site. To enable you to obtain databases at very competitive prices.