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

Madagascar
Madagascar
Excel, CSV, SQL, XML, JSON

Last update : 24 March 2026.

Country
Madagascar
Capital
Antananarivo
Number of cities
24091
Download
Click here

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

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 Madagascar is Antananarivo.


Geoname_IDCityAlternate_NameCountry_Code RegionSub_regionLatitudeLongitude ElevationPopulationTimezoneFcode_Name
1054622 Tsimirandra MG Melaky Maintirano -17.35 44.6 0 Indian/Antananarivo populated place
1054272 Vatolalakahaby MG Atsimo-Andrefana Toliara II District -23.83333 43.66667 0 Indian/Antananarivo populated place
1084444 Ambalafarihy MG Sofia Mandritsara -15.93333 49.01667 0 Indian/Antananarivo populated place
1084761 Alakamisinandrianovona MG Itasy Soavinandriana -19.21667 46.75 0 Indian/Antananarivo populated place
1054143 Vinanitelo MG Fitovinany Region Manakara -22.01667 47.73333 0 Indian/Antananarivo populated place
1083686 Ambapaka MG Atsimo-Atsinanana Vangaindrano District -23.45 47.6 0 Indian/Antananarivo populated place
1069844 Antsahalavo MG Sava Sambava -14.05 49.78333 0 Indian/Antananarivo populated place
1054109 Voatavo Avaratra MG Ihorombe Ihosy -22.51667 46.25 0 Indian/Antananarivo populated place
1075276 Andranolava MG Alaotra Mangoro Ambatondrazaka District -17.95 48.26667 0 Indian/Antananarivo populated place
1054755 Tsilaipaka MG Boeny Soalala -16.23333 45 0 Indian/Antananarivo populated place
11288475 Tsimalazo MG Fitovinany Region Vohipeno -22.349 47.816 0 Indian/Antananarivo populated place
1076280 Andelakaka Andelakaka,Andelankaka MG Diana Ambanja -14.16667 48.75 0 Indian/Antananarivo populated place
1078076 Ampasimena MG Melaky Maintirano -18.2 44.53333 0 Indian/Antananarivo populated place
1059871 Maromitety MG Alaotra Mangoro Anosibe An’ala District -19.66667 48.03333 0 Indian/Antananarivo populated place
1079262 Ambondrono MG Amoron’i Mania Fandriana District -20.31667 47.56667 0 Indian/Antananarivo populated place
1064995 Fenoarivo MG Anosy Amboasary District -24 46.15 0 Indian/Antananarivo populated place
1082531 Ambatovaky MG Betsiboka Maevatanana -17.61667 47.01667 0 Indian/Antananarivo populated place
1078049 Ampasimpotsy MG Analamanga Andramasina District -19.45 47.83333 0 Indian/Antananarivo populated place
1054269 Vatolapana MG Fitovinany Region Vohipeno -22.33333 47.83333 0 Indian/Antananarivo populated place
1065947 Bevia MG Anosy Amboasary District -24.68333 46.45 0 Indian/Antananarivo populated place
1061025 Mandritsara MG Vatovavy Region Ifanadiana -21.05 47.65 0 Indian/Antananarivo populated place
1066111 Betsiratsy MG Upper Matsiatra Ambalavao -21.93333 46.48333 0 Indian/Antananarivo populated place
1066534 Besorindrana MG Analamanga Anjozorobe -18.03333 47.9 0 Indian/Antananarivo populated place
1062606 Mahamasina MG Upper Matsiatra Isandra -21.2 46.9 0 Indian/Antananarivo populated place
1080563 Ambohidava MG Alaotra Mangoro Ambatondrazaka District -17.55 48.53333 0 Indian/Antananarivo populated place
1068609 Beanamalaho MG Sava Antalaha -14.66667 50.1 0 Indian/Antananarivo populated place
1084614 Ambahivahy Ambahivahy MG Melaky Ambatomainty -17.7 45.6 0 Indian/Antananarivo populated place
1060914 Mangabe MG Analamanga Andramasina District -19.18333 47.71667 0 Indian/Antananarivo populated place
1063693 Kamisy MG Androy Ambovombe District -24.9 45.61667 0 Indian/Antananarivo populated place
1064146 Imantsaka MG Androy Bekily District -24.5 45.51667 0 Indian/Antananarivo populated place
1071780 Ankonaka MG Itasy Arivonimamo -19.13333 47.35 0 Indian/Antananarivo populated place
1061682 Manaka MG Anosy Amboasary District -24.08333 46.61667 0 Indian/Antananarivo populated place
1054652 Tsimavo MG Androy Ambovombe District -25.18333 45.78333 0 Indian/Antananarivo populated place
1070336 Antatika MG Atsimo-Andrefana Beroroha District -21.71667 45.21667 0 Indian/Antananarivo populated place
1067327 Bemasoandro MG Vakinankaratra Ambatolampy -19.18333 47.46667 0 Indian/Antananarivo populated place
1064988 Fenoarivo MG Anosy Amboasary District -24.2 46.45 0 Indian/Antananarivo populated place
1074213 Andromba MG Sofia Analalava -15.16667 47.58333 0 Indian/Antananarivo populated place
1066199 Betsimaita MG Amoron’i Mania Fandriana District -20.31667 47.36667 0 Indian/Antananarivo populated place
1059302 Matsaborimitsiveta MG Sofia Befandriana Nord -15.1 49.11667 0 Indian/Antananarivo populated place
1072041 Ankinga MG Sofia Analalava -14.15 48.16667 0 Indian/Antananarivo populated place
1060997 Mandroromody MG Vatovavy Region Nosy-Varika -20.8 48.23333 0 Indian/Antananarivo populated place
1053582 Vohitsova MG Androy Ambovombe District -24.68333 45.88333 0 Indian/Antananarivo populated place
1059159 Menaratra Menaratra,Menatratra MG Vakinankaratra Antsirabe II -20 47.43333 0 Indian/Antananarivo populated place
1055460 Toby MG Atsimo-Atsinanana Vondrozo -22.36667 47.41667 0 Indian/Antananarivo populated place
1070918 Antanandava MG Boeny Mahajanga II -15.75 46.91667 0 Indian/Antananarivo populated place
1071301 Antakotako MG Sava Vohemar -13.75 49.46667 0 Indian/Antananarivo populated place
1071565 Anolaka MG Atsimo-Andrefana Toliara II District -23.3 43.75 0 Indian/Antananarivo populated place
1071633 Ankosy MG Amoron’i Mania Ambositra District -20.65 47.36667 0 Indian/Antananarivo populated place
1055057 Tsaratanana MG Bongolava Fenoarivobe -18.06667 46.31667 0 Indian/Antananarivo populated place
1059409 Masimpleremana MG Vakinankaratra Antanifotsy -19.68333 47.26667 0 Indian/Antananarivo populated place
1063327 Lahieto MG Androy Ambovombe District -25.21667 46.16667 0 Indian/Antananarivo populated place
1070645 Antanihady Ambalahady,Antanihady MG Vatovavy Region Nosy-Varika -20.61667 48.46667 0 Indian/Antananarivo populated place
1054225 Vatovelona Ambinanyvatovelo,Vatovelona MG Analanjirofo Vavatenina District -17.63333 48.98333 0 Indian/Antananarivo populated place
1059747 Marosava MG Vatovavy Region Ifanadiana -21.16667 47.63333 0 Indian/Antananarivo populated place
1081190 Ambodimanga-Ranomafana MG Analanjirofo Fenerive Est -17.25 49.28333 0 Indian/Antananarivo populated place
1075015 Andranombiavy MG Analanjirofo Mananara Nord District -16.48333 49.6 0 Indian/Antananarivo populated place
1084356 Ambalakafe MG Vatovavy Region Nosy-Varika -20.53333 48.21667 0 Indian/Antananarivo populated place
1080146 Ambohimena MG Betsiboka Maevatanana -16.98333 46.75 0 Indian/Antananarivo populated place
1077507 Ampopohabe Ampoabe,Ampopohabe MG Vakinankaratra Betafo District -19.85 46.51667 0 Indian/Antananarivo populated place
1059950 Maromandia MG Sava Sambava -14.15 50.11667 0 Indian/Antananarivo populated place
1072386 Ankilahila MG Melaky Antsalova -19.08333 44.33333 0 Indian/Antananarivo populated place
1081397 Ambodimadiro MG Sofia Mampikony -16.26667 47.46667 0 Indian/Antananarivo populated place
1067664 Belaza MG Androy Beloha District -24.73333 45.13333 0 Indian/Antananarivo populated place
1058805 Mitsinjo MG Atsimo-Andrefana Toliara II District -23.28333 43.73333 0 Indian/Antananarivo populated place
1082303 Ambiataka Ambiataka,Ambiatoka,Ambiboka,Ambitoka MG Menabe Manja District -21.05 44.35 0 Indian/Antananarivo populated place
1059793 Maroria MG Diana Ambilobe -13.2 49.13333 0 Indian/Antananarivo populated place
1080120 Ambohimiandra MG Bongolava Fenoarivobe -18.35 46.63333 0 Indian/Antananarivo populated place
1065004 Fenoarivo MG Atsimo-Atsinanana Midongy-Atsimo -23.56667 47.03333 0 Indian/Antananarivo populated place
1057377 Saharevo MG Upper Matsiatra Vohibato -21.81667 47.33333 0 Indian/Antananarivo populated place
1068420 Bedrihy MG Atsimo-Andrefana Morombe District -21.38333 43.55 0 Indian/Antananarivo populated place
1064365 Ifanato MG Atsimo-Andrefana Betioky District -23.53333 44.15 0 Indian/Antananarivo populated place
1054295 Vatananto MG Atsimo-Atsinanana Vangaindrano District -23.7 47.21667 0 Indian/Antananarivo populated place
1077442 Ampoza MG Melaky Antsalova -18.86667 44.6 0 Indian/Antananarivo populated place
1061871 Maka MG Fitovinany Region Vohipeno -22.35 47.78333 0 Indian/Antananarivo populated place
1075838 Andonakaomby MG Diana Antsiranana II -12.75 49.06667 0 Indian/Antananarivo populated place
1076124 Andingilingy Avaratra Andingilingy,Andingilingy Avaratra,Andingilingy Nord MG Sofia Bealanana District -14.7 48.98333 0 Indian/Antananarivo populated place
1069462 Antsaonjo MG Atsimo-Andrefana Sakaraha District -23.23333 44.36667 0 Indian/Antananarivo populated place
1077104 Analamazaotra MG Alaotra Mangoro Moramanga District -18.93333 48.41667 0 Indian/Antananarivo populated place
1081809 Amboasary MG Upper Matsiatra Ikalamavony -20.91667 46.51667 0 Indian/Antananarivo populated place
1061646 Manakana MG Sofia Mandritsara -15.83333 48.53333 0 Indian/Antananarivo populated place
1063376 Komihevitsy Komehavitra,Komehevitra,Komihevitsy MG Boeny Soalala -16.45 45.63333 0 Indian/Antananarivo populated place
1069052 Antsoa MG Diana Antsiranana II -12.41667 49.03333 0 Indian/Antananarivo populated place
1076338 Andavadambo MG Analanjirofo Mananara Nord District -16.4 49.75 0 Indian/Antananarivo populated place
1071977 Ankisanga MG Amoron’i Mania Ambatofinandrahana District -20.7 46.91667 0 Indian/Antananarivo populated place
1084463 Ambalabe Avaratra Ambalabe Avaratra,Ambalabe Nord MG Androy Bekily District -23.95 45.45 0 Indian/Antananarivo populated place
1074158 Androrangavola MG Vatovavy Region Nosy-Varika -20.66667 48.25 0 Indian/Antananarivo populated place
1067875 Bekofoky MG Atsimo-Andrefana Betioky District -23.51667 44.51667 0 Indian/Antananarivo populated place
1057273 Sahave MG Analanjirofo Mananara Nord District -16.23333 49.76667 0 Indian/Antananarivo populated place
1083088 Ambatokapika MG Atsimo-Andrefana Betioky District -23.9 44.51667 0 Indian/Antananarivo populated place
1080730 Ambohibao MG Upper Matsiatra Ambohimahasoa -21.01667 47.08333 0 Indian/Antananarivo populated place
1059305 Matsaborimena MG Sofia Mampikony -16.1 47.83333 0 Indian/Antananarivo populated place
1077989 Ampasindava MG Anosy Taolagnaro -25.11667 46.48333 0 Indian/Antananarivo populated place
1067919 Bekitohy MG Atsimo-Andrefana Betioky District -23.75 44.63333 0 Indian/Antananarivo populated place
1078417 Amparibohitra MG Bongolava Tsiroanomandidy -18.96667 46.28333 0 Indian/Antananarivo populated place
1064104 Imotombe Sud MG Androy Ambovombe District -25.21667 45.7 0 Indian/Antananarivo populated place
1075744 Andrafiabe MG Diana Antsiranana II -12.91667 49.3 0 Indian/Antananarivo populated place
1084313 Ambalalova MG Upper Matsiatra Ambalavao -21.83333 46.81667 0 Indian/Antananarivo populated place
1056489 Soalafika MG Menabe Belo Sur Tsiribihina -19.65 44.78333 0 Indian/Antananarivo populated place
1076719 Anaviavy MG Atsimo-Andrefana Beroroha District -21.85 45.33333 0 Indian/Antananarivo populated place
1078588 Ampangoro MG Melaky Morafenobe -18.15 44.88333 0 Indian/Antananarivo populated place

