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

Last update : 13 June 2025.
Below is a list of 100 prominent cities in Andorra. Each row includes a city's latitude, longitude, region and other variables of interest. This is a subset of all 59 places in Andorra that you'll find in our World Cities Database. You're free to use the data below for personal or commercial applications. The data below can be downloaded in Excel (.xlsx), .csv, .json, .xml and .sql formats. Notable Cities: The capital of Andorra is Andorra la Vella.
Geoname_ID | City | Alternate_Name | Country_Code | Region | Sub_region | Latitude | Longitude | Elevation | Population | Timezone | Fcode_Name |
---|---|---|---|---|---|---|---|---|---|---|---|
3040686 | Encamp | Ehnkam,Encamp,en kan pu,enkanpu jiao qu,Энкам,エンカンプ教区,恩坎普 | AD | Encamp | 42.53474 | 1.58014 | 11223 | Europe/Andorra | seat of a first-order administrative division | ||
8260095 | Sant Miquel d'Engolasters | AD | Escaldes-Engordany | 42.51119 | 1.55987 | 0 | Europe/Andorra | populated place | |||
3039896 | Mas de Ribafeta | AD | La Massana | 42.56932 | 1.48858 | 0 | Europe/Andorra | populated place | |||
11945497 | Els Vilars | Els Vilars | AD | Escaldes-Engordany | 42.51636 | 1.53356 | 0 | Europe/Andorra | populated place | ||
3039862 | Meritxell | Sanctuaire de Meritxeli,Sanctuaire de Meritxell,Santuari de Meritxell | AD | Canillo | 42.55403 | 1.59087 | 0 | Europe/Andorra | populated place | ||
3039901 | Mas d’Alins | AD | Sant Julià de Loria | 42.44112 | 1.45128 | 0 | Europe/Andorra | populated place | |||
3039386 | Prats | AD | Canillo | 42.56003 | 1.59396 | 0 | Europe/Andorra | populated place | |||
3039678 | Ordino | Ordino,ao er di nuo,orudino jiao qu,Ордино,オルディノ教区,奥尔迪诺 | AD | Ordino | 42.55623 | 1.53319 | 3066 | Europe/Andorra | seat of a first-order administrative division | ||
3041098 | Certers | Certers,Certes,Certés,Sertes | AD | Sant Julià de Loria | 42.47457 | 1.50611 | 0 | Europe/Andorra | populated place | ||
3041204 | Canillo | Canillo,Kanil'o,ka ni e,kaniryo jiao qu,Канильо,カニーリョ教区,卡尼略 | AD | Canillo | 42.5676 | 1.59756 | 3292 | Europe/Andorra | seat of a first-order administrative division | ||
3040694 | El Vilar | El Vilar | AD | Canillo | 42.57204 | 1.608 | 0 | Europe/Andorra | populated place | ||
3040025 | Les Subiranes | Les Sobiranes | AD | Ordino | 42.62055 | 1.54147 | 1612 | 6 | Europe/Andorra | populated place | |
3038999 | Soldeu | AD | Canillo | 42.57688 | 1.66769 | 602 | Europe/Andorra | populated place | |||
3040609 | Erts | Ercs,Ercz,Erez | AD | La Massana | 42.56218 | 1.4968 | 0 | Europe/Andorra | populated place | ||
3039959 | Llumeneres | Llumeneres | AD | Sant Julià de Loria | 42.47229 | 1.51165 | 0 | Europe/Andorra | populated place | ||
10630523 | Puiol del Piu | AD | La Massana | 42.5652 | 1.49159 | 1660 | 400 | Europe/Andorra | populated place | ||
3041475 | Aubinyà | Aubinya,Aubinyà,Auvinya | AD | Sant Julià de Loria | 42.4531 | 1.49247 | 0 | Europe/Andorra | populated place | ||
3039163 | Sant Julià de Lòria | San Julia,San Julià,Sant Julia de Loria,Sant Julià de Lòria,Sant-Zhulija-de-Lorija,sheng hu li ya-de luo li ya,Сант-Жулия-де-Лория,サン・ジュリア・デ・ロリア教区,圣胡利娅-德洛里亚,圣胡利娅-德洛里亚 | AD | Sant Julià de Loria | 42.46372 | 1.49129 | 8022 | Europe/Andorra | seat of a first-order administrative division | ||
3039604 | Pas de la Casa | Pas de la Kasa,Пас де ла Каса | AD | Encamp | 42.54277 | 1.73361 | 2050 | 2363 | Europe/Andorra | populated place | |
3040601 | Escàs | Escas,Escàs | AD | La Massana | 42.54643 | 1.50895 | 0 | Europe/Andorra | populated place | ||
3041519 | Arinsal | Arinsal,Arinsal',Arinsalis,arynsal,Аринсал,Аринсаль,آرینسال | AD | La Massana | 42.57205 | 1.48453 | 1419 | Europe/Andorra | populated place | ||
3039132 | Segudet | Segudet | AD | Ordino | 42.55713 | 1.53808 | 0 | Europe/Andorra | populated place | ||
3041543 | Anyós | Anyos,Anyós | AD | La Massana | 42.53465 | 1.5251 | 0 | Europe/Andorra | populated place | ||
3041375 | Bixessarri | Bicisarri,Bixessarri,Bixisarri,Biçisarri,Vixesarri | AD | Sant Julià de Loria | 42.48197 | 1.46052 | 0 | Europe/Andorra | populated place | ||
3040648 | Engordany | Engordany | AD | Escaldes-Engordany | 42.51115 | 1.54118 | 0 | Europe/Andorra | populated place | ||
3038816 | Xixerella | AD | La Massana | 42.55327 | 1.48736 | 0 | Europe/Andorra | populated place | |||
3039322 | Ràmio | AD | Escaldes-Engordany | 42.49734 | 1.57401 | 0 | Europe/Andorra | populated place | |||
8260082 | Incles | AD | Canillo | 42.58285 | 1.66267 | 0 | Europe/Andorra | populated place | |||
3038987 | Sornàs | Sornas,Sornàs | AD | Ordino | 42.56461 | 1.52757 | 0 | Europe/Andorra | populated place | ||
3039077 | Sispony | Sispony | AD | La Massana | 42.53368 | 1.51613 | 0 | Europe/Andorra | populated place | ||
11945537 | La Comella | La Comella | AD | Andorra la Vella | 42.50117 | 1.52879 | 0 | Europe/Andorra | populated place | ||
3039757 | Nagol | Nagol | AD | Sant Julià de Loria | 42.47142 | 1.50231 | 0 | Europe/Andorra | populated place | ||
3041541 | Arans | Arans | AD | Ordino | 42.58226 | 1.51844 | 0 | Europe/Andorra | populated place | ||
3040709 | Els Plans | Els Plans | AD | Canillo | 42.58143 | 1.63273 | 0 | Europe/Andorra | populated place | ||
3041598 | Aixovall | Aixovall | AD | Sant Julià de Loria | 42.4764 | 1.48899 | 0 | Europe/Andorra | populated place | ||
3039320 | Ransol | AD | Canillo | 42.58137 | 1.63812 | 0 | Europe/Andorra | populated place | |||
8260083 | Bordes d'Envalira | Bordes d'Envalira,Bordes de Envalira | AD | Canillo | 42.55962 | 1.68576 | 0 | Europe/Andorra | populated place | ||
3040437 | Fontaneda | Fontaneda | AD | Sant Julià de Loria | 42.45405 | 1.46471 | 0 | Europe/Andorra | populated place | ||
3038832 | Vila | Casas Vila,Vila | AD | Encamp | 42.53176 | 1.56654 | 0 | Europe/Andorra | populated place | ||
3040200 | Juberri | Juberri,Juverri | AD | Sant Julià de Loria | 42.44 | 1.49194 | 0 | Europe/Andorra | populated place | ||
3039166 | Sant Joan de Caselles | San Joan de Casettas,Sant Joan de Casellas,Sant Joan de Caselles | AD | Canillo | 42.57116 | 1.60761 | 0 | Europe/Andorra | populated place | ||
3040141 | l'Aldosa | AD | La Massana | 42.54391 | 1.52289 | 594 | Europe/Andorra | populated place | |||
3041546 | Ansalonga | Ansalonga | AD | Ordino | 42.56881 | 1.52198 | 0 | Europe/Andorra | populated place | ||
3041563 | Andorra la Vella | ALV,Ando-la-Vyey,Andora,Andora la Vela,Andora la Velja,Andora lja Vehl'ja,Andoro Malnova,Andorra,Andorra Tuan,Andorra a Vella,Andorra la Biella,Andorra la Vella,Andorra la Vielha,Andorra-a-Velha,Andorra-la-Vel'ja,Andorra-la-Vielye,Andorre-la-Vieille,Andò-la-Vyèy,Andòrra la Vièlha,an dao er cheng,andolalabeya,andwra la fyla,Ανδόρρα,Андора ла Веля,Андора ла Веља,Андора ля Вэлья,Андорра-ла-Велья,אנדורה לה וולה,أندورا لا فيلا,አንዶራ ላ ቬላ,アンドラ・ラ・ヴェリャ,安道爾城,안도라라베야 | AD | Andorra la Vella | 42.50779 | 1.52109 | 20430 | Europe/Andorra | capital of a political entity | ||
3039819 | Molleres | Molleres | AD | Canillo | 42.55093 | 1.58985 | 0 | Europe/Andorra | populated place | ||
3040737 | El Serrat | Lo Serrat | AD | Ordino | 42.6183 | 1.53912 | 0 | Europe/Andorra | populated place | ||
3039154 | El Tarter | Ehl Tarter,Эл Тартер | AD | Canillo | 42.57952 | 1.65362 | 1052 | Europe/Andorra | populated place | ||
7302102 | La Margineda | Markhineda,Мархинеда | AD | Andorra la Vella | 42.48599 | 1.49024 | 155 | Europe/Andorra | populated place | ||
3040027 | Les Salines | AD | Ordino | 42.60952 | 1.53697 | 0 | Europe/Andorra | populated place | |||
3040051 | les Escaldes | Ehskal'des-Ehndzhordani,Escaldes,Escaldes-Engordany,Les Escaldes,esukarudesu=engorudani jiao qu,lai sai si ka er de-en ge er da,Эскальдес-Энджордани,エスカルデス=エンゴルダニ教区,萊塞斯卡爾德-恩戈爾達,萊塞斯卡爾德-恩戈爾達 | AD | Escaldes-Engordany | 42.50729 | 1.53414 | 15853 | Europe/Andorra | seat of a first-order administrative division | ||
3040140 | l'Aldosa de canillo | AD | Canillo | 42.57895 | 1.62902 | 195 | Europe/Andorra | populated place | |||
3040067 | Les Bons | Els Bons | AD | Encamp | 42.53873 | 1.58649 | 0 | Europe/Andorra | populated place | ||
3040132 | la Massana | La Macana,La Massana,La Maçana,La-Massana,la Massana,ma sa na,Ла-Массана,ラ・マサナ教区,马萨纳 | AD | La Massana | 42.54499 | 1.51483 | 7211 | Europe/Andorra | seat of a first-order administrative division | ||
3041609 | Aixàs | Aixas,Aixàs | AD | Sant Julià de Loria | 42.48647 | 1.46838 | 0 | Europe/Andorra | populated place | ||
3039634 | Pal | Pal | AD | La Massana | 42.54592 | 1.47524 | 0 | Europe/Andorra | populated place | ||
3039181 | Santa Coloma | Santa Coloma | AD | Andorra la Vella | 42.49454 | 1.49897 | 0 | Europe/Andorra | populated place | ||
3039979 | Llorts | Llors,Llorta,Lors | AD | Ordino | 42.59625 | 1.52658 | 0 | Europe/Andorra | populated place | ||
3040154 | La Cortinada | La Cortinada | AD | Ordino | 42.57423 | 1.51845 | 0 | Europe/Andorra | populated place | ||
3041604 | Aixirivall | Aixirivali,Aixirivall,Aixirvall,Eixirivall | AD | Sant Julià de Loria | 42.46245 | 1.50209 | 0 | Europe/Andorra | populated place |
**Exploring Andorra's Geographic Tapestry: A Personal Perspective**
Introduction: Discovering Andorra's Hidden Gems**
Nestled amidst the majestic Pyrenees mountains lies the tiny yet enchanting principality of Andorra. As a geographer embarking on a personal exploration of this captivating country, delving into the data of its cities, regions, and geographical coordinates unveils a rich tapestry of natural beauty and cultural heritage. Join me on a journey through Andorra's diverse landscapes, from its charming towns to its rugged mountain peaks, as we uncover the unique geographical features that define this hidden gem of Europe.
Tracing the Cities: From Andorra la Vella to Encamp**
Acquiring data on the cities of Andorra provides valuable insights into the country's urban fabric, population distribution, and regional dynamics. From the bustling capital of Andorra la Vella, nestled in a picturesque valley surrounded by mountains, to the historic town of Encamp, with its charming streets and traditional stone houses, each city offers a glimpse into Andorra's rich history and vibrant culture. Mapping out the regions and departments encompassing these cities reveals the administrative structure and socio-economic landscape of this small but dynamic nation.
Charting Latitude and Longitude: Navigating Andorra's Mountainous Terrain**
Obtaining latitude and longitude data for each city in Andorra enables geographers to navigate the country's rugged topography with precision. From the towering peaks of the Pyrenees to the lush valleys and meandering rivers below, these coordinates serve as essential markers for travelers, hikers, and outdoor enthusiasts seeking to explore Andorra's natural wonders. By mapping out these geographical coordinates, we gain insights into Andorra's diverse terrain, microclimates, and ecological regions.
Exploring Regional Diversity: From Ordino to Sant Julià de Lòria**
Beyond its urban centers, Andorra boasts a rich diversity of regions, each with its own unique landscapes, traditions, and cultural heritage. From the alpine villages of Ordino, surrounded by rugged peaks and verdant forests, to the picturesque valley of Sant Julià de Lòria, dotted with Romanesque churches and medieval bridges, each region offers a distinct blend of natural beauty and historical charm. Acquiring data on the latitude and longitude of key landmarks, such as the Madriu-Perafita-Claror Valley, a UNESCO World Heritage Site, allows geographers to study patterns of regional development, tourism, and environmental conservation.
Conclusion: Celebrating Andorra's Geographic Splendor**
In conclusion, Andorra stands as a testament to the breathtaking beauty of its landscapes, the richness of its cultural heritage, and the resilience of its people. Through the lens of geography, we gain a deeper appreciation for Andorra's mountainous terrain, historic towns, and vibrant communities. As geographers, let us continue to explore, study, and celebrate the marvels of Andorra, ensuring its preservation for generations to come.

