Colombia Cities with Latitude & Longitude – Download in Excel, CSV, SQL, JSON, XML

Colombia
Colombia
Excel, CSV, SQL, XML, JSON

Last update : 24 March 2026.

Country
Colombia
Capital
Bogotá
Number of cities
30947
Download

Here you’ll find a curated sample of 100 key cities from Colombia, each with essential data points such as latitude, longitude, administrative region, and other relevant attributes. This preview is extracted from our full dataset, which includes a total of 30947 geographic locations across Colombia.

Whether you’re working on mapping, analytics, or app development, the data is available for both personal and commercial use. All entries can be downloaded in five formats: Excel (.xlsx), CSV, SQL, JSON, and XML.

Capital Highlight: The official capital city of Colombia is Bogotá.


Geoname_IDCityAlternate_NameCountry_Code RegionSub_regionLatitudeLongitude ElevationPopulationTimezoneFcode_Name
3672686 Pavas CO QuindĂ­o Filandia 4.65139 -75.70972 0 America/Bogota populated place
3684942 El Bajo CO Cesar La Gloria 8.71667 -73.6 0 America/Bogota populated place
3666098 Versalles CO Antioquia Betania 5.75 -75.9 0 America/Bogota populated place
3685264 Delgado CO Amazonas Puerto AlegrĂ­a -1.34711 -73.43378 0 America/Bogota populated place
3676381 Los Algarrobos CO Casanare Department Aguazul 5.13013 -72.68521 0 America/Bogota populated place
3666426 Urcusique CO Putumayo VillagarzĂłn 1.01667 -76.61667 0 America/Bogota populated place
3735966 El Paraiso CO Tolima Ataco 3.42472 -75.48667 0 America/Bogota populated place
7909227 Santa Teresita CO Meta AcacĂ­as 3.97768 -73.71133 0 America/Bogota populated place
3680596 Independencia CO Magdalena Pivijay 10.35349 -74.45846 0 America/Bogota populated place
3677954 La Punta Caserio La Punta,CaserĂ­o La Punta,La Punta CO Magdalena El Banco 9.17583 -74.02917 0 America/Bogota populated place
3673562 Orientes CO Amazonas -0.46667 -72.7 0 America/Bogota populated place
3771694 Viña del Mar CO Santander Cimitarra 6.44 -74.04639 0 America/Bogota populated place
8622282 Hacienda Palacé Hacienda Palace,Hacienda Palacé CO Valle del Cauca Florida 3.28776 -76.2805 0 America/Bogota populated place
3777132 Sabanetas CO Santander Sucre 5.965 -73.90889 0 America/Bogota populated place
3675517 Mañaramahana CO La Guajira Department Maicao 11.45497 -72.08443 0 America/Bogota populated place
3667307 Tenche Corregimiento Tenche,Teche,Tenche,Teneche CO BolĂ­var San Jacinto del Cauca 8.26222 -74.64386 0 America/Bogota populated place
3675063 Matenovillo CO Casanare Department Hato Corozal 6.25442 -70.42404 0 America/Bogota populated place
3737244 Balsora CO Tolima Ataco 3.39667 -75.66417 0 America/Bogota populated place
10263349 Lagunillas Lagunillas CO Boyacá 6.59806 -72.55 0 America/Bogota populated place
10345370 Las Palamas CO Valle del Cauca Buenaventura 3.73802 -77.16402 0 America/Bogota populated place
3688068 Caimán CO Antioquia Turbo 8.28572 -76.70302 0 America/Bogota populated place
3676764 La Victoria CO Magdalena El Retén 10.69977 -74.34677 0 America/Bogota populated place
3680922 Hato Viejo CO Cundinamarca Sutatausa 5.26667 -73.88333 0 America/Bogota populated place
7578157 El LĂ­bano CO Cauca Rosas 2.26282 -76.71373 0 America/Bogota populated place
3827993 San Juan de Soco CO Amazonas Puerto Nariño -3.73611 -70.49278 0 America/Bogota populated place
3667986 Sincelejito Sincelejito,Sinsol CO CĂłrdoba MonterĂ­a 8.87278 -75.95667 0 America/Bogota populated place
3681135 Hacienda El Carmen CO Atlántico Malambo 10.81667 -74.83333 0 America/Bogota populated place
3680030 Karrapatamahana CO La Guajira Department Maicao 11.27324 -72.40839 0 America/Bogota populated place
8623405 La Calera La Calera CO Cauca Silvia 2.7473 -76.32367 0 America/Bogota populated place
7540737 Buenavista CO Nariño Policarpa 1.65378 -77.41499 0 America/Bogota populated place
3793639 Las Achiras CO Antioquia Uramita 6.94035 -76.21474 0 America/Bogota populated place
3677620 Las Cruces Las Cruces,Santander CO Nariño Barbacoas 1.55 -78.11667 0 America/Bogota populated place
3683201 El Rincón CO Boyacá Labranzagrande 5.6 -72.55 0 America/Bogota populated place
3678237 La Palmita CO Casanare Department ManĂ­ 4.81667 -72.28333 0 America/Bogota populated place
8622348 Hacienda El Arado Hacienda El Arado CO Cauca Puerto Tejada 3.2154 -76.39083 0 America/Bogota populated place
8640404 La Loma CO Nariño Magüi 1.93396 -78.18496 0 America/Bogota populated place
3769155 VerdĂşn CO Valle del Cauca Sevilla 4.08333 -75.86917 0 America/Bogota populated place
3770013 Santa Barbara CO Cundinamarca Ubalá 4.67862 -73.22531 0 America/Bogota populated place
3737066 El Triunfo CO Tolima Ataco 3.34694 -75.58472 0 America/Bogota populated place
3777072 Planada CO Boyacá Saboyá 5.71556 -73.72778 0 America/Bogota populated place
3682017 Gladiador CO Atlántico Malambo 10.85 -74.78333 0 America/Bogota populated place
3678870 La Granja CO Santander Piedecuesta 6.88333 -73.06667 0 America/Bogota populated place
3685195 Divisa Divisa,Hacienda Divisa CO Magdalena Sabanas de San Angel 10.19356 -74.34345 0 America/Bogota populated place
3792293 Tres Esquinas del Caguán Tres Esquinas,Tres Esquinas del Caguan,Tres Esquinas del Caguán CO Caquetá San Vicente del Caguán 1.86806 -74.81203 0 America/Bogota populated place
10331154 San Juan San Juan CO Meta El Castillo 3.64027 -73.88179 0 America/Bogota populated place
3669309 San Mateo San Mateo CO Sucre Sucre 8.8984 -74.71405 0 America/Bogota populated place
10321707 Rumania Rumania CO Huila Colombia 3.17257 -74.80166 0 America/Bogota populated place
3665790 RancherĂ­a Yoruma Rancheria Yoruma,RancherĂ­a Yoruma,Yaluma CO La Guajira Department Uribia 12.06815 -71.3369 0 America/Bogota populated place
3682417 Florencia CO CĂłrdoba Pueblo Nuevo 8.50661 -75.3789 0 America/Bogota populated place
3679371 La Cruz CO Atlántico Candelaria 10.48333 -74.88333 0 America/Bogota populated place
3780969 Albania CO Huila Santa MarĂ­a 2.95639 -75.56472 0 America/Bogota populated place
7523517 Jauja Jauja CO Cundinamarca 5.44092 -74.68027 0 America/Bogota populated place
3731960 Llano Grande Hacienda Llano Grande,Llano Grande CO Santander GirĂłn 7.02224 -73.16671 0 America/Bogota populated place
3684152 El GalerĂłn CO Casanare Department Aguazul 5 -72.38333 0 America/Bogota populated place
3776977 Monte Viejo CO Boyacá Gachantivá 5.74167 -73.56778 0 America/Bogota populated place
3674147 MĂşrujuy CO La Guajira Department Uribia 12.09452 -72.14143 0 America/Bogota populated place
3686693 Chenducua Chenducua,Shenducua,ShendĂşcua CO Cesar Valledupar 10.78487 -73.41432 0 America/Bogota populated place
3828409 El Plancito El Plancito CO Huila Colombia 3.30373 -74.82155 0 America/Bogota populated place
11780673 Epellulli CO La Guajira Department 12.10426 -71.39344 0 America/Bogota populated place
10631231 Los Naranjos Los Naranjos CO Tolima Coyaima 3.81226 -75.15043 0 America/Bogota populated place
3771046 Calarca CO Cauca Suárez 2.947 -76.73905 0 America/Bogota populated place
3676299 Los Brazos CO Nariño Barbacoas 1.61474 -78.21474 0 America/Bogota populated place
3667507 Tambichucué Tambichucue,Tambichucué,Tumbichucue,Tumbichucué CO Cauca Inzá 2.63372 -76.07085 0 America/Bogota populated place
8184290 La Maniqua La Maniqua CO Caquetá Florencia 1.5876 -75.64477 0 America/Bogota populated place
3681706 Guadualito CO La Guajira Department Riohacha 11.19564 -72.75117 0 America/Bogota populated place
8638494 Santa Helena CO Cesar Becerril 9.74964 -73.55604 0 America/Bogota populated place
3684458 El Convento CO Magdalena Nueva Granada 9.86777 -74.36225 0 America/Bogota populated place
3731982 Alto Las Niguas CO Santander Pinchote 6.484 -73.15338 0 America/Bogota populated place
3677911 La Rancherita CO Casanare Department Monterrey 4.85258 -72.91837 0 America/Bogota populated place
3687528 Cantera CO BolĂ­var Mahates 10.06667 -75.25 0 America/Bogota populated place
3780471 La Paseua CO Antioquia JericĂł 5.68299 -75.81103 0 America/Bogota populated place
3672934 Paraco Hacienda Paraco,Paraco CO BolĂ­var CĂłrdoba 9.63333 -74.91667 0 America/Bogota populated place
3669598 San José Hacienda San Jose,Hacienda San José,San Jose,San José CO Magdalena Algarrobo 10.06215 -74.08167 0 America/Bogota populated place
7578771 San Francisco CO Cauca TimbiquĂ­ 2.52149 -77.53238 0 America/Bogota populated place
10354669 San Jose San Jose CO Huila Neiva 2.90066 -74.99889 0 America/Bogota populated place
3770812 RĂ­o Sucio CO Cauca El Tambo 2.56897 -76.78339 0 America/Bogota populated place
3828156 Armenia Armenia CO Huila Baraya 3.09884 -74.94191 0 America/Bogota populated place
3681853 Granja Teobromina CO Magdalena Aracataca 10.63333 -74.23333 0 America/Bogota populated place
3674828 Mesa Redonda CO Huila Tello 3.12 -75.19778 0 America/Bogota populated place
7524498 San Vicente CO Nariño Los Andes 1.54643 -77.53525 0 America/Bogota populated place
3689342 Badillo CO Antioquia Ituango 7.23333 -75.93333 0 America/Bogota populated place
3687778 Campo Alegre CO Sucre Sincelejo 9.34165 -75.36779 0 America/Bogota populated place
3785374 El Estoril CO Antioquia ApartadĂł 7.86222 -76.63889 0 America/Bogota populated place
3776359 El LĂ­bano CO Santander 5.91608 -73.59824 0 America/Bogota populated place
12384982 La Laguna La Laguna CO Cauca 2.37193 -77.03018 0 America/Bogota populated place
7526935 Los Naranjitos Los Naranjitos CO Meta Restrepo 4.26587 -73.52292 0 America/Bogota populated place
6195782 CaserĂ­o San Lorenzo CO Departamento de Arauca Arauquita 7.01583 -71.51694 0 America/Bogota populated place
3671263 Puño de Oro Puno de Oro,Puño de Oro CO Vichada Puerto Carreño 6.26868 -67.68299 0 America/Bogota populated place
3776143 Buenos Aires CO Santander Albania 5.76833 -73.79083 0 America/Bogota populated place
3775017 La Reforma CO Boyacá Puerto Boyacá 5.99528 -74.36139 0 America/Bogota populated place
3672429 Pesca Pesca CO Boyacá Pesca 5.55833 -73.04986 0 America/Bogota populated place
3731864 Santa FĂ© CO Santander Sabana de Torres 7.37083 -73.44306 0 America/Bogota populated place
3668609 Santa Marta CO Casanare Department ManĂ­ 4.9615 -72.27992 0 America/Bogota populated place
7630233 La Simona CO Cauca TimbiquĂ­ 2.82561 -77.5073 0 America/Bogota populated place
3684483 El Congreso El Congreso,El Congreso Sitio CO Magdalena Santa Ana 9.52058 -74.5049 0 America/Bogota populated place
3780419 Montenegro CO Antioquia Concordia 5.97278 -75.85722 0 America/Bogota populated place
3782877 Bomba de Agua CO Valle del Cauca La Victoria 4.48583 -76.055 0 America/Bogota populated place
3778456 Alto Prado CO Valle del Cauca Ginebra 3.70194 -76.16028 0 America/Bogota populated place
3676844 La Veguita CO Meta Puerto LĂłpez 4.43163 -72.22921 0 America/Bogota populated place
3679752 La Boca de las Gaviotas CO Departamento de Arauca Arauquita 7.00798 -71.26657 0 America/Bogota populated place