Madagascar: Cartographic Wonder of the Indian Ocean

A Geographer’s Dream Unfolding in Red Earth and Green Canopy

Madagascar is not a land to be reduced to a sidebar on a map. It is a world apart—biogeographically, culturally, and geospatially. For any geographer who respects the craft, Madagascar offers a breathtaking contradiction: isolated yet connected, vast yet intimate, and above all, tragically underrepresented in structured geographic databases.

From the rice terraces of the Highlands to the dry deciduous forests of the west, every kilometer of this island nation carries not only ecological uniqueness but a spatial identity that matters. Understanding Madagascar requires far more than just tracing its outline—it requires knowing its cities, their regions, their departments, and how they each sit in relation to one another and to the terrain.

Data Scarcity in a Land of Diversity

Despite its significance, Madagascar continues to suffer from a chronic lack of usable city-level data. The country has over a thousand communes, many of which never appear in global datasets. Either they’re misspelled, misclassified, or omitted entirely. And yet, anyone working on development, conservation, logistics, or infrastructure in Madagascar knows how vital it is to understand the spatial structure of its cities.

This is what drove me to build an accurate, complete, and format-flexible dataset: a tool that reflects the reality on the ground, not just the illusion on outdated maps.

Organizing the Administrative Labyrinth

Madagascar is divided into regions and further into districts and communes—a structure that often confuses even those who work in development and regional planning. But this structure is essential. A city’s administrative alignment determines everything from funding to infrastructure responsibilities.

