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

Andorra
Andorra
Excel, CSV, SQL, XML, JSON

Last update : 13 June 2025.

Country
Andorra
Capitale
Andorra la Vella
Number of cities
59
Download

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_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
3040686EncampEhnkam,Encamp,en kan pu,enkanpu jiao qu,Энкам,エンカンプ教区,恩坎普ADEncamp42.534741.5801411223Europe/Andorraseat of a first-order administrative division
8260095Sant Miquel d'EngolastersADEscaldes-Engordany42.511191.559870Europe/Andorrapopulated place
3039896Mas de RibafetaADLa Massana42.569321.488580Europe/Andorrapopulated place
11945497Els VilarsEls VilarsADEscaldes-Engordany42.516361.533560Europe/Andorrapopulated place
3039862MeritxellSanctuaire de Meritxeli,Sanctuaire de Meritxell,Santuari de MeritxellADCanillo42.554031.590870Europe/Andorrapopulated place
3039901Mas d’AlinsADSant Julià de Loria42.441121.451280Europe/Andorrapopulated place
3039386PratsADCanillo42.560031.593960Europe/Andorrapopulated place
3039678OrdinoOrdino,ao er di nuo,orudino jiao qu,Ордино,オルディノ教区,奥尔迪诺ADOrdino42.556231.533193066Europe/Andorraseat of a first-order administrative division
3041098CertersCerters,Certes,Certés,SertesADSant Julià de Loria42.474571.506110Europe/Andorrapopulated place
3041204CanilloCanillo,Kanil'o,ka ni e,kaniryo jiao qu,Канильо,カニーリョ教区,卡尼略ADCanillo42.56761.597563292Europe/Andorraseat of a first-order administrative division
3040694El VilarEl VilarADCanillo42.572041.6080Europe/Andorrapopulated place
3040025Les SubiranesLes SobiranesADOrdino42.620551.5414716126Europe/Andorrapopulated place
3038999SoldeuADCanillo42.576881.66769602Europe/Andorrapopulated place
3040609ErtsErcs,Ercz,ErezADLa Massana42.562181.49680Europe/Andorrapopulated place
3039959LlumeneresLlumeneresADSant Julià de Loria42.472291.511650Europe/Andorrapopulated place
10630523Puiol del PiuADLa Massana42.56521.491591660400Europe/Andorrapopulated place
3041475AubinyàAubinya,Aubinyà,AuvinyaADSant Julià de Loria42.45311.492470Europe/Andorrapopulated place
3039163Sant Julià de LòriaSan Julia,San Julià,Sant Julia de Loria,Sant Julià de Lòria,Sant-Zhulija-de-Lorija,sheng hu li ya-de luo li ya,Сант-Жулия-де-Лория,サン・ジュリア・デ・ロリア教区,圣胡利娅-德洛里亚,圣胡利娅-德洛里亚ADSant Julià de Loria42.463721.491298022Europe/Andorraseat of a first-order administrative division
3039604Pas de la CasaPas de la Kasa,Пас де ла КасаADEncamp42.542771.7336120502363Europe/Andorrapopulated place
3040601EscàsEscas,EscàsADLa Massana42.546431.508950Europe/Andorrapopulated place
3041519ArinsalArinsal,Arinsal',Arinsalis,arynsal,Аринсал,Аринсаль,آرینسالADLa Massana42.572051.484531419Europe/Andorrapopulated place
3039132SegudetSegudetADOrdino42.557131.538080Europe/Andorrapopulated place
3041543AnyósAnyos,AnyósADLa Massana42.534651.52510Europe/Andorrapopulated place
3041375BixessarriBicisarri,Bixessarri,Bixisarri,Biçisarri,VixesarriADSant Julià de Loria42.481971.460520Europe/Andorrapopulated place
3040648EngordanyEngordanyADEscaldes-Engordany42.511151.541180Europe/Andorrapopulated place
3038816XixerellaADLa Massana42.553271.487360Europe/Andorrapopulated place
3039322RàmioADEscaldes-Engordany42.497341.574010Europe/Andorrapopulated place
8260082InclesADCanillo42.582851.662670Europe/Andorrapopulated place
3038987SornàsSornas,SornàsADOrdino42.564611.527570Europe/Andorrapopulated place
3039077SisponySisponyADLa Massana42.533681.516130Europe/Andorrapopulated place
11945537La ComellaLa ComellaADAndorra la Vella42.501171.528790Europe/Andorrapopulated place
3039757NagolNagolADSant Julià de Loria42.471421.502310Europe/Andorrapopulated place
3041541AransAransADOrdino42.582261.518440Europe/Andorrapopulated place
3040709Els PlansEls PlansADCanillo42.581431.632730Europe/Andorrapopulated place
3041598AixovallAixovallADSant Julià de Loria42.47641.488990Europe/Andorrapopulated place
3039320RansolADCanillo42.581371.638120Europe/Andorrapopulated place
8260083Bordes d'EnvaliraBordes d'Envalira,Bordes de EnvaliraADCanillo42.559621.685760Europe/Andorrapopulated place
3040437FontanedaFontanedaADSant Julià de Loria42.454051.464710Europe/Andorrapopulated place
3038832VilaCasas Vila,VilaADEncamp42.531761.566540Europe/Andorrapopulated place
3040200JuberriJuberri,JuverriADSant Julià de Loria42.441.491940Europe/Andorrapopulated place
3039166Sant Joan de CasellesSan Joan de Casettas,Sant Joan de Casellas,Sant Joan de CasellesADCanillo42.571161.607610Europe/Andorrapopulated place
3040141l'AldosaADLa Massana42.543911.52289594Europe/Andorrapopulated place
3041546AnsalongaAnsalongaADOrdino42.568811.521980Europe/Andorrapopulated place
3041563Andorra la VellaALV,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,Ανδόρρα,Андора ла Веля,Андора ла Веља,Андора ля Вэлья,Андорра-ла-Велья,אנדורה לה וולה,أندورا لا فيلا,አንዶራ ላ ቬላ,アンドラ・ラ・ヴェリャ,安道爾城,안도라라베야ADAndorra la Vella42.507791.5210920430Europe/Andorracapital of a political entity
3039819MolleresMolleresADCanillo42.550931.589850Europe/Andorrapopulated place
3040737El SerratLo SerratADOrdino42.61831.539120Europe/Andorrapopulated place
3039154El TarterEhl Tarter,Эл ТартерADCanillo42.579521.653621052Europe/Andorrapopulated place
7302102La MarginedaMarkhineda,МархинедаADAndorra la Vella42.485991.49024155Europe/Andorrapopulated place
3040027Les SalinesADOrdino42.609521.536970Europe/Andorrapopulated place
3040051les EscaldesEhskal'des-Ehndzhordani,Escaldes,Escaldes-Engordany,Les Escaldes,esukarudesu=engorudani jiao qu,lai sai si ka er de-en ge er da,Эскальдес-Энджордани,エスカルデス=エンゴルダニ教区,萊塞斯卡爾德-恩戈爾達,萊塞斯卡爾德-恩戈爾達ADEscaldes-Engordany42.507291.5341415853Europe/Andorraseat of a first-order administrative division
3040140l'Aldosa de canilloADCanillo42.578951.62902195Europe/Andorrapopulated place
3040067Les BonsEls BonsADEncamp42.538731.586490Europe/Andorrapopulated place
3040132la MassanaLa Macana,La Massana,La Maçana,La-Massana,la Massana,ma sa na,Ла-Массана,ラ・マサナ教区,马萨纳ADLa Massana42.544991.514837211Europe/Andorraseat of a first-order administrative division
3041609AixàsAixas,AixàsADSant Julià de Loria42.486471.468380Europe/Andorrapopulated place
3039634PalPalADLa Massana42.545921.475240Europe/Andorrapopulated place
3039181Santa ColomaSanta ColomaADAndorra la Vella42.494541.498970Europe/Andorrapopulated place
3039979LlortsLlors,Llorta,LorsADOrdino42.596251.526580Europe/Andorrapopulated place
3040154La CortinadaLa CortinadaADOrdino42.574231.518450Europe/Andorrapopulated place
3041604AixirivallAixirivali,Aixirivall,Aixirvall,EixirivallADSant Julià de Loria42.462451.502090Europe/Andorrapopulated 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 world databases cities Andorra

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.

List of countries :

worldcitiesdatabase.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.