Colombia: A Cartographic Treasure in the Heart of the Americas

Geographical Majesty Beyond the Andes

Colombia, a land where topography dictates culture and settlement, offers one of the most striking and complex spatial arrangements in Latin America. From the snow-capped peaks of the Andes to the tropical richness of the Amazon Basin, Colombia is a living canvas for any geographer passionate about regional studies, urban patterns, and the relationship between elevation, climate, and human organization.

Understanding Colombia is not just a matter of knowing its major cities—Bogotá, Medellín, Cali—but of grasping how its thousands of towns are structured across 32 departments and countless municipalities. Each administrative level reveals a new layer of identity, governance, and connection to the environment.

Urban Footprints Across Diverse Terrain

What fascinates me most about Colombia is how urbanization interacts with its rugged terrain. Cities are not randomly placed; they are carved into valleys, nestled along rivers, perched on high plateaus. Their positioning reflects centuries of adaptation to geography, from the coffee-growing altitudes of QuindĂ­o to the Afro-Caribbean rhythms of coastal Cartagena.

That’s why our city dataset for Colombia includes every officially recognized settlement—mapped and catalogued not only by name but also by region and department. This structure is critical for those building demographic models, running supply chain simulations, or simply trying to understand how a nation builds its identity across space.

The Power of Latitude and Longitude in Colombian Cartography

