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

Andorra
Andorra
Excel, CSV, SQL, XML, JSON

Last update : 23 March 2026.

Country
Andorra
Capital
Andorra la Vella
Number of cities
59
Download
Click here

Here you’ll find a curated sample of 100 key cities from Andorra, 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 59 geographic locations across Andorra.

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 Andorra is Andorra la Vella.


Geoname_IDCityAlternate_NameCountry_Code RegionSub_regionLatitudeLongitude ElevationPopulationTimezoneFcode_Name
3039604 Pas de la Casa Pas de la Kasa,Пас де ла Каса AD Encamp 42.54277 1.73361 2050 2363 Europe/Andorra populated place
3039634 Pal Pal AD La Massana 42.54592 1.47524 0 Europe/Andorra populated place
8260082 Incles AD Canillo 42.58285 1.66267 0 Europe/Andorra populated place
3039896 Mas de Ribafeta AD La Massana 42.56932 1.48858 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
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
3039181 Santa Coloma Santa Coloma AD Andorra la Vella 42.49454 1.49897 0 Europe/Andorra populated place
3041475 Aubinyà Aubinya,Aubinyà,Auvinya AD Sant Julià de Loria 42.4531 1.49247 0 Europe/Andorra populated place
3039132 Segudet Segudet AD Ordino 42.55713 1.53808 0 Europe/Andorra populated place
3040025 Les Subiranes Les Sobiranes AD Ordino 42.62055 1.54147 1612 6 Europe/Andorra populated place
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
3039320 Ransol AD Canillo 42.58137 1.63812 0 Europe/Andorra populated place
3040709 Els Plans Els Plans AD Canillo 42.58143 1.63273 0 Europe/Andorra populated place
3040140 l'Aldosa de canillo AD Canillo 42.57895 1.62902 195 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
11945537 La Comella La Comella AD Andorra la Vella 42.50117 1.52879 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
7302102 La Margineda Markhineda,Мархинеда AD Andorra la Vella 42.48599 1.49024 155 Europe/Andorra populated place
3041598 Aixovall Aixovall AD Sant Julià de Loria 42.4764 1.48899 0 Europe/Andorra populated place
3041519 Arinsal Arinsal,Arinsal',Arinsalis,arynsal,Аринсал,Аринсаль,آرینسال AD La Massana 42.57205 1.48453 1419 Europe/Andorra populated place
3038832 Vila Casas Vila,Vila AD Encamp 42.53176 1.56654 0 Europe/Andorra populated place
3039757 Nagol Nagol AD Sant Julià de Loria 42.47142 1.50231 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
3040694 El Vilar El Vilar AD Canillo 42.57204 1.608 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
3039979 Llorts Llors,Llorta,Lors AD Ordino 42.59625 1.52658 0 Europe/Andorra populated place
3041541 Arans Arans AD Ordino 42.58226 1.51844 0 Europe/Andorra populated place
3039386 Prats AD Canillo 42.56003 1.59396 0 Europe/Andorra populated place
3039819 Molleres Molleres AD Canillo 42.55093 1.58985 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
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
3040601 Escàs Escas,Escàs AD La Massana 42.54643 1.50895 0 Europe/Andorra populated place
3041609 Aixàs Aixas,Aixàs AD Sant Julià de Loria 42.48647 1.46838 0 Europe/Andorra populated place
10630523 Puiol del Piu AD La Massana 42.5652 1.49159 1660 400 Europe/Andorra populated place
8260095 Sant Miquel d'Engolasters AD Escaldes-Engordany 42.51119 1.55987 0 Europe/Andorra populated place
3039959 Llumeneres Llumeneres AD Sant Julià de Loria 42.47229 1.51165 0 Europe/Andorra populated place
3040437 Fontaneda Fontaneda AD Sant Julià de Loria 42.45405 1.46471 0 Europe/Andorra populated place
3039322 Ràmio AD Escaldes-Engordany 42.49734 1.57401 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
3038816 Xixerella AD La Massana 42.55327 1.48736 0 Europe/Andorra populated place
3039077 Sispony Sispony AD La Massana 42.53368 1.51613 0 Europe/Andorra populated place
3040609 Erts Ercs,Ercz,Erez AD La Massana 42.56218 1.4968 0 Europe/Andorra populated place
3040141 l'Aldosa AD La Massana 42.54391 1.52289 594 Europe/Andorra populated place
3041604 Aixirivall Aixirivali,Aixirivall,Aixirvall,Eixirivall AD Sant Julià de Loria 42.46245 1.50209 0 Europe/Andorra populated place
3041546 Ansalonga Ansalonga AD Ordino 42.56881 1.52198 0 Europe/Andorra populated place
3040067 Les Bons Els Bons AD Encamp 42.53873 1.58649 0 Europe/Andorra populated place
3040027 Les Salines AD Ordino 42.60952 1.53697 0 Europe/Andorra populated place
3039901 Mas d’Alins AD Sant Julià de Loria 42.44112 1.45128 0 Europe/Andorra populated place
3039154 El Tarter Ehl Tarter,Эл Тартер AD Canillo 42.57952 1.65362 1052 Europe/Andorra populated place
3040154 La Cortinada La Cortinada AD Ordino 42.57423 1.51845 0 Europe/Andorra populated place
3041543 Anyós Anyos,Anyós AD La Massana 42.53465 1.5251 0 Europe/Andorra populated place
3040200 Juberri Juberri,Juverri AD Sant Julià de Loria 42.44 1.49194 0 Europe/Andorra populated place
3038987 Sornàs Sornas,Sornàs AD Ordino 42.56461 1.52757 0 Europe/Andorra populated place
3040648 Engordany Engordany AD Escaldes-Engordany 42.51115 1.54118 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
3041098 Certers Certers,Certes,Certés,Sertes AD Sant Julià de Loria 42.47457 1.50611 0 Europe/Andorra populated place
3040737 El Serrat Lo Serrat AD Ordino 42.6183 1.53912 0 Europe/Andorra populated place
11945497 Els Vilars Els Vilars AD Escaldes-Engordany 42.51636 1.53356 0 Europe/Andorra populated place
3038999 Soldeu AD Canillo 42.57688 1.66769 602 Europe/Andorra populated place