Download data files for Andorra's cities in Excel (.xlsx), CSV, SQL, XML and JSON formats
Exploring Andorra's Geography: A Data-Driven Insight
Nestled in the Pyrenees mountains, Andorra is a small but geopolitically significant country. Known for its picturesque landscapes, the tiny nation boasts some of the most stunning mountain vistas in Europe. But beyond its tourism appeal, Andorra offers a unique case study for geographers. With its cities, regions, and departments scattered across an intricate topography, having access to accurate geographic data is essential for better understanding the country’s development, infrastructure, and urban dynamics.
For anyone looking to gain a comprehensive understanding of Andorra's geography, acquiring data on its cities—including their regions, departments, and specific geographic coordinates—is invaluable. This information can be leveraged to explore the country’s urban planning, environmental management, and social dynamics in depth. With the right data, one can analyze how Andorra’s geography influences its urbanization and its economic and environmental policies.
Andorra’s Geography: A Landscape Shaped by Mountains
Andorra’s landscape is predominantly mountainous, which defines not only its natural beauty but also its urban development and infrastructure. Situated between France and Spain, the country consists mainly of rugged terrain with steep valleys, alpine forests, and snow-capped peaks. The largest city, Andorra la Vella, sits in a narrow valley at the confluence of two rivers, surrounded by towering peaks. Other towns and villages are scattered across the country, often perched in remote valleys or along mountain slopes.
The country’s urban areas, though small in population, are crucial economic hubs, especially due to the country’s role as a tax haven and its thriving tourism industry. The division of Andorra into regions and departments reflects the administrative need to manage both urban and rural areas across this challenging geography.
Data on Andorra’s Cities: Essential for Spatial Analysis
Obtaining data about Andorra's cities, including their regions and departments, is crucial for geographers and planners looking to study the country’s urban development and spatial dynamics. With only a few key urban centers, Andorra presents an interesting challenge for geographic analysis. Each city or village is tied to specific geographic features, from the valleys to the mountain passes, influencing everything from infrastructure to population density.
By acquiring data about the cities, their geographic positions, and the administrative divisions of Andorra, researchers can delve into how the nation manages urban growth amidst its mountainous terrain. This data can also shed light on how natural resources are distributed, how transportation networks are developed, and how Andorra’s relatively small population has been able to adapt to its unique environment.
Latitude and Longitude: Key Data for Mapping Andorra’s Cities
For an accurate geographic study of Andorra, latitude and longitude data is essential. These precise coordinates allow geographers to map out the location of each city, town, and village across the country. The exact geographic positioning of each settlement plays a key role in understanding its relationship with the surrounding landscape—whether it’s how a town is positioned relative to trade routes, the climate, or how it interacts with neighboring regions in France and Spain.
While the specific latitude and longitude data for each city are not provided here, these coordinates are fundamental for creating detailed geographic models. Whether for urban planning, disaster preparedness, or tourism development, understanding where each city is located geographically offers a critical foundation for all types of analysis.
Data Formats for Flexibility: Ensuring Access to Geographic Information
In today’s data-driven world, having access to geographic information in multiple formats is crucial for diverse uses. Formats such as CSV, SQL, JSON, and XML offer geographers and developers the flexibility to integrate Andorra’s city and regional data into a variety of tools and systems.
CSV and SQL formats are excellent for users who prefer working with databases or spreadsheets. These formats make it easy to organize and query the data for specific geographic insights. JSON and XML, on the other hand, are ideal for developers and those working with web-based applications or Geographic Information Systems (GIS). These formats ensure that Andorra’s geographic data can be easily shared and incorporated into various digital platforms.
By providing Andorra’s city and regional data in these accessible formats, it becomes possible for researchers, planners, and developers to efficiently integrate this information into their projects, whether they are designing custom maps, conducting spatial analysis, or building geographic models for future development.
Conclusion: The Power of Geographic Data in Understanding Andorra
Andorra may be small in size, but its geography is rich with complexity. Understanding its cities, regions, and administrative departments is crucial for a deeper analysis of the country’s development, infrastructure, and environmental challenges. By obtaining accurate latitude and longitude data, as well as information about the spatial distribution of cities, researchers and planners can gain valuable insights into Andorra’s urban planning and resource management strategies.
The availability of this data in formats like CSV, SQL, JSON, and XML further enhances its usability, providing geographers, developers, and policymakers with the flexibility to integrate this information into a range of applications. As Andorra continues to grow and evolve, having access to up-to-date geographic data will be essential for making informed decisions that ensure sustainable development and the well-being of its residents.