Colombia’s vast territory demands precision. Whether you’re a logistics planner mapping delivery routes through Cundinamarca or a climate researcher analyzing rainfall variation between Santander and Amazonas, accurate coordinates are non-negotiable. Each city in our dataset comes with its exact latitude and longitude—ready for any application, from GIS analysis to interactive web maps.

Why Excel is the New Frontier for Urban Geographers

While our data is available in various formats, the inclusion of Excel (xlsx) has been a game-changer. Excel provides a user-friendly yet powerful interface for spatial data exploration. It allows users to filter cities by department, sort them by longitude, or compare the number of settlements in coastal versus mountainous zones—all without needing specialized software.

Educators, students, journalists, and policy analysts alike benefit from this new Excel availability. It bridges the gap between raw data and accessible insight. For many, this format will serve as the entry point into serious geographic work on Colombia.

Data Formats for Every Digital Landscape

Beyond Excel, the dataset is also downloadable in CSV for basic tabular needs, SQL for database integration, JSON for developers building geographic apps, and XML for structured data processing. Whatever your digital ecosystem, our database is prepared to integrate seamlessly, ensuring high-quality location intelligence for any use case.

Why Regional Detail Matters in Colombia

Too often, global datasets lump Colombia into a few major nodes. But those who know the country understand its real pulse lies in the small cities and towns—the economic lifeblood of departments like Boyacá, Nariño, and Caquetá. Regional detail is not just technical; it is political, cultural, and ecological. That’s why our data is carefully grouped and labeled by administrative division, honoring the geographic integrity of each locality.

Conclusion: Mapping Colombia is Mapping Complexity

Colombia is not just a country—it’s a geographic dialogue. Between mountains and coastlines, between dense rainforest and dry valleys, between urban sprawl and rural resilience. To map Colombia is to map that dialogue, and to do it properly, you need accurate, comprehensive, and accessible data.

With our newly enhanced database—available in Excel and four additional formats—you gain access to the full cartographic fabric of Colombian cities, including their regional and departmental contexts and geospatial coordinates. Whether you are planning infrastructure, teaching geography, or building digital products, this data is your foundation for meaningful insight into one of Latin America’s most dynamic nations.

Download Colombia cities in Excel SQL CSV JSON XML

Access detailed latitude and longitude data for cities in Colombia, now available in Excel (.xlsx) — plus CSV, SQL, XML, and JSON formats

List of countries :

download-cities-data.org