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

Ethiopia
Ethiopia
Excel, CSV, SQL, XML, JSON

Last update : 16 December 2025.

Country
Ethiopia
Capital
Addis Ababa
Number of cities
10820
Download
Click here

This is the best list of 10820 cities in the Ethiopia available in 5 formats ( Excel, CSV, JSON, SQL, XML ). You will find only data associated with the cities of a country (capital, towns and villages). There is no information concerning the environment, such as the location of a river or a mountain, for example. All cities are 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 Ethiopia file that you are going to retrieve. The data is displayed here in the form of a table:


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
334028IucheraETOromiya7.8166735.20Africa/Addis_Ababapopulated place
331001MengudoETAmhara11.5333339.916670Africa/Addis_Ababapopulated place
341604Bota’āETOromiya9.5166738.033330Africa/Addis_Ababapopulated place
335797GubaGuba,Gubba,HulghiziETBīnshangul Gumuz11.2666735.283330Africa/Addis_Ababapopulated place
326897UmbuloETOromiya9.2666737.050Africa/Addis_Ababapopulated place
337797FersoETOromiya9.837.016670Africa/Addis_Ababapopulated place
328674ShebēlēSciavelli,Shavelli,Shebele,ShebēlēETSomali9.2611142.664440Africa/Addis_Ababapopulated place
342894BagunaBaguina,Baguna,BoguinaETAmhara10.7333336.950Africa/Addis_Ababapopulated place
325811YifagIfag,Yefag,Yefāg,YifagETAmhara12.0833337.716670Africa/Addis_Ababapopulated place
6687909DarguhiyaDarguhiya,DargukhiyaETTigray13.4605639.24560Africa/Addis_Ababapopulated place
345665Ābu BoteroETOromiya9.938.316670Africa/Addis_Ababapopulated place
326963Uesca UecaUesca Ueca,Washa WahaETSNNPR5.8377835.601050Africa/Addis_Ababapopulated place
336234Godir AlehETSomali8.6833343.150Africa/Addis_Ababapopulated place
343533ArgubaArghebba,ArgubaETSNNPR7.436.433330Africa/Addis_Ababapopulated place
342611Bebelī KubēETOromiya8.6666738.033330Africa/Addis_Ababapopulated place
336371GīyorgīsGiyorgis,Giyoris,Gīyorgīs,GīyorīsETOromiya7.2666739.033330Africa/Addis_Ababapopulated place
344810ĀdulalaETOromiya8.4833339.30Africa/Addis_Ababapopulated place
345766ĀbershaETAmhara12.3166738.950Africa/Addis_Ababapopulated place
336002Gonfī K’edīdaETOromiya9.5537.883330Africa/Addis_Ababapopulated place
326130Wib HāmerETSNNPR6.0666736.583330Africa/Addis_Ababapopulated place
334476IdarīETAmhara11.6166739.666670Africa/Addis_Ababapopulated place
344400ĀlaETSNNPR6.4166736.716670Africa/Addis_Ababapopulated place
330701MidijaETOromiya9.738.683330Africa/Addis_Ababapopulated place
329873Oncho HurgēsaETOromiya9.135.416670Africa/Addis_Ababapopulated place
332193LebuETOromiya8.740.60Africa/Addis_Ababapopulated place
339130DibilArcazie,DibilETAmhara13.338.266670Africa/Addis_Ababapopulated place
198563El RobaEil Roba,El RobaETSomali3.9491940.008150Africa/Addis_Ababapopulated place
341917Bo’a Ts’a’idaBo’a Ts’a’ida,Boa Tsanda,Bo’a Ts’a’idaETTigray14.3896438.564310Africa/Addis_Ababapopulated place
339931DariDari,DoriETSNNPR6.3666737.683330Africa/Addis_Ababapopulated place
332279Lalo WenjoETOromiya9.1333335.633330Africa/Addis_Ababapopulated place
336929GenetēETAmhara10.4536439.447430Africa/Addis_Ababapopulated place
341402BurdudaETSNNPR6.2166737.20Africa/Addis_Ababapopulated place
330259Mut’ī LeftuETOromiya8.8666740.450Africa/Addis_Ababapopulated place
330980MenolēETOromiya8.9333338.883330Africa/Addis_Ababapopulated place
331772MaglalaMaglala,MaglallaETĀfar14.0376640.138840Africa/Addis_Ababapopulated place
327622T’eytēETSNNPR6.1537.466670Africa/Addis_Ababapopulated place
333712JolēETSNNPR8.1833338.466670Africa/Addis_Ababapopulated place
344995Ādī Ra‘isīAddi Raisi,Adi Ra`isi,Ādī Ra‘isīETTigray13.6936739.313470Africa/Addis_Ababapopulated place
339602DeganETAmhara11.1539.90Africa/Addis_Ababapopulated place
335644GulosghiETTigray14.1333339.283330Africa/Addis_Ababapopulated place
325581ZītaETSNNPR6.6536.850Africa/Addis_Ababapopulated place
328174SongaETBīnshangul Gumuz9.834.716670Africa/Addis_Ababapopulated place
332450Kurfa Rok’aETOromiya8.5540.90Africa/Addis_Ababapopulated place
330208NanoETOromiya8.4666737.516670Africa/Addis_Ababapopulated place
341164CarrifatuETOromiya8.7833337.650Africa/Addis_Ababapopulated place
334975HaroETOromiya7.936.783330Africa/Addis_Ababapopulated place
8621039AnkarETAmhara10.530739.88630Africa/Addis_Ababapopulated place
329605RobēETOromiya9.6082739.13550Africa/Addis_Ababapopulated place
327913Tarch’a SodoETSNNPR7.1537.150Africa/Addis_Ababapopulated place
326958UgatETGambela7.9666733.60Africa/Addis_Ababapopulated place
337125Gedam Ā‘imroETOromiya9.638.50Africa/Addis_Ababapopulated place
327674T’eredaETSNNPR8.0833337.783330Africa/Addis_Ababapopulated place
331990LimitiETOromiya9.1666735.050Africa/Addis_Ababapopulated place
339082DidibeleETSomali5.6166742.350Africa/Addis_Ababapopulated place
329516RukēETSomali9.357543.164170Africa/Addis_Ababapopulated place
333784JīlaETAmhara11.2539.516670Africa/Addis_Ababapopulated place
335062HārbuETOromiya9.2166738.316670Africa/Addis_Ababapopulated place
329070Sedie MugiaMuggia,Mugia,Sedie MugiaETAmhara12.0666739.450Africa/Addis_Ababapopulated place
341056Ch’andoCh’ando,Ch’ando (1),Ch’ando,Ch’ando (1),GandoETOromiya8.4166737.166670Africa/Addis_Ababapopulated place
344322ĀlēETOromiya9.5252842.318890Africa/Addis_Ababapopulated place
342642BatīETSNNPR8.0833338.50Africa/Addis_Ababapopulated place
345301Ādī Āk’eytīAddi Akeyti,Adi Ak’eyti,Ādī Āk’eytīETTigray13.2771139.528770Africa/Addis_Ababapopulated place
334967HāroETOromiya638.550Africa/Addis_Ababapopulated place
339035Digo ‘Arb GebeyaETAmhara10.8537.733330Africa/Addis_Ababapopulated place
330770Met’k’orīyaETAmhara9.8378839.376710Africa/Addis_Ababapopulated place
335202HāloETOromiya8.5333340.550Africa/Addis_Ababapopulated place
341037Ch’at WihaCh’at Wiha,Ch’at Wina,Ch’at Wiha,Ch’at WinaETAmhara10.1632839.317020Africa/Addis_Ababapopulated place
341691BoreETOromiya4.6537.650Africa/Addis_Ababapopulated place
326495Wegel T’ēnaWegel T’ena,Wegel Tiena,Wegel Tona,Wegel T’ēnaETAmhara11.5833339.216670Africa/Addis_Ababapopulated place
340938Ch’elenk’oCh’alango,Ch’alank’o,Ch’elenk’o,Chalanco,Ch’alango,Ch’alank’o,Ch’elenk’o,Ciallanco,Ciallanko,Giallanco,GiallencoETOromiya9.4013941.560Africa/Addis_Ababapopulated place
345054Ādī K’eneyETTigray14.2745739.339340Africa/Addis_Ababapopulated place
335112Hando DīrshēHando Dirshe,Hando Dīrshē,Khando-DirsheETSomali9.7105642.882780Africa/Addis_Ababapopulated place
345863Āba SelamETAmhara10.9548239.301780Africa/Addis_Ababapopulated place
328781Sert’ēETOromiya9.6538.883330Africa/Addis_Ababapopulated place
11563611Meskerem FireETSNNPR6.7751335.650670Africa/Addis_Ababapopulated place
337429GallifagheGalifage,Gallifaghe,GalīfagēETĀfar11.3666741.350Africa/Addis_Ababapopulated place
336382GishmanETAmhara12.5833339.083330Africa/Addis_Ababapopulated place
335754GudaETOromiya9.7666738.750Africa/Addis_Ababapopulated place
325762YuboETOromiya9.138.450Africa/Addis_Ababapopulated place
329657RējīETOromiya5.738.90Africa/Addis_Ababapopulated place
327818TegorgwaTegorguo,TegorgwaETTigray13.5804539.313180Africa/Addis_Ababapopulated place
331013MengēlaETTigray14.2831939.729590Africa/Addis_Ababapopulated place
342023BiretēETOromiya9.4538.30Africa/Addis_Ababapopulated place
6533838MaawETTigray14.29939.7550Africa/Addis_Ababapopulated place
339183DeyēETOromiya9.7833338.416670Africa/Addis_Ababapopulated place
334816HāyuETOromiya9.140.533330Africa/Addis_Ababapopulated place
328928SelelkulaETAmhara11.6333338.783330Africa/Addis_Ababapopulated place
345935Āba Bora ĀgerETOromiya8.7666739.40Africa/Addis_Ababapopulated place
337541Gabri NonoETSomali9.6166743.016670Africa/Addis_Ababapopulated place
339450DembīETOromiya9.9666738.20Africa/Addis_Ababapopulated place
8597515Al’geitaETĀfar9.4745240.239130Africa/Addis_Ababapopulated place
345644Ābune ĀregayETAmhara12.937.833330Africa/Addis_Ababapopulated place
341830Boke WakoBekawaka,Beke Aba Wako,Boke WakoETOromiya7.6537.250Africa/Addis_Ababapopulated place
330023ObanghiObaghi,ObanghiETGambela7.7333333.766670Africa/Addis_Ababapopulated place
345753ĀbeyīETOromiya9.8666737.183330Africa/Addis_Ababapopulated place
342168BīfedoETOromiya9.541.750Africa/Addis_Ababapopulated place
333853JerjeroJerjero,Jerjero (2)ETAmhara11.2333339.350Africa/Addis_Ababapopulated place
328623ShemaETAmhara9.9906639.158660Africa/Addis_Ababapopulated place
334743Hiddi BirroHiddi,Hiddi BirroETOromiya5.0333339.083330Africa/Addis_Ababapopulated place
341207CamoETOromiya7.6536.933330Africa/Addis_Ababapopulated place

Exploring the Geographic Wonders of Ethiopia: A Gateway to Unmatched Data

Ethiopia, one of Africa’s most diverse and fascinating countries, offers a rich tapestry of geographical features, cultural heritage, and economic landscapes. From the rugged highlands of the north to the lowland deserts of the east, this country is a geographic marvel. But beyond its physical beauty, Ethiopia holds a wealth of data waiting to be explored, especially when it comes to its cities, regions, and departments. With the help of an extensive data database, this article invites you to take a deeper dive into the cities of Ethiopia, their administrative divisions, and geographical specifics.

A Geographical Overview of Ethiopia

Ethiopia’s geographical diversity is one of its defining characteristics. The country is landlocked, surrounded by Eritrea to the north, Djibouti and Somalia to the east, Kenya to the south, South Sudan to the west, and Sudan to the northwest. This strategic location places Ethiopia at the crossroads of the Horn of Africa, a region known for its rich history and complex political and environmental dynamics.

The Ethiopian highlands, which dominate the central and northern parts of the country, are not only stunning in their beauty but also home to Ethiopia’s largest cities, including Addis Ababa, the capital. These highlands are punctuated by deep valleys, steep cliffs, and a variety of climates ranging from temperate to tropical. The Great Rift Valley, which runs through the central part of Ethiopia, is another geological marvel, hosting unique ecosystems and diverse wildlife.

In stark contrast, the eastern and southern parts of the country feature expansive lowlands and semi-arid deserts, such as the Danakil Depression, one of the hottest and most inhospitable places on Earth. The country's vast rivers, such as the Blue Nile and the Omo River, further enhance its geographical complexity.

City Breakdown: Regions and Administrative Divisions

Ethiopia’s urban landscape is a fascinating blend of historical cities, bustling commercial hubs, and emerging industrial centers. The country’s cities are divided into regions and departments, each offering its own set of unique characteristics, cultural identities, and historical significance.

The country's administrative divisions are organized into regions (also known as states), which are further subdivided into zones, districts, and kebeles (the smallest administrative unit). These regions vary in their climate, topography, and economic focus. For instance, Addis Ababa, located in the heart of the country, is a bustling metropolis, home to the African Union and countless international organizations. In contrast, cities in the southern and western parts of Ethiopia, such as Hawassa and Gambella, offer a slower pace of life, with a focus on agriculture and natural resources.

Understanding the geographic location of these cities within their respective regions and departments is crucial for anyone seeking to engage with Ethiopia on a deeper level. Each region has a distinct administrative structure that can affect everything from business operations to educational resources and public services.

Accessing Accurate Data for Better Decision-Making

To truly understand the complexities of Ethiopia’s cities and regions, one needs access to precise and reliable data. This is where having a detailed and comprehensive database of Ethiopian cities becomes invaluable. By obtaining data about the cities, including their regions and departments, one can gain insights into the country’s administrative structure, as well as its social and economic fabric.

Additionally, geographic information such as the latitude and longitude coordinates of each city adds another layer of precision. Knowing the exact coordinates of cities is not only useful for navigation but also for mapping out potential business locations, analyzing climate patterns, and developing sustainable infrastructure projects. The database provides a treasure trove of information that can help decision-makers, researchers, and anyone interested in the geographical dynamics of Ethiopia.

The Value of Accurate Geographic Data

In a world where data drives progress, having access to detailed geographic information about Ethiopia can unlock new opportunities for development, investment, and research. By having accurate data about cities, regions, and departments, organizations can make informed decisions about resource allocation, infrastructure development, and even disaster preparedness. The more precise the data, the better the outcomes, particularly in a country as diverse and complex as Ethiopia.

Whether you’re looking to establish a business in Addis Ababa, conduct research on the agricultural systems of the Oromia region, or develop infrastructure in the Gambela department, having access to reliable geographic and administrative data is crucial. By obtaining this information, you gain not only a deeper understanding of Ethiopia’s landscape but also the ability to make decisions that are backed by solid data.

Conclusion

Ethiopia is a country of incredible geographic variety, cultural richness, and potential for growth. From the highlands to the lowlands, its cities and regions present an endless opportunity for exploration. But beyond the physical features of the land, Ethiopia’s real value lies in the data that helps to understand, navigate, and develop this complex landscape. With a detailed database of Ethiopian cities, including their latitude, longitude, and administrative divisions, you can explore the country in unprecedented detail, ensuring that every decision made is based on the most accurate and up-to-date information available.

FaQ about Ethiopia

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 5 Excel, 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 .zip archive containing the country files in Excel, 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.
Yes! We have recently updated our data packs and included the Excel (.xlsx) format, the latest Excel format. Take advantage now of 5 formats instead of 4 at no extra cost!

List of countries :

h2020-flow.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.