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

Botswana
Botswana
Excel, CSV, SQL, XML, JSON

Last update : 22 January 2026.

Country
Botswana
Capital
Gaborone
Number of cities
705
Download
Click here

This is the best list of 705 cities in the Botswana 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 Botswana file that you are going to retrieve. The data is displayed here in the form of a table:


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
7737589MogojwagojweBWNgwaketsi-25.2924625.475510Africa/Gaboronepopulated place
7573795MaitengweMaitengweBWNorth-East-20.1288927.209970Africa/Gaboronepopulated place
7889491BokhutloBWNgwaketsi-24.4167523.536450Africa/Gaboronepopulated place
7573790MengweBWNorth-East-20.0891627.179410Africa/Gaboronepopulated place
7732958ParakarunguBWNorth-West-18.035224.32410Africa/Gaboronepopulated place
7573801SeneteSeneteBWCentral-20.3256227.130160Africa/Gaboronepopulated place
7543392MulambakwenaBWNorth-East-20.5713627.460420Africa/Gaboronepopulated place
933438MakwaBWCentral-21.7438626.637620Africa/Gaboronepopulated place
7570925NshakashokweBWCentral-20.7896727.184220Africa/Gaboronepopulated place
933519LobilosBW-18.8522.650Africa/Gaboronepopulated place
7752616MmankgodiMmankgodiBWKweneng-24.7260125.649630Africa/Gaboronepopulated place
933702KakoakaBWChobe-18.6666724.366670Africa/Gaboronepopulated place
7571354MasingwanengBWNorth-East-20.8483527.325360Africa/Gaboronepopulated place
933290MookaneMookaneBWCentral-23.6880526.659482397Africa/Gaboronepopulated place
933555LetshengLechen,LetshengBWCentral-22.6638427.22392696Africa/Gaboronepopulated place
933074ShaleshantoBW-19.1523.966670Africa/Gaboronepopulated place
933084SesaloaBWCentral-21.6666725.716670Africa/Gaboronepopulated place
933391MassubiaBW-19.4166722.250Africa/Gaboronepopulated place
933058SiambizaBW-18.0166723.316670Africa/Gaboronepopulated place
933836ChuaningBWNgwaketsi-25.5524.950Africa/Gaboronepopulated place
933427MalekaoakkhomosBW-18.6522.266670Africa/Gaboronepopulated place
933394MasikeBW-19.2522.266670Africa/Gaboronepopulated place
933047SofalaBWCentral-23.0333327.466670Africa/Gaboronepopulated place
933531LikolwaloLettertree,LikolwaloBWCentral-20.524.483330Africa/Gaboronepopulated place
933055SelokolelaSelokolela,SilokwalelaBWNgwaketsi-24.949125.111010Africa/Gaboronepopulated place
933704KgagodiKakhoudi,KgagodiBWCentral-22.3799527.565180Africa/Gaboronepopulated place
933695KalkfonteinBWGhanzi-22.1166720.90Africa/Gaboronepopulated place
933184OtseOotsi,Ootsi Siding,OtseBWSouth-East-25.0166725.733336275Africa/Gaboronepopulated place
933117SebinaSebinaBWNorth-East-20.8666727.253030Africa/Gaboronepopulated place
7685727LekobaBWCentral-21.1523526.892920Africa/Gaboronepopulated place
933157PuluheloPuluhelo,Samahala’s,Samahala’sBW-19.723.683330Africa/Gaboronepopulated place
7736928DiaboBWNgwaketsi-25.1997525.365760Africa/Gaboronepopulated place
11280521PhutingBWKweneng-24.6667925.553730Africa/Gaboronepopulated place
11776146MosomaneBWKgatleng-24.0154326.316290Africa/Gaboronepopulated place
933625KitsuheleBWCentral-20.5166724.466670Africa/Gaboronepopulated place
933385MatoposaneMatepasane,MatoposaneBWCentral-22.5197827.540190Africa/Gaboronepopulated place
7764430KolokomeBWCentral-22.0400426.621760Africa/Gaboronepopulated place
933872Borakalalop CampBorakalalo Camp,Borakalalop CampBWKweneng-24.425.516670Africa/Gaboronepopulated place
933363Mena-a-KwenaBW-20.3166724.266670Africa/Gaboronepopulated place
7752436NataleNataleBWCentral-21.1027427.225610Africa/Gaboronepopulated place
7889490NyetseBWNgwaketsi-24.3050523.568920Africa/Gaboronepopulated place
7575004RamokgwengBWCentral-21.3238226.007560Africa/Gaboronepopulated place
7683653SematshwaneBWCentral-22.1886827.431680Africa/Gaboronepopulated place
933091SerokheBWCentral-23.0527.366670Africa/Gaboronepopulated place
11467688MhawanengBWCentral-22.0736928.598250Africa/Gaboronepopulated place
933787DutlweDutlwe,LuzweBWKweneng-23.9833323.91126Africa/Gaboronepopulated place
933402MasarwaBW-19.3522.833330Africa/Gaboronepopulated place
11287036NcojaneBWGhanzi-23.1338920.2950Africa/Gaboronepopulated place
933075ShakseBWCentral-22.4166726.733330Africa/Gaboronepopulated place
7663145MailaBWCentral-22.1275826.845010Africa/Gaboronepopulated place
7694657SemolaleBWCentral-21.867728.82440Africa/Gaboronepopulated place
933786DwahaBWCentral-20.9333324.650Africa/Gaboronepopulated place
933855BuitsivangoBuitsiuang,BuitsivangoBWGhanzi-21.921.383330Africa/Gaboronepopulated place
7575063MboyuBWCentral-20.0114326.923870Africa/Gaboronepopulated place
933651KhakalashweBWNgwaketsi-24.725.383330Africa/Gaboronepopulated place
933587Kudia KamBW-20.0524.70Africa/Gaboronepopulated place
7663130MabeleapodiMabeleapodi,MabeleapudiBWCentral-22.2135526.833120Africa/Gaboronepopulated place
7543403Shashe DriftBWNorth-East-20.5743327.30630Africa/Gaboronepopulated place
933264MotloutseMacloutsie,MotloutseBWCentral-21.5506827.39160Africa/Gaboronepopulated place
7688518PolokaPolokaBWCentral-21.4732426.530950Africa/Gaboronepopulated place
933515LohoklaneBWCentral-21.8833325.766670Africa/Gaboronepopulated place
7752562GakgatlaGakgatlaBWKweneng-24.5430325.617450Africa/Gaboronepopulated place
7751777MakobaeseBWCentral-21.8453226.984350Africa/Gaboronepopulated place
7751774PuongweBWCentral-21.783226.783560Africa/Gaboronepopulated place
7889036RamokapaneBWNgwaketsi-24.1635423.070240Africa/Gaboronepopulated place
11395651MmakgaboBWCentral-22.7989727.769660Africa/Gaboronepopulated place
933665KaunkwankwataBW-19.7333325.683330Africa/Gaboronepopulated place
933244MutinyaneBW-19.2666722.250Africa/Gaboronepopulated place
933271MosopaMoshupa,MosopaBWNgwaketsi-24.771825.4215619561Africa/Gaboronepopulated place
933567KwakhanaiBWGhanzi-21.7521.283330Africa/Gaboronepopulated place
933164PilanePilaneBWKgatlengKgatleng-24.4526.133331277Africa/Gaboronepopulated place
933789DumaBW-18.7522.766670Africa/Gaboronepopulated place
933192Olifants KloofBW-22.1833320.083330Africa/Gaboronepopulated place
7659514MahataneBWCentral-22.2835326.51480Africa/Gaboronepopulated place
11396022KudumatseBWCentral-23.4374227.179150Africa/Gaboronepopulated place
932975TsitleBW-23.2333325.716670Africa/Gaboronepopulated place
933133SalapitosBW-19.0166722.366670Africa/Gaboronepopulated place
933102SekomaSekomaBWNgwaketsi-24.423.883331083Africa/Gaboronepopulated place
933298MolusiBWCentral-20.424.316670Africa/Gaboronepopulated place
933211NokanengNokanen,Nokaneng,NokaningBWNorth-West-19.6666722.266671763Africa/Gaboronepopulated place
7659495MajeadinareBWCentral-22.369826.541910Africa/Gaboronepopulated place
7732954GudigwaBWNorth-West-19.369222.16170Africa/Gaboronepopulated place
933724IkwakaBW-18.922.366670Africa/Gaboronepopulated place
933008TlhapinBW-23.3166721.733330Africa/Gaboronepopulated place
933717JoaniBW-20.1333324.50Africa/Gaboronepopulated place
7571346MatengeBWNorth-East-20.8531527.262870Africa/Gaboronepopulated place
933268MosvengBWCentral-23.0333327.116670Africa/Gaboronepopulated place
7663287MohataneBWCentral-22.1120627.14110Africa/Gaboronepopulated place
7571030RamokgwebaneBWNorth-East-20.5766327.641570Africa/Gaboronepopulated place
7573787MosetseMosetseBWCentral-20.6505726.650820Africa/Gaboronepopulated place
933079ShadihadiBW-23.6333325.750Africa/Gaboronepopulated place
7659475MmokweBWCentral-22.3236126.746340Africa/Gaboronepopulated place
7575016MmaiBWCentral-21.0128126.464070Africa/Gaboronepopulated place
7847878TsetsebjweTsetsebjweBWCentral-22.4159528.397970Africa/Gaboronepopulated place
7759600SolwaneBWCentral-21.511126.682490Africa/Gaboronepopulated place
7745720LekgolobotloBWNgwaketsi-24.9092325.624980Africa/Gaboronepopulated place
933250MuhemboMohembo,MuhemboBW-18.321.80Africa/Gaboronepopulated place
7669383IsangBWSouth-East-24.6621225.92160Africa/Gaboronepopulated place
7889493MabutsaneMabutsaneBWNgwaketsi-24.3864623.574860Africa/Gaboronepopulated place
7570751TotengTotengBWNorth-East-20.7634627.250540Africa/Gaboronepopulated place

