Madagascar cities list with latitude and longitude in CSV format

Madagascar
Madagascar
CSV, SQL, XML, JSON

Last update : 18 September 2024.

Country
Madagascar
Capitale
Antananarivo
Number of cities
24091
Download
Click here

This is the best list of 24091 cities in the Madagascar available in 4 formats ( CSV, Json, SQL, XML ). We have cleaned up the Geoname database to leave only the towns, capitals and villages. All are all associated with regions and sub-regions (where available).

Each file contains the following data: Geoname_ID, City, Alternate_Name, Country_Code, Region, Sub_region, Latitude, Longitude, Elevation, Population, Timezone, Fcode_Name. See the FAQ below for a detailed explanation.

Here is an example of the data from the Madagascar file that you are going to retrieve. The data is displayed here in the form of a table:


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
1084267AmbalamanakanaMGAmoron’i ManiaAmbositra District-20.7333347.183330Indian/Antananarivopopulated place
1078054AmpasimpotsyMGAlaotra MangoroMoramanga District-18.6833348.016670Indian/Antananarivopopulated place
1081919AmboaimitrohakyMGAndroyBeloha District-24.7666745.050Indian/Antananarivopopulated place
1063796IvoryMGUpper MatsiatraVohibato-21.5666746.916670Indian/Antananarivopopulated place
1060268MarobantyMGBoenyMahajanga II-15.8166746.90Indian/Antananarivopopulated place
1059187MenakanitsyMGIhorombeIvohibe-22.8666746.933330Indian/Antananarivopopulated place
1076481AndampyMGSofiaPort-Berge (Boriziny-Vaovao)-15.5333347.70Indian/Antananarivopopulated place
1059218MazavalanitraMGAtsinananaMarolambo-20.3333347.833330Indian/Antananarivopopulated place
1054586TsinjoarivoMGBongolavaTsiroanomandidy-19.0166745.650Indian/Antananarivopopulated place
1060023MarokoroMGAlaotra MangoroAndilamena District-16.5833348.216670Indian/Antananarivopopulated place
1073959AngodonaMGSofiaPort-Berge (Boriziny-Vaovao)-15.4666747.750Indian/Antananarivopopulated place
1083603AmbararataMGAnosyBetroka District-23.645.750Indian/Antananarivopopulated place
1075835AndondaheMGAtsinananaToamasina II-17.7549.366670Indian/Antananarivopopulated place
1070517AntanimenaMGAnosyAmboasary District-24.746.250Indian/Antananarivopopulated place
1061200ManavonyMGMelakyAntsalova-19.1666744.733330Indian/Antananarivopopulated place
1080144AmbohimenaAmbatomena,AmbohimenaMGBongolavaFenoarivobe-17.9666745.983330Indian/Antananarivopopulated place
1076533AndambarioMGIhorombeIhosy-22.6166746.516670Indian/Antananarivopopulated place
1076954AnalasatranaAnalasatrana,AntsatranaMGDianaAmbilobe-13.0666748.883330Indian/Antananarivopopulated place
1059308MatsaborimangaMGDianaAmbilobe-12.8666749.050Indian/Antananarivopopulated place
1071497AnosibeMGMelakyMaintirano-18.2833344.266670Indian/Antananarivopopulated place
1072057AnkilyMGAndroyTsihombe-25.3666745.533330Indian/Antananarivopopulated place
1060194MarofivikyMGAnosyAmboasary District-24.1833346.450Indian/Antananarivopopulated place
1070746Antanetibe AvaratraAntanetibe Avaratra,Antanetibe NordMGBongolavaTsiroanomandidy-19.0166746.466670Indian/Antananarivopopulated place
1081713AmbodialamponaMGAtsinananaBrickaville-18.548.70Indian/Antananarivopopulated place
1076660AndafiaMGMenabeBelo Sur Tsiribihina-19.3544.80Indian/Antananarivopopulated place
1078168AmpasimarinyAmpasimarina,AmpasimarinyMGBoenyMahajanga II-15.5166746.50Indian/Antananarivopopulated place
1064768FolahantezaMGAnalanjirofoMananara Nord District-16.0166749.533330Indian/Antananarivopopulated place
1077897AmpefyMGSavaVohemar-13.7549.833330Indian/Antananarivopopulated place
1073788AnjahandoakaMGAtsimo-AndrefanaSakaraha District-22.944.550Indian/Antananarivopopulated place
1062882MadiromirafyMGBoenyAmbato Boeni-16.3321246.85240Indian/Antananarivopopulated place
1084472AmbalabeMGMenabeManja District-21.5544.266670Indian/Antananarivopopulated place
1080850AmbodivoahangyMGAtsinananaBrickaville-18.7333348.583330Indian/Antananarivopopulated place
1083515AmbaratraMGVakinankaratraMandoto-19.5666746.466670Indian/Antananarivopopulated place
1077110AnalamavoMGMelakyBesalampy-16.6666744.716670Indian/Antananarivopopulated place
1067470BemambaMGMelakyAntsalova-19.2166744.783330Indian/Antananarivopopulated place
1084557AmbakiranoMGSavaVohemar-13.3666749.783330Indian/Antananarivopopulated place
1062238MahatsinjoMGAtsimo-AtsinananaMidongy-Atsimo-23.0666746.916670Indian/Antananarivopopulated place
1070828AntanantsaraMGAnalamangaAmbohidratrimo District-18.6333347.533330Indian/Antananarivopopulated place
1075931AndohatanyMGVakinankaratraFaratsiho-19.2547.050Indian/Antananarivopopulated place
1084362AmbalahosyMGVatovavy RegionMananjary-21.3833347.933330Indian/Antananarivopopulated place
1059993MaroleoMahaleo,MaroleoMGBoenySoalala-16.1545.233330Indian/Antananarivopopulated place
1077293AnalabeMGFitovinany RegionManakara-21.7833347.833330Indian/Antananarivopopulated place
1073741AnjanaboronaMGBoenyMahajanga II-15.6833346.516670Indian/Antananarivopopulated place
1083036AmbatolahyMGAnosyBetroka District-23.7546.150Indian/Antananarivopopulated place
1056029TaiembetsyMGAndroyTsihombe-25.445.450Indian/Antananarivopopulated place
1063828IvohimalazaIvohimalaza,Vahimalaza,Vohimalaxa,VohimalazaMGIhorombeIhosy-22.1166745.683330Indian/Antananarivopopulated place
1054022VohibolaMGAndroyBeloha District-24.745.10Indian/Antananarivopopulated place
1058424MorarfenaMGBongolavaFenoarivobe-18.4166746.683330Indian/Antananarivopopulated place
1078459AmpapamenabeMGDianaAmbilobe-13.3548.850Indian/Antananarivopopulated place
1082010AmbindaMGAnosyBetroka District-2345.833330Indian/Antananarivopopulated place
1056579SiasiaMGAnosyTaolagnaro-24.7666747.016670Indian/Antananarivopopulated place
1077785AmpiolahanaMGItasySoavinandriana-19.1546.450Indian/Antananarivopopulated place
1083225AmbatofolakaMGAnalanjirofoFenerive Est-17.2549.350Indian/Antananarivopopulated place
1062158MahaveloMGAtsimo-AtsinananaFarafangana District-22.747.70Indian/Antananarivopopulated place
1075419Andranoboaka AndremafanaAndranoboaka Andremafana,AndranomiboakaMGIhorombeIhosy-21.946.016670Indian/Antananarivopopulated place
1068886AntsotahaAntsotaha,AntsotsahaMGSavaVohemar-13.5549.833330Indian/Antananarivopopulated place
1082682AmbatomitsanganaMGAnalamangaAnkazobe District-18.2833347.133330Indian/Antananarivopopulated place
1059073MiakotsoMGBongolavaFenoarivobe-18.646.950Indian/Antananarivopopulated place
1060583Manompy AvaratraMGAlaotra MangoroAndilamena District-16.4166748.116670Indian/Antananarivopopulated place
1057450SahandratyMGVatovavy RegionNosy-Varika-20.5666747.933330Indian/Antananarivopopulated place
1059593MarovatoMGAtsinananaBrickaville-18.6833348.60Indian/Antananarivopopulated place
1073674AnjebaAnjeba,AnjebatobyMGAndroyAmbovombe District-24.9666745.566670Indian/Antananarivopopulated place
1075185AndranomaitsoMGVatovavy RegionIfanadiana-20.8333347.70Indian/Antananarivopopulated place
1062110MahazendaMGFitovinany RegionIkongo-21.8666747.450Indian/Antananarivopopulated place
1076380AndasimbaryMGAtsimo-AndrefanaBetioky District-23.9333344.950Indian/Antananarivopopulated place
1056503SoaindranaMGUpper MatsiatraVohibato-21.5166747.033330Indian/Antananarivopopulated place
1057467SahanantoMGAtsinananaBrickaville-18.5166748.966670Indian/Antananarivopopulated place
1076429AndaparatyMGAnalanjirofoMaroantsetra District-15.249.60Indian/Antananarivopopulated place
1067313BemavoMGAtsimo-AndrefanaBeroroha District-21.6166745.383330Indian/Antananarivopopulated place
1075349AndranofotsyMGAndroyBeloha District-24.9545.083330Indian/Antananarivopopulated place
1075581AndrambonivoryMGAmoron’i ManiaAmbatofinandrahana District-20.6833346.716670Indian/Antananarivopopulated place
1067998BekijanaMGItasySoavinandriana-19.2166746.666670Indian/Antananarivopopulated place
1061962MahitsitadyMGVakinankaratraBetafo District-19.746.833330Indian/Antananarivopopulated place
1066128BetsipangaMGAtsimo-AtsinananaBefotaka-23.946.966670Indian/Antananarivopopulated place
1083747AmbanimangyMGSavaAntalaha-15.2550.433330Indian/Antananarivopopulated place
1081177AmbodimanryMGBetsibokaMaevatanana-16.9666746.80Indian/Antananarivopopulated place
1062601MahamavoMGBetsibokaMaevatanana-16.947.20Indian/Antananarivopopulated place
1076262Andemaky AndrefanaAndemaky Andrefana,Andemaky Ouest,AndemokaMGAnosyBetroka District-23.0545.716670Indian/Antananarivopopulated place
1072236AnkilimaryMGAnosyAmboasary District-23.9833346.333330Indian/Antananarivopopulated place
1075264AndranolavaMGIhorombeIvohibe-22.4547.133330Indian/Antananarivopopulated place
1076543AndalonaMGVakinankaratraBetafo District-19.7166746.516670Indian/Antananarivopopulated place
1074511AndrazatoMGAnosyTaolagnaro-24.647.183330Indian/Antananarivopopulated place
1062611MahamaninaMGSavaVohemar-13.2333349.916670Indian/Antananarivopopulated place
1059653MarotsirakaMarotsifaka,MarotsirakaMGAtsimo-AndrefanaSakaraha District-22.8166744.30Indian/Antananarivopopulated place
1073563AnjilajilaMGVatovavy RegionMananjary-21.2166748.216670Indian/Antananarivopopulated place
1060465MareranoMarerano,MoraranoMGAtsimo-AndrefanaBeroroha District-21.3666744.866670Indian/Antananarivopopulated place
1069224AntsingiloMGMenabeMiandrivazo District-19.2833345.416670Indian/Antananarivopopulated place
1067194BemorampaBemoramba,BemorampaMGMelakyMaintirano-17.1666744.50Indian/Antananarivopopulated place
1083128AmbatoharananaMGAnalamangaAndramasina District-19.2833347.80Indian/Antananarivopopulated place
1084502AmbalabaoMGBetsibokaMaevatanana-17.4333347.183330Indian/Antananarivopopulated place
1060243MarodimakaMGDianaAmbilobe-13.5548.816670Indian/Antananarivopopulated place
1057550SahamamyAntsahamamy,SahamamyMGAlaotra MangoroAmparafaravola District-17.5166748.30Indian/Antananarivopopulated place
1077391AnadabomaroMGAndroyBekily District-24.1833345.750Indian/Antananarivopopulated place
1084391AmbalahambanaMGUpper MatsiatraVohibato-21.6833346.933330Indian/Antananarivopopulated place
1060548ManorokaMGAtsimo-AndrefanaToliara II District-23.5166743.833330Indian/Antananarivopopulated place
1062220MahatsinjokelyMGBoenyAmbato Boeni-16.9166745.966670Indian/Antananarivopopulated place
1061671ManakambahinyMGAtsinananaToamasina II-17.6333349.483330Indian/Antananarivopopulated place
1054049VohibazahaMGAtsinananaBrickaville-18.848.550Indian/Antananarivopopulated place
1070964AntananaboMGAtsimo-AtsinananaFarafangana District-22.8547.80Indian/Antananarivopopulated place
1075811AndongozahelyMGSofiaBefandriana Nord-15.149.250Indian/Antananarivopopulated place

FaQ about Madagascar

Once you have placed your order, you can download the product straight away! You'll also immediately receive an order confirmation email in which you can download your product. Remember to check your spam.
Don't panic, just log back in to the site and click on "your account" in the menu. You'll be able to find all your orders and re-download them whenever you like.
Yes, of course, click here to retrieve an archive containing an extract of the 4 CSV, XML, JSON and SQL files for a country.
Absolutely! You can pay with paypal or stripe in total security.
  • Geoname_ID: This is a unique identifier for each place or geographical name in the Geoname database.
  • City: The name of the place, which can be a town, village or any other form of human settlement.
  • Alternate_Name: Other names or appellations that the place may have. These alternative names may be in different languages, dialects or even local names.
  • Country_Code: This is the ISO 3166-1 alpha-2 code for the country in which the place is located. For example, "US" for the United States, "FR" for France.
  • Region: This represents the first-order administrative division in which the location is situated. For example, this could be a state, province or territory.
  • Sub_region: This is a second-order administrative division, such as a county or district, within the region.
  • Latitude: The geographical latitude of the location, usually in decimal degrees.
  • Longitude: The geographical longitude of the location, also usually in decimal degrees.
  • Elevation: The elevation or altitude of the location in relation to sea level, usually measured in metres.
  • Population: The estimated number of inhabitants or population of the location.
  • Timezone: The time zone in which the location is located, in accordance with global time zone standards.
  • Fcode_Name: This is a code that categorises the type of location. For example, "PPL" could mean a populated place, while "PPLC" could be the capital of a political entity.
You will retrieve a .rar archive containing the country files in csv, sql, xml and json formats.
Yes, you'll be able to download the content you've purchased whenever you want, with no time limit.
Make sure your Internet connection is stable, as some files can be quite large and take a long time to download.
Unfortunately we don't offer files in excel format, but it's really very easy to convert a csv file into excel. There are a plethora of free online sites that allow you to do this, here are a few: click here to convert csv to excel

List of countries :

h2020-flow.eu

With the aim of delivering reliable information, based on quality sources such as Geoname, we, a team of passionate geographers, have created this site. To enable you to obtain databases at very competitive prices.