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

Colombia
Colombia
Excel, CSV, SQL, XML, JSON

Last update : 16 December 2025.

Country
Colombia
Capital
Bogotá
Number of cities
30947
Download
Click here

This is the best list of 30947 cities in the Colombia 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 Colombia file that you are going to retrieve. The data is displayed here in the form of a table:


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
3771370La CabañaCOCaucaEl Tambo2.50879-76.866660America/Bogotapopulated place
3770883Santa RosaCOCaucaPopayán2.5173-76.656580America/Bogotapopulated place
3683573El ParaísoEl Paraiso,El Paraíso,ParaisoCOCórdobaTierralta8.01176-76.178670America/Bogotapopulated place
8572805El ParqueEl ParqueCOCundinamarcaApulo4.47268-74.523890America/Bogotapopulated place
3830782Villa CruzCOBolívarArjona10.10625-75.361360America/Bogotapopulated place
3680780La HorquetaHorqueta,La HorquetaCOLa Guajira DepartmentAlbania11.1645-72.523540America/Bogotapopulated place
3733343Los CarruselesCOCesarChimichagua9.29472-73.791940America/Bogotapopulated place
3669000San RoqueCOAtlánticoBarranquilla10.95-74.833330America/Bogotapopulated place
3671546Puerto BarrigónBarrigon,Barrigón,Puerto Barrigan,Puerto Barrigon,Puerto Barrigán,Puerto BarrigónCOMetaCabuyaro4.16667-73.016670America/Bogotapopulated place
3689888AndreaAndrea,Hacienda AndreaCOAtlánticoPolonuevo10.76667-74.833330America/Bogotapopulated place
3738371MaracaiboCONorte de Santander DepartmentHacarí8.38646-73.133030America/Bogotapopulated place
3678770La HondaCOCasanare DepartmentYopal5.48699-72.395410America/Bogotapopulated place
3737201AltamiraCOTolimaPlanadas3.25583-75.616390America/Bogotapopulated place
3783461El RecreoCOCórdobaMontería8.77393-75.86560America/Bogotapopulated place
3669920San FelipeHato San Felipe,San FelipeCOCasanare DepartmentOrocué5.11667-71.916670America/Bogotapopulated place
3736241AmborcoCOHuilaPalermo3.02194-75.364440America/Bogotapopulated place
3734051El DoradoEl DoradoCOCaquetáAlbania1.17236-75.886270America/Bogotapopulated place
3678905La GloriaGloria,Hacienda Gloria,La GloriaCOMagdalenaSan Zenón9.3492-74.309770America/Bogotapopulated place
3687242CartagenaCOAmazonasEl Encanto-2.44494-72.28970America/Bogotapopulated place
3684645El CedroCaserio de El Cedro,Caserío de El Cedro,El CedroCOCundinamarcaNariño4.4251-74.792340America/Bogotapopulated place
10354548El UvalEl UvalCOHuilaBaraya3.12206-74.967990America/Bogotapopulated place
3774669El BálsamoCOBoyacáPuerto Boyacá5.81167-74.360280America/Bogotapopulated place
3670960RastrojosCOTolimaAmbalema4.88333-74.80America/Bogotapopulated place
3667349TausavitaCOCundinamarcaSutatausa5.26667-73.816670America/Bogotapopulated place
3690360Aguas ClarasCOSantanderSabana de Torres7.26583-73.561110America/Bogotapopulated place
3678736La HorquetaLa HorquetaCOCundinamarcaTocaima4.4491-74.588230America/Bogotapopulated place
3680996Hato el TotumoCOCasanare DepartmentTrinidad5.47593-71.603360America/Bogotapopulated place
3770373El DelirioCOAntioquiaPuerto Nare6.08528-74.736390America/Bogotapopulated place
3677364Las MaríasCOAntioquiaCaucasia7.98059-74.979970America/Bogotapopulated place
12421613MatacacaoMatacacaoCONorte de Santander Department8.75577-72.959010America/Bogotapopulated place
12385723La TrinidadLa TrinidadCONorte de Santander Department8.46663-73.248080America/Bogotapopulated place
3777276Tierra CastrosCOBoyacáMoniquirá5.89667-73.548060America/Bogotapopulated place
7544521Vereda San Luis de ChontayacoVda. San Luis de ChontayacoCOPutumayoMocoa1.14246-76.699890America/Bogotapopulated place
3780444La ToldaCOAntioquiaJericó5.74197-75.823670America/Bogotapopulated place
3674450MonteríaHacienda Monteria,Hacienda Montería,Monteria,MonteríaCOMagdalenaEl Piñon10.25662-74.637870America/Bogotapopulated place
8183351El VerdeEl VerdeCOSantanderFloridablanca7.05624-73.116730America/Bogotapopulated place
3670732Río NegroRio Negro,Río NegroCOTolimaDolores3.64361-74.809160America/Bogotapopulated place
3735664CasatejaCOCaucaPatía1.94393-77.178340America/Bogotapopulated place
3677066Las VacasCOSucre9.65386-75.095570America/Bogotapopulated place
3680027KashichomCOLa Guajira DepartmentUribia11.83783-72.166160America/Bogotapopulated place
8640391BellavístaCONariñoMagüi1.83273-78.185480America/Bogotapopulated place
3674008NatividadCOMagdalenaGuamal9.36504-74.08670America/Bogotapopulated place
3675309MarengoCOSantanderSan Vicente de Chucurí6.9-73.60America/Bogotapopulated place
3672473PericoCOCundinamarcaGuaduas5.35-74.70America/Bogotapopulated place
3683375El PorvenirEl Porvenir,Hacienda El PorvenirCOCesarLa Paz10.36667-73.216670America/Bogotapopulated place
3676495Llano GrandeCOBoyacáNuevo Colón5.36667-73.43710America/Bogotapopulated place
3668432Santa TeresaCONariñoArboleda1.47127-77.132620America/Bogotapopulated place
3683215RetiroCaserio Retiro,Caserío Retiro,RetiroCOBolívarMagangué9.16972-74.734630America/Bogotapopulated place
3666886ToribioHacienda La Pola,Hacienda Toribio,ToribioCOMagdalenaChibolo10.06667-74.466670America/Bogotapopulated place
8182161CarretonalCarretonalCOBogota D.C.4.65698-74.188730America/Bogotapopulated place
3782443San JorgeCOTolimaSan Antonio3.96306-75.471670America/Bogotapopulated place
3758116El Carmen de FonsecaCOLa Guajira DepartmentFonseca10.85595-72.83190America/Bogotapopulated place
3666536TuyaganoCOAntioquiaSabanalarga6.9-75.80America/Bogotapopulated place
3781087Las JuntasCOHuilaMunicipio de Íquira2.70592-75.62210America/Bogotapopulated place
3683703El OjitoCOSucreColoso9.49242-75.333880America/Bogotapopulated place
3778606Cueva AdentroCOValle del CaucaEl Cerrito3.65806-76.144440America/Bogotapopulated place
3669263San MiguelCOAntioquiaGiraldo6.65-75.883330America/Bogotapopulated place
3828558Los CedrosCONariñoGualmatán0.94855-77.584190America/Bogotapopulated place
3829415Buena VistaCOVichadaCumaribo4.26028-70.544170America/Bogotapopulated place
3686924Cerco de PiedraCOTolimaIbagué4.455-75.047220America/Bogotapopulated place
3769588BramadoraCOCasanare DepartmentManí4.60194-72.006940America/Bogotapopulated place
3782972La MariaCOValle del CaucaZarzal4.35167-76.13750America/Bogotapopulated place
3673527OroriaCOBolívarSimití8.11667-73.916670America/Bogotapopulated place
3675450ManicaCOSucreSincelejo9.39179-75.477050America/Bogotapopulated place
3774854Kilómetro CatorceCOBoyacáPuerto Boyacá5.878-74.44030America/Bogotapopulated place
3688966BellavistaCONariñoSan Andres de Tumaco1.66667-78.583330America/Bogotapopulated place
3782572La VictoriaCOTolimaChaparral3.71278-75.328060America/Bogotapopulated place
7522990CasablancaCasablancaCOAntioquiaNecoclí8.37276-76.755050America/Bogotapopulated place
8337209El JordánEl Jordan,El JordánCOAntioquiaEnvigado6.10181-75.569850America/Bogotapopulated place
3738331El CajónCONorte de Santander DepartmentEl Carmen8.62472-73.481390America/Bogotapopulated place
8581125San AntonioSan AntonioCOTolimaMelgar4.17088-74.597320America/Bogotapopulated place
3677975La ProvidenciaCOCesarAstrea9.55-73.916670America/Bogotapopulated place
3732089La EsperanzaCOSantanderSabana de Torres7.32278-73.414170America/Bogotapopulated place
3684323El DiamanteCOTolimaFlandes4.237-74.89280America/Bogotapopulated place
3735410El CerroEl CerroCOCaucaBolívar1.77027-77.016860America/Bogotapopulated place
3731757AltamirCOAntioquiaYarumal7.02111-75.59250America/Bogotapopulated place
12421378Santa HelenaSanta HelenaCONorte de Santander Department8.51497-72.923690America/Bogotapopulated place
7539578La CumbreLa CumbreCOCaquetáAlbania1.3021-75.953080America/Bogotapopulated place
3666544TutkaCOLa Guajira DepartmentUribia12.06667-71.883330America/Bogotapopulated place
3687747Campo LindoCampo LindoCODepartamento de AraucaArauca6.62092-70.496510America/Bogotapopulated place
3677566Las DeliciasFundo Las Delicias,Las DeliciasCODepartamento de AraucaPuerto Rondón6.45011-71.068630America/Bogotapopulated place
8626668Santa RitaCONariñoTúquerres1.05224-77.651540America/Bogotapopulated place
7523690El Otono LithiaEl Otono LithiaCOCundinamarcaGuaduas5.08839-74.584560America/Bogotapopulated place
3684863El BoralCOCasanare DepartmentTrinidad5.39208-70.702620America/Bogotapopulated place
3668574Santander de la CruzCOCórdobaMoñitos9.18925-76.174450America/Bogotapopulated place
3689799ApartaderosApartadero,ApartaderosCONorte de Santander DepartmentOcaña8.21667-73.333330America/Bogotapopulated place
3830727La RabiosaCOBolívarSan Juan Nepomuceno10.0565-75.116470America/Bogotapopulated place
3668736Santa InésCODepartamento de AraucaArauca6.95099-70.858510America/Bogotapopulated place
3671863PorvenirCOCaquetá1.31667-73.30America/Bogotapopulated place
3685921CorazónCOTolimaIbagué4.3-75.466670America/Bogotapopulated place
8559480Las Brisas MarinasCOCesarValledupar10.218-73.464160America/Bogotapopulated place
3775069Lama RedondaCOBoyacáOtanche5.79083-74.173330America/Bogotapopulated place
3679673La CajaCOMagdalenaFundación10.48333-73.650America/Bogotapopulated place
3774915La EsperanzaCOCundinamarcaYacopí5.74549-74.301860America/Bogotapopulated place
3673094PalominoOutaij-glicka,PalominoCOMagdalenaSanta Marta11.03567-73.64690America/Bogotapopulated place
3782890Capilla del SocorroCOValle del CaucaAndalucía4.18222-76.210America/Bogotapopulated place
3682139GardeniaGardenia,Hacienda GardeniaCOMagdalenaNueva Granada9.81253-74.429890America/Bogotapopulated place
3782644ChipalaCOTolimaOrtega3.82778-75.306940America/Bogotapopulated place
3828727San FranciscoCONariñoCumbal0.83234-77.840470America/Bogotapopulated place
3734734La PalomaCOTolimaRovira4.24139-75.369440America/Bogotapopulated place