Exploring Botswana: A Geographical Insight and Data Resource

Botswana’s Geography: The Heart of Southern Africa

Botswana, a landlocked country in Southern Africa, is often praised for its diverse geography, which features vast deserts, sprawling savannahs, and rich wildlife. Covering about 581,730 square kilometers, Botswana is bordered by Namibia to the north and west, Zambia to the north, Zimbabwe to the northeast, and South Africa to the south and southeast. The country is primarily known for the Kalahari Desert, which covers much of its interior, and the Okavango Delta, one of the largest inland deltas in the world, which sustains a wide range of biodiversity and attracts ecotourists from across the globe.

The country’s diverse landscapes—from arid zones to lush wetlands—directly influence the distribution of its population, wildlife, and industries. Botswana’s climatic conditions vary widely: the north experiences a subtropical climate, while the rest of the country is dominated by a semi-arid climate. These differences significantly affect settlement patterns, agriculture, and water resource management. My geographic database on Botswana includes key information about the cities, regions, and departments, including latitude and longitude data for each location, offering a thorough understanding of the country's spatial organization.

Botswana’s Regions and Urban Areas: A Unique Blend of Urbanization and Wilderness

Botswana’s administrative structure is divided into several regions, known as districts, which are further subdivided into smaller towns and settlements. Gaborone, the capital and largest city, is located in the southeastern part of the country, near the border with South Africa. Gaborone is the economic and political heart of Botswana, serving as the country’s main commercial center, transportation hub, and governmental seat. Despite being a relatively small city, Gaborone plays a significant role in driving the country’s development, particularly in the areas of trade, finance, and services.