Andorra: Precision Mapping in a Mountain Kingdom

A Territory Defined by Elevation and Administrative Harmony

Andorra is not just a country—it is a vertical world compressed into 468 square kilometers of rugged Pyrenean terrain. Between France and Spain lies this principality of peaks and valleys, where geography governs every aspect of life: settlement, transportation, governance, and economy. For geographers like myself, Andorra is not merely a place to map—it is a land to understand deeply, both in its physical relief and its administrative intricacy.

Its seven parishes—divided into clearly demarcated **regions and departments**—are a masterclass in local governance adapted to extreme topography. But until now, access to **well-structured geographic data** on Andorran cities has been frustratingly limited or overly generalized. That’s why I’ve compiled a meticulously detailed dataset of **Andorra’s cities**, enriched with their **latitude and longitude**, regional affiliations, and administrative subdivisions—available in **Excel (.xlsx)**, **CSV**, **SQL**, **JSON**, and **XML** formats. And with the recent introduction of **Excel**, accessing and manipulating this data has never been more intuitive or powerful.

The Geography Behind the Names

It’s easy to name the main cities: Andorra la Vella, Escaldes-Engordany, Encamp. But understanding them requires more than mere naming—it demands context. For example, Andorra la Vella is not just the capital; it's an urban node constrained by mountains and shaped by the Valira River. Encamp stretches vertically, clinging to mountain slopes while serving as a gateway to the Pas de la Casa. Sant Julià de Lòria, further south, balances proximity to the Spanish border with its own administrative identity.

Each city operates within a parish, but that alone doesn’t tell the whole story. These divisions carry historical, geographic, and political weight. That’s why this dataset does more than place cities on a map—it links each to its **respective region and department**, allowing users to understand spatial relationships in context, not isolation.

Why Excel Changes the Game

In making this dataset accessible in five formats, I had one goal: universality. Yet no format excites me more than the **Excel (.xlsx)** version. Why? Because Excel is where data becomes actionable. It doesn’t require code, doesn’t assume technical expertise, and doesn’t demand complex software environments. Anyone—from researchers and architects to policymakers and educators—can use Excel to instantly **filter by region**, **sort by altitude via coordinates**, or **map departmental overlaps** across Andorra’s intricate urban system.

Want to study tourism growth patterns between Canillo and La Massana? Excel makes comparison effortless. Need to isolate all cities within the parish of Ordino and visualize them on a 3D terrain model? The Excel file feeds cleanly into GIS platforms. This isn’t just a spreadsheet—it’s a **launchpad for geographic analysis**.

Granular Data for a Microstate That Matters

Despite its size, Andorra is not simple. Its terrain complicates everything—urban sprawl, infrastructure development, transport design, even weather modeling. In such conditions, **precise city-level data** is not optional—it’s essential. Every building, every switchback road, every administrative boundary has to be mapped with care.

This dataset offers just that: **clean, structured, georeferenced urban data**, linked to the correct regions and departments, and updated to reflect Andorra’s current administrative reality. It provides a foundation for studies in environmental risk, sustainable urban development, telecommunications planning, and beyond.

Reframing How We See Andorra

To many, Andorra is a tourist detour, a fiscal curiosity, a scenic blur between France and Spain. But to the geographic eye, it is a model of how topography, tradition, and governance can coexist with precision. With this dataset—especially in its newly available Excel format—we gain the ability to model, explore, and visualize this complexity without barriers.

For analysts, planners, researchers, or simply those passionate about microstates with macro significance, this resource opens a door. And in a country where mountain passes were once the only means of connection, that’s a breakthrough worth celebrating.

Download Andorra cities in Excel SQL CSV JSON XML

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

List of countries :

download-cities-data.org