Malawi cities list with latitude and longitude in CSV format
Malawi
CSV, SQL, XML, JSON
Last update : 18 September 2024.
This is the best list of 7873 cities in the Malawi 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 Malawi file that you are going to retrieve. The data is displayed here in the form of a table:
Geoname_ID | City | Alternate_Name | Country_Code | Region | Sub_region | Latitude | Longitude | Elevation | Population | Timezone | Fcode_Name |
---|---|---|---|---|---|---|---|---|---|---|---|
929618 | Jere | MW | Central Region | Kasungu District | -12.63333 | 33.4 | 0 | Africa/Blantyre | populated place | ||
926710 | Mdzace | MW | Southern Region | Chikwawa District | -16.11667 | 34.6 | 0 | Africa/Blantyre | populated place | ||
12177802 | Vuta Chipeta | Vuta Chipeta | MW | Northern Region | Mzimba District | -11.90235 | 33.34076 | 0 | Africa/Blantyre | populated place | |
930662 | Chipasi | MW | Central Region | Dedza District | -14.29971 | 34.27613 | 0 | Africa/Blantyre | populated place | ||
925023 | Ndeka | Ndeka | MW | Central Region | Dowa District | -13.28122 | 33.61636 | 0 | Africa/Blantyre | populated place | |
12170111 | Malamula | Malamula | MW | Northern Region | Chitipa District | -9.81593 | 33.57619 | 0 | Africa/Blantyre | populated place | |
12177713 | Yakobe Chisi | Yakobe Chisi | MW | Northern Region | Mzimba District | -11.44155 | 33.9211 | 0 | Africa/Blantyre | populated place | |
12183269 | Sunama | Sunama | MW | Central Region | Mchinji District | -13.45101 | 33.01602 | 0 | Africa/Blantyre | populated place | |
931677 | Bwala | MW | Central Region | Nkhotakota District | -13.31667 | 34.11667 | 0 | Africa/Blantyre | populated place | ||
931086 | Chikusa | Chikusa | MW | Central Region | Lilongwe District | -13.87289 | 33.3687 | 0 | Africa/Blantyre | populated place | |
925599 | Mfwanyota | Mfwanyota,Mwanyota | MW | Central Region | Kasungu District | -12.57633 | 33.4158 | 0 | Africa/Blantyre | populated place | |
12185122 | Katumbi | Katumbi | MW | Central Region | Dowa District | -13.68322 | 33.48953 | 0 | Africa/Blantyre | populated place | |
12170280 | Timothy Kaira One | Timothy Kaira I,Timothy Kaira One | MW | Northern Region | Chitipa District | -10.14392 | 33.56845 | 0 | Africa/Blantyre | populated place | |
930853 | Chimwala | MW | Central Region | Lilongwe District | -14.00201 | 33.48271 | 0 | Africa/Blantyre | populated place | ||
235739 | Fundi | MW | Central Region | Kasungu District | -9.73333 | 33.91667 | 0 | Africa/Blantyre | populated place | ||
931499 | Chamawoya | Chamawoya | MW | Northern Region | Nkhata Bay District | -11.52561 | 34.08254 | 0 | Africa/Blantyre | populated place | |
928345 | Kawale | MW | Northern Region | Mzimba District | -12.7 | 33.66667 | 0 | Africa/Blantyre | populated place | ||
923731 | Tengani | MW | Southern Region | Nsanje District | -16.73333 | 35.26667 | 0 | Africa/Blantyre | populated place | ||
928802 | Kaodzela | Kaodzela | MW | Central Region | Lilongwe District | -13.64929 | 33.43275 | 0 | Africa/Blantyre | populated place | |
12185119 | Chinzili | Chinzili | MW | Central Region | Dowa District | -13.63996 | 33.49443 | 0 | Africa/Blantyre | populated place | |
927387 | Malavi | MW | Central Region | Lilongwe District | -13.71667 | 33.7 | 0 | Africa/Blantyre | populated place | ||
923686 | Thomas | MW | Southern Region | Chikwawa District | -16.08333 | 34.55 | 0 | Africa/Blantyre | populated place | ||
12183009 | Kanyika | Kanyika | MW | Northern Region | Mzimba District | -12.70948 | 33.65818 | 0 | Africa/Blantyre | populated place | |
926286 | Mowere | MW | Southern Region | Machinga District | -14.75 | 35.65 | 0 | Africa/Blantyre | populated place | ||
12185331 | Champhenzi | Champhenzi | MW | Central Region | Lilongwe District | -13.87421 | 33.39088 | 0 | Africa/Blantyre | populated place | |
925012 | Ndembo | Ndembo | MW | Central Region | Dowa District | -13.42037 | 33.69169 | 0 | Africa/Blantyre | populated place | |
923488 | Sitonya Vinkhumbu | Sitonya Vinkhumbu,Vinkhumbo | MW | Northern Region | Mzimba District | -11.92842 | 33.42914 | 0 | Africa/Blantyre | populated place | |
12177809 | Mdachi Nyirenda | Mdachi Nyirenda | MW | Northern Region | Mzimba District | -11.95402 | 33.36748 | 0 | Africa/Blantyre | populated place | |
931272 | Chibwana | MW | Northern Region | Mzimba District | -12.16667 | 33.68333 | 0 | Africa/Blantyre | populated place | ||
930748 | Chinkwiri | Chinkwiri | MW | Central Region | Dowa District | -13.37733 | 33.74224 | 0 | Africa/Blantyre | populated place | |
923838 | Songo | MW | Southern Region | Zomba District | -15.41667 | 35.33333 | 0 | Africa/Blantyre | populated place | ||
12170649 | Chikulamasinda | Chikulamasinda | MW | Northern Region | Rumphi District | -10.93411 | 33.67195 | 0 | Africa/Blantyre | populated place | |
924477 | Nthambwe | Nthambwe | MW | Central Region | Dowa District | -13.66866 | 33.81056 | 0 | Africa/Blantyre | populated place | |
926752 | Mchenga | Mchenga,Mchinga | MW | Central Region | Kasungu District | -13.19495 | 33.56873 | 0 | Africa/Blantyre | populated place | |
927620 | Madimba Mana | MW | Northern Region | Likoma District | -12.05 | 34.75 | 0 | Africa/Blantyre | populated place | ||
930710 | Chinyamunyamu | MW | Central Region | Kasungu District | -13.06667 | 33.43333 | 0 | Africa/Blantyre | populated place | ||
12177960 | Bayane Munyenyembe | Bayane Munyenyembe | MW | Northern Region | Mzimba District | -11.70211 | 33.73186 | 0 | Africa/Blantyre | populated place | |
930316 | Chizangwe | MW | Central Region | Nkhotakota District | -13.2 | 34.31667 | 0 | Africa/Blantyre | populated place | ||
12182297 | Mudoka | Mudoka | MW | Northern Region | Karonga District | -10.27359 | 34.13662 | 0 | Africa/Blantyre | populated place | |
12185240 | Yotamu | Yotamu | MW | Central Region | Lilongwe District | -13.86436 | 33.30114 | 0 | Africa/Blantyre | populated place | |
929069 | Kampambe | Kampambe | MW | Central Region | Lilongwe District | -13.91105 | 33.7878 | 0 | Africa/Blantyre | populated place | |
924002 | Sanjama | MW | Southern Region | Chikwawa District | -16.28333 | 34.91667 | 0 | Africa/Blantyre | populated place | ||
930257 | Chopi | MW | Southern Region | Zomba District | -15.35 | 35.4 | 0 | Africa/Blantyre | populated place | ||
12182513 | Mbenuka Nyirenda | Mbenuka Nyirenda | MW | Northern Region | Mzimba District | -12.10149 | 33.42505 | 0 | Africa/Blantyre | populated place | |
930705 | Chinyanya | MW | Northern Region | Likoma District | -12.05375 | 34.75361 | 0 | Africa/Blantyre | populated place | ||
931224 | Chidzunda | MW | Central Region | Lilongwe District | -13.71667 | 33.55 | 0 | Africa/Blantyre | populated place | ||
12169976 | Karongo | Karongo | MW | Northern Region | Chitipa District | -9.73179 | 33.60589 | 0 | Africa/Blantyre | populated place | |
925833 | Mtwice | MW | Southern Region | Zomba District | -15.2566 | 35.40992 | 0 | Africa/Blantyre | populated place | ||
930524 | Chisasa | Chisasa | MW | Central Region | Mchinji District | -13.40182 | 33.13624 | 0 | Africa/Blantyre | populated place | |
12185546 | Bvunguti | Bvunguti | MW | Central Region | Lilongwe District | -13.8936 | 33.75997 | 0 | Africa/Blantyre | populated place | |
928154 | Kude | MW | Central Region | Dedza District | -14.48333 | 33.7 | 0 | Africa/Blantyre | populated place | ||
12169937 | Mwangulukulu | Mwangulukulu | MW | Northern Region | Chitipa District | -9.62291 | 33.59404 | 0 | Africa/Blantyre | populated place | |
12177710 | Kamangadazi Chirwa | Kamangadazi Chirwa | MW | Northern Region | Mzimba District | -11.49507 | 33.9452 | 0 | Africa/Blantyre | populated place | |
12177823 | Bichi Chiswa Mumba | Bichi Chiswa Mumba | MW | Northern Region | Mzimba District | -11.99138 | 33.45935 | 0 | Africa/Blantyre | populated place | |
925098 | Mbuyedziko | Mbuyedziko,Nbuyedziko | MW | Central Region | Ntchisi District | -13.37281 | 33.80699 | 0 | Africa/Blantyre | populated place | |
929278 | Kalelo | MW | Central Region | Dedza District | -14.31667 | 34 | 0 | Africa/Blantyre | populated place | ||
12185013 | Mtulira | Mtulira | MW | Central Region | Mchinji District | -13.58657 | 33.06775 | 0 | Africa/Blantyre | populated place | |
12177498 | Khuyu | Khuyu | MW | Northern Region | Mzimba District | -11.17108 | 33.70232 | 0 | Africa/Blantyre | populated place | |
931061 | Chikwina | MW | Northern Region | Nkhata Bay District | -11.39792 | 34.17239 | 0 | Africa/Blantyre | populated place | ||
924724 | Nkhoma | Nkhoma | MW | Central Region | Kasungu District | -12.71861 | 33.39782 | 0 | Africa/Blantyre | populated place | |
12177499 | Alifeyo Nyasulu | Alifeyo Nyasulu | MW | Northern Region | Mzimba District | -11.16528 | 33.70171 | 0 | Africa/Blantyre | populated place | |
931919 | Abel Chunga | Abel Chunga | MW | Northern Region | Mzimba District | -12.16747 | 33.49184 | 0 | Africa/Blantyre | populated place | |
931659 | Cabwedzeka | MW | Southern Region | Chikwawa District | -16.11667 | 34.6 | 0 | Africa/Blantyre | populated place | ||
923931 | Seza | MW | Central Region | Ntchisi District | -13.26667 | 33.83333 | 0 | Africa/Blantyre | populated place | ||
12185382 | Khombe | Khombe | MW | Central Region | Lilongwe District | -13.77537 | 33.43102 | 0 | Africa/Blantyre | populated place | |
926502 | Mkanje | MW | Central Region | Salima District | -13.45 | 34.31667 | 0 | Africa/Blantyre | populated place | ||
12182755 | Kapita | Kapita | MW | Northern Region | Mzimba District | -12.4507 | 33.85306 | 0 | Africa/Blantyre | populated place | |
926450 | Mkule | MW | Central Region | Lilongwe District | -14.1 | 33.78333 | 0 | Africa/Blantyre | populated place | ||
12177743 | Doroba | Doroba | MW | Northern Region | Mzimba District | -11.3587 | 33.94961 | 0 | Africa/Blantyre | populated place | |
931732 | Bongwe | MW | Southern Region | Zomba District | -15.45 | 35.41667 | 0 | Africa/Blantyre | populated place | ||
12185710 | Chinkhota | Chinkhota | MW | Central Region | Lilongwe District | -13.84057 | 33.80994 | 0 | Africa/Blantyre | populated place | |
12177945 | Sasa | Sasa | MW | Northern Region | Mzimba District | -11.585 | 33.56098 | 0 | Africa/Blantyre | populated place | |
12185696 | Themu | Themu | MW | Central Region | Lilongwe District | -13.7973 | 33.96756 | 0 | Africa/Blantyre | populated place | |
931122 | Chikomeni Thole | Chikomeni Thole,Chikomeni Thore | MW | Northern Region | Mzimba District | -12.09762 | 33.52977 | 0 | Africa/Blantyre | populated place | |
12185199 | Kapiko | Kapiko | MW | Central Region | Mchinji District | -13.94689 | 33.23636 | 0 | Africa/Blantyre | populated place | |
12182776 | Kavidzinde | Kavidzinde | MW | Central Region | Kasungu District | -12.62841 | 33.33012 | 0 | Africa/Blantyre | populated place | |
12177894 | Chingati Chirwa | Chingati Chirwa | MW | Northern Region | Mzimba District | -11.92597 | 33.48055 | 0 | Africa/Blantyre | populated place | |
12178028 | Jeremiya Shumba | Jeremiya Shumba | MW | Northern Region | Mzimba District | -11.99647 | 33.54725 | 0 | Africa/Blantyre | populated place | |
12183359 | Mnkholwe | Mnkholwe | MW | Central Region | Kasungu District | -13.26569 | 33.37394 | 0 | Africa/Blantyre | populated place | |
931755 | Blantyre | BLZ,Blantair,Blantairas,Blantajer,Blantajr,Blantajur,Blantire,Blantjiro,Blantyre,Blantyre-Limbe,Kapeni,beullaentaieo,blamtayara,blantayr,blantayr malawy,blantyyr,blntyyr,bu lan tai er,burantaiya,Μπλαντάιρ,Блантайр,Блантайър,Блантајер,בלנטייר,بلانتاير,بلانتایر، مالاوی,بلانتیئر,ब्लँटायर,ブランタイヤ,布兰太尔,블랜타이어 | MW | Southern Region | Blantyre District | -15.78499 | 35.00854 | 584877 | Africa/Blantyre | seat of a first-order administrative division | |
925866 | Mtongola | MW | Central Region | Lilongwe District | -13.90434 | 33.31126 | 0 | Africa/Blantyre | populated place | ||
12170609 | Thazima | Thazima | MW | Northern Region | Rumphi District | -10.82865 | 33.59455 | 0 | Africa/Blantyre | populated place | |
923574 | Tsonga | Tsonga | MW | Central Region | Ntchisi District | -13.44659 | 33.85364 | 0 | Africa/Blantyre | populated place | |
923793 | Suwila | MW | Central Region | Kasungu District | -13.03333 | 33.55 | 0 | Africa/Blantyre | populated place | ||
926151 | Mphola | MW | Central Region | Ntcheu District | -14.66758 | 34.81522 | 0 | Africa/Blantyre | populated place | ||
12185165 | Kambanda | Kambanda | MW | Central Region | Mchinji District | -13.91083 | 33.2157 | 0 | Africa/Blantyre | populated place | |
12185438 | Nakhulu | Nakhulu | MW | Central Region | Dowa District | -13.58171 | 33.58299 | 0 | Africa/Blantyre | populated place | |
931364 | Chautala Msiska | Chautala Msiska,Chautela | MW | Northern Region | Rumphi District | -10.66786 | 34.07223 | 0 | Africa/Blantyre | populated place | |
928206 | Khwere | Khwere,Kware | MW | Central Region | Mchinji District | -13.49638 | 33.09737 | 0 | Africa/Blantyre | populated place | |
929550 | Juwaki | Juwaki,Makhanga | MW | Southern Region | Nsanje District | -16.49819 | 35.20621 | 0 | Africa/Blantyre | populated place | |
929027 | Kamteteka | Kamteteka | MW | Northern Region | Mzimba District | -11.78973 | 33.35464 | 0 | Africa/Blantyre | populated place | |
928504 | Katambo | MW | Central Region | Salima District | -13.76667 | 34.41667 | 0 | Africa/Blantyre | populated place | ||
924361 | Nyampalu | MW | Southern Region | Phalombe District | -15.82511 | 35.60505 | 0 | Africa/Blantyre | populated place | ||
923715 | Tewesya | MW | Central Region | Dedza District | -14.20485 | 34.253 | 0 | Africa/Blantyre | populated place | ||
8478232 | Chikupizga Village | MW | Northern Region | Rumphi District | -10.92414 | 33.63067 | 50 | Africa/Blantyre | populated place | ||
924933 | Ngawo | MW | Southern Region | Mangochi District | -14.61667 | 35.46667 | 0 | Africa/Blantyre | populated place | ||
930238 | Chinganilo | Chinganilo,Chunganiro | MW | Central Region | Ntchisi District | -13.32332 | 33.91391 | 0 | Africa/Blantyre | populated place | |
930593 | Chipwaila | Chipwaila | MW | Northern Region | Nkhata Bay District | -11.56376 | 34.13073 | 0 | Africa/Blantyre | populated place | |
924030 | Samuel Mphepo | Samuel Mphepo | MW | Northern Region | Mzimba District | -11.7622 | 33.71796 | 0 | Africa/Blantyre | populated place | |
12185552 | Kalonga | Kalonga | MW | Central Region | Lilongwe District | -13.9163 | 33.77259 | 0 | Africa/Blantyre | populated place |
FaQ about Malawi
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