In this dataset, every city and town is clearly tagged with its respective region and department. Whether you're studying Atsimo-Andrefana’s remote villages or urban development in Toamasina, the hierarchy is preserved, respected, and usable.

Precision Mapping with Latitude and Longitude

Administrative boundaries are only half the story. Spatial analysis begins where coordinates start. That’s why each city and town is paired with verified latitude and longitude points—ready for geospatial modeling, route planning, population heatmaps, and environmental assessments. Whether you're designing transport corridors or planning medical outreach programs, accuracy isn't negotiable—it’s foundational.

Excel: More Than a Format, It’s the Main Interface

The recent integration of the Excel (.xlsx) format into this dataset marks a major leap forward. Unlike raw CSVs or code-heavy SQL dumps, Excel bridges the gap between technical and practical. You can filter cities by region, compare departments side by side, or visualize geographic spread directly within a pivot table.

This isn’t just about accessibility—it’s about effectiveness. The Excel version is designed for immediacy. Clean headers, intuitive layout, no encoding issues—ready for researchers, NGOs, urban planners, and students alike.

Of course, the dataset is also available in CSV, SQL, JSON, and XML for those with specialized workflows. But Excel is where most users will find the perfect balance of clarity and depth.

What the Dataset Offers

* Full list of cities and towns in Madagascar

* Structured by region and departmental alignment

* Includes latitude and longitude coordinates for each entry

* Provided in Excel (.xlsx), CSV, SQL, JSON, and XML formats

Madagascar Demands Better Maps—and Better Data

To work effectively in Madagascar, one must think beyond capital cities and major roads. The real stories, challenges, and opportunities lie in the villages tucked between baobab forests and river valleys. And without city-level data that respects regional and spatial realities, projects risk becoming guesswork.

That’s exactly why this dataset exists—to eliminate the guesswork. It brings clarity to complexity, structure to scale, and usability to one of the most ecologically and geographically important countries on Earth.

A Country Worth Mapping Properly

Geographers know that mapping is not about drawing—it’s about understanding. Madagascar cannot be understood through generic dots and lines. It needs layers. It needs structure. And it needs tools that reveal—not obscure—its richness.

With this dataset, now featuring a refined and professional Excel format, we finally have a working foundation. For those ready to take Madagascar seriously—not just romantically—this is your entry point.

Download Madagascar cities in Excel SQL CSV JSON XML

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

List of countries :

download-cities-data.org