Other major cities in Botswana include Francistown, which lies to the northeast and serves as the second-largest city. Historically, Francistown grew as a mining town and remains a key center for industrial activities. It is a commercial hub for the eastern region of Botswana and has been seeing increasing development in recent years.

Molepolole, a town located in the Kweneng District, has grown significantly as a regional center, while smaller towns like Maun, which sits on the edge of the Okavango Delta, cater primarily to tourism and conservation activities. Maun is known as the gateway to the delta, making it an important area for the country's tourism industry.

Through my geographic database, users can access detailed data on the cities and regions of Botswana, including precise latitude and longitude coordinates for each location. This data helps to visualize how urbanization and natural features are distributed across the country and how they interact with one another.

Latitude and Longitude: Mapping Botswana’s Cities and Regions

Latitude and longitude coordinates are essential for understanding the precise location of cities and towns in Botswana. These geographic tools allow for an accurate representation of how the country’s urban centers are distributed and how they relate to the natural environment, especially the expansive Kalahari Desert and the Okavango Delta.

For example, Gaborone, located at approximately 24.6° S latitude and 25.9° E longitude, is situated near the southern border with South Africa, making it a strategic location for trade and commerce. In contrast, Maun, positioned much further north, closer to the Okavango Delta, plays a different role in Botswana’s economy, with a focus on tourism and conservation.