Colombia: A Geographical Portrait of a Country of Diversity

Colombia, located at the crossroads of South America, is a country of immense geographical variety, offering everything from pristine beaches to snow-capped mountains, from vast jungles to arid deserts. This diverse landscape has not only shaped the nation's natural beauty but also influenced its cultural and economic development. For a geographer, Colombia provides an exceptional opportunity to explore how its geography impacts settlement patterns, biodiversity, and human activities. With access to detailed data on Colombia’s cities, regions, and departments—including the exact latitude and longitude of each—the study of this country’s geographic richness becomes even more enlightening.

The Geography of Colombia: A Land of Contrasts

Colombia’s geography is as varied as its culture, stretching from the Caribbean Sea to the Pacific Ocean, with the Andes mountain range running north to south through the country. The country can be divided into several key geographical regions, each with its unique characteristics.

The Caribbean Coast**: Stretching along the northern border, this coastal region features warm tropical climates and is home to Colombia's most famous beaches, like those found in **Cartagena**. The Caribbean region is characterized by lowland plains and tropical forests, and it plays an important role in the nation's trade and tourism industries.

The Andean Region**: The towering Andes mountains split Colombia into three distinct mountain ranges that run parallel to one another. This region is home to **Bogotá**, the capital and largest city, nestled high in the Andes. The Andean region is also the heart of Colombia’s coffee-growing area, where lush landscapes and cooler temperatures support the country’s world-renowned coffee industry.

The Amazon Basin**: To the south, Colombia is part of the Amazon rainforest, one of the most biodiverse regions on Earth. This vast tropical expanse is not only a key ecological area for the planet but also home to numerous indigenous cultures. The Amazon region is sparsely populated, with the small city of **Leticia** serving as its main urban center.

The Llanos (Plains)**: In the east, Colombia’s vast plains or Llanos stretch into **Venezuela**. This flat, grassy region is essential for Colombia's livestock industry. The Llanos experience a tropical climate and are prone to seasonal flooding, yet they remain crucial to the country's agricultural output.

The Pacific Coast**: The western side of the country along the Pacific Ocean is characterized by dense rainforests and one of the wettest places on Earth, **Chocó**. The region is largely underdeveloped but has significant natural resources, including vast rainforests and a coastline with rich marine life.

Urban Centers: The Role of Cities in Colombia's Development

Colombia’s urban landscape reflects the geographical diversity of the country. **Bogotá**, located high in the Andes, serves as the political, cultural, and economic hub of Colombia. The city’s altitude offers a cooler climate compared to the rest of the country, and its position makes it an ideal center for commerce, academia, and the arts. As a major metropolis, Bogotá stands in contrast to many smaller cities scattered across the country.

Other key cities in Colombia include **Medellín**, located in the Aburrá Valley, which was once known for its violent past but has undergone a remarkable transformation in recent years. **Cali**, located in the Valle del Cauca, is the salsa capital of the world and is renowned for its cultural vibrancy and warmth. On the Caribbean coast, **Barranquilla** is an industrial powerhouse and the site of one of the country’s most famous carnivals.

Cartagena**, a historic port city, stands out for its colonial architecture and its role as a major tourist destination on the Caribbean coast. This city is emblematic of Colombia's rich colonial past, with its walled city being a UNESCO World Heritage Site.

Administrative Divisions: Understanding Colombia’s Regions and Departments

Colombia is divided into **33 departments** and one capital district, Bogotá, each with its own unique geography, culture, and administrative system. The country’s political structure is based on these departments, which serve as the primary units for governance and administration. The **departments** vary greatly in terms of their geography, from the arid deserts of **La Guajira** in the north to the humid jungles of the **Amazon** in the south.

Some of the most notable departments include:

- **Antioquia**, home to Medellín, is known for its mountainous terrain and coffee-growing regions.

- **Cundinamarca**, where Bogotá is located, is the department that contains the capital city and the high-altitude areas surrounding it.

- **Atlántico**, on the Caribbean coast, contains the bustling port city of Barranquilla and has strong economic ties to the sea and trade.

- **Nariño**, in the southwest, borders Ecuador and is known for its stunning Andean landscapes and vibrant cultural heritage.

Each department is further divided into municipalities, which are the smallest units of governance in Colombia. These municipalities are responsible for local governance, public services, and community development. Understanding the structure of these regions helps to uncover the complexity of Colombia’s political and administrative landscape.

Accessing Detailed Data on Colombia’s Cities and Regions

For geographers and urban planners, having access to detailed geographic data on Colombia’s cities and regions is crucial for accurate analysis and planning. Our database provides in-depth data on Colombia’s towns, cities, regions, and departments, including their precise **latitude and longitude** coordinates. By obtaining this data, you can gain valuable insights into the spatial organization of the country and make informed decisions related to development, environmental management, and regional planning.

Whether you are researching the agricultural areas in the Llanos, studying urbanization trends in cities like Bogotá or Medellín, or planning sustainable development initiatives, detailed geographic data is an essential resource. With the ability to access coordinates for cities, municipalities, and departments, users can develop detailed maps, conduct spatial analyses, and make more informed decisions about Colombia’s future growth.

Conclusion: Exploring Colombia’s Geographic and Cultural Diversity

Colombia is a country of extraordinary geographic contrasts, with each region offering unique challenges and opportunities. From the Andean peaks to the Amazon rainforest, from coastal plains to high-altitude cities, Colombia’s diverse geography is reflected in the rich cultural and economic life of its people. By gaining access to detailed geographic data on the cities, regions, and departments of Colombia—including their exact latitude and longitude coordinates—you can deepen your understanding of this fascinating country. Whether for research, urban development, or environmental planning, this data is an invaluable tool for exploring Colombia’s geographic landscape and its role in the broader context of South America.

FaQ about Colombia

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.