By using precise latitude and longitude data, users can analyze how geography influences settlement patterns and infrastructure. The geographic database I’ve created includes these coordinates for every major city, town, and region in Botswana, enabling a deeper understanding of the spatial dynamics within the country.

Geographical Features and Their Impact on Botswana’s Economy and Infrastructure

Botswana’s geographical features significantly influence its economic activities. The Kalahari Desert, covering much of the country’s interior, presents challenges for agriculture and water supply, while the Okavango Delta provides ample resources for eco-tourism and wildlife conservation. The country’s geographic location has also shaped its infrastructure and trade routes, particularly through the capital, Gaborone, and the city of Francistown.

Botswana’s infrastructure is largely concentrated in the south, where most of the population resides. Gaborone, as the central hub for industry, trade, and government, has well-developed roads, communication systems, and energy supply networks. However, the vast distances and the sparsely populated regions in the north and central parts of the country present challenges for connectivity and infrastructure development.

The geographic database helps to map these infrastructure developments, including transportation links, energy grids, and water supply systems, providing insights into how the geography of Botswana impacts its economic growth. This data allows for more informed decision-making in urban planning, infrastructure projects, and resource management, ensuring that the country’s growth is sustainable and inclusive.

Tourism and Conservation: The Geography of Botswana’s Natural Wonders

Botswana is world-renowned for its natural beauty, including the Okavango Delta, the Chobe National Park, and the Makgadikgadi Salt Pans. These areas are crucial to Botswana’s tourism sector, which contributes significantly to the national economy. The Okavango Delta, in particular, is a UNESCO World Heritage Site and one of the most biologically rich areas on the planet, attracting thousands of tourists every year for safaris, birdwatching, and other ecotourism activities.

The country’s commitment to conservation and wildlife protection is directly tied to its geographic features. The delta, along with other national parks and protected areas, serves as a sanctuary for diverse species, including elephants, lions, and various bird species. The geographic database provides valuable data on these natural areas, including their location and proximity to urban centers, offering insights into how tourism and conservation efforts can be balanced with the needs of local communities and the environment.

By providing detailed geographic data on Botswana’s national parks, game reserves, and wildlife corridors, the database allows users to analyze the spatial relationships between human settlements, protected areas, and tourism hotspots. This data helps inform policies related to conservation, land use, and eco-tourism, ensuring that Botswana’s natural wonders continue to thrive for future generations.

The Role of Geographic Data in Botswana’s Sustainable Development

As Botswana continues to develop, geographic data plays a crucial role in ensuring that growth is sustainable and balanced. The country’s reliance on natural resources, particularly in the agricultural, tourism, and mining sectors, requires careful management of land, water, and energy resources. Geographic data helps to map these resources and assess how they can be utilized efficiently while minimizing environmental impact.

For instance, the geographic database I have developed can be used to track the availability of water sources, agricultural lands, and wildlife habitats, helping policymakers plan for future growth and resource management. It also enables the monitoring of climate change impacts, such as shifts in rainfall patterns or temperature increases, which may affect agriculture and biodiversity.

By providing accurate geographic data on all major cities, towns, and regions in Botswana, the database supports sustainable planning for the country’s future. It helps identify areas in need of development or conservation and provides valuable insights into how geography influences economic and environmental policies.

Conclusion: Unlocking Botswana’s Geographic Potential with Data

Botswana’s diverse geography, from its vast deserts to its lush wetlands, plays a fundamental role in shaping the country’s economy, culture, and urban development. The geographic database I have created, which includes precise latitude and longitude data for each city, region, and department, offers valuable insights into how these geographical features influence Botswana’s growth. This data is crucial for informed decision-making in urban planning, resource management, tourism, and conservation, ensuring that Botswana continues to thrive as a dynamic and sustainable nation in the heart of Southern Africa.

FaQ about Botswana

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.