Turkey cities list with latitude and longitude in CSV format
Turkey
CSV, SQL, XML, JSON
Last update : 18 September 2024.
This is the best list of 50332 cities in the Turkey 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 Turkey 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 |
---|---|---|---|---|---|---|---|---|---|---|---|
10409524 | Dereyurt | Dereyurt | TR | Ordu | 40.92081 | 37.58028 | 0 | Europe/Istanbul | populated place | ||
752782 | Ağılcık | Agilcik,Ağılcık | TR | Ankara | 40.22558 | 32.98389 | 0 | Europe/Istanbul | populated place | ||
745916 | Hamzafakılı | Hamza Fakihli,Hamza Fakil,Hamza Fakıhlı,Hamzafakili,Hamzafakılı,Hamzafikili,Hamzafıkılı,Vakiflar,Vakıflar | TR | Zonguldak | 41.22083 | 31.45351 | 0 | Europe/Istanbul | populated place | ||
749217 | Çevreli | Cevreli,Muhat,Mukhat,Çevreli,Мухат | TR | Tokat | 40.29694 | 36.85639 | 0 | Europe/Istanbul | populated place | ||
8140811 | Dip | TR | Düzce | 40.77358 | 31.36743 | 0 | Europe/Istanbul | populated place | |||
740892 | Erenler | Erenler,Osekkoy,Öşekköy | TR | Kastamonu | 41.83333 | 33.92691 | 0 | Europe/Istanbul | populated place | ||
7591493 | Bölükdamlar | Bolukdamlar,Bölükdamlar | TR | Kahramanmaraş | 37.66353 | 37.31876 | 0 | Europe/Istanbul | populated place | ||
310844 | Kahyalı | Kahyali,Kahyalı | TR | Malatya | 38.3334 | 37.80043 | 0 | Europe/Istanbul | populated place | ||
7554982 | Subaşı | Subasi,Subaşı | TR | Rize Province | 41.14714 | 40.84325 | 0 | Europe/Istanbul | populated place | ||
741312 | Nebiyurdu | Nabiyurt,Nebiyurdu | TR | Kars Province | 40.31667 | 43.26667 | 0 | Europe/Istanbul | populated place | ||
740576 | Pınarca | TR | Tekirdağ | 41.34029 | 28.02181 | 0 | Europe/Istanbul | populated place | |||
8539024 | Yukarı Kuyubaşı | TR | Burdur | 37.37552 | 30.65407 | 0 | Europe/Istanbul | populated place | |||
310467 | Kapılı | Kapali,Kapalı,Kapili,Kapılı,Kokit,Kukit,Kyukit,Kökit,Kükit | TR | Şırnak | 37.16457 | 42.57921 | 393 | Europe/Istanbul | populated place | ||
742595 | Kuşkayası | TR | Samsun | 41.40719 | 35.99357 | 0 | Europe/Istanbul | populated place | |||
437923 | Menteşe | Mentese,Menteşe | TR | Hatay | 36.60972 | 36.315 | 0 | Europe/Istanbul | populated place | ||
324355 | Akyürek | Akyurek,Akyürek | TR | Elazığ | 38.60234 | 39.91737 | 0 | Europe/Istanbul | populated place | ||
9888396 | Alabaş | Alabas,Alabaş | TR | İzmir Province | 38.19257 | 27.85638 | 0 | Europe/Istanbul | populated place | ||
744368 | Kedikaya | Kedikaya,Tekkekoy,Tekkeköy | TR | Bursa Province | 40.29212 | 28.3203 | 0 | Europe/Istanbul | populated place | ||
8229896 | Kıyır | Kiyir,Kıyır | TR | Afyonkarahisar Province | 39.03499 | 30.68935 | 0 | Europe/Istanbul | populated place | ||
306063 | Kozluca | TR | Nevşehir Province | 38.6114 | 34.40246 | 0 | Europe/Istanbul | populated place | |||
746860 | Göçerler | Gocerler,Göçerler | TR | Tekirdağ | 41.33531 | 27.74046 | 0 | Europe/Istanbul | populated place | ||
320614 | Bozköy | Bozkoy,Bozköy,Kelemis,Kelemiş | TR | Niğde Province | 38.23669 | 34.48395 | 0 | Europe/Istanbul | populated place | ||
297151 | Yenice | Yenice | TR | Ankara | 39.38006 | 31.99512 | 0 | Europe/Istanbul | populated place | ||
9888107 | Çamoba | Camoba,Çamoba | TR | İzmir Province | 39.25366 | 27.3932 | 0 | Europe/Istanbul | populated place | ||
319382 | Kötekler | Cariklar,Cariklaryaylasi,Kotekler,Kötekler,Çarıklar,Çarıklaryaylası | TR | Mersin | 36.37434 | 33.01285 | 0 | Europe/Istanbul | populated place | ||
300571 | Esenburun | Esenburun,Sizor | TR | Bitlis | 38.23322 | 41.9932 | 0 | Europe/Istanbul | populated place | ||
747375 | Esbiye | Esbiye,Espiye | TR | Giresun | 40.95 | 38.73333 | 0 | Europe/Istanbul | populated place | ||
752024 | Aluç | TR | Kastamonu | 41.08333 | 33.66667 | 0 | Europe/Istanbul | populated place | |||
299649 | Taşteker | Tasteker,Taşteker,Uckilise,Uçkilise | TR | Ağrı | 39.61194 | 43.51722 | 0 | Europe/Istanbul | populated place | ||
8522451 | Semerici | Semerici | TR | Bursa Province | 39.7704 | 29.00044 | 0 | Europe/Istanbul | populated place | ||
307640 | Kırım | Kirim,Kırım | TR | Diyarbakır Province | 38.37763 | 40.44994 | 0 | Europe/Istanbul | populated place | ||
7548904 | Yeşiltepe | Yesiltepe,Yeşiltepe | TR | Trabzon | 40.95823 | 39.62785 | 0 | Europe/Istanbul | populated place | ||
319179 | Çavdar | Cavdar,Cavdarkoy,Çavdar,Çavdarköy | TR | Aydın | 37.5975 | 27.64278 | 0 | Europe/Istanbul | populated place | ||
323512 | Arslanlı | Arslanli,Arslanli Koyu,Arslanlı,Arslanlı Köyü,Aslanli,Aslanlı,Karalarozu,Karalarözü | TR | Adana | 37.31667 | 35.76667 | 0 | Europe/Istanbul | populated place | ||
10870105 | Halitağlar | Halitaglar,Halitağlar | TR | Osmaniye | 37.34841 | 36.03723 | 0 | Europe/Istanbul | populated place | ||
318734 | Çınaroba | Cetme,Cinaroba,Çetme,Çınaroba | TR | Konya | 38.17027 | 31.6407 | 0 | Europe/Istanbul | populated place | ||
302348 | Anıtçınar | Anitcinar,Anıtçınar,Ricik,Riçik | TR | Tunceli | 38.97573 | 39.84646 | 0 | Europe/Istanbul | populated place | ||
741703 | Maraşal Fevzi Çakmak | Marasal Fevzi Cakmak,Maraşal Fevzi Çakmak,Mazilik,Mazılık | TR | Canakkale | 40.12893 | 26.57587 | 0 | Europe/Istanbul | populated place | ||
303740 | Oba | Oba,Yukari Oba,Yukarimerbant,Yukary-Merkhant,Yukarı Oba,Yukarımerbant | TR | Diyarbakır Province | 37.7825 | 40.88833 | 0 | Europe/Istanbul | populated place | ||
317783 | Gülyayla | Bagboymul,Bağboymul,Dagboymulu,Dagboyumlu,Dağboymulu,Dağboyumlu,Gulyayla,Gülyayla | TR | Yozgat | 39.93061 | 34.61653 | 0 | Europe/Istanbul | populated place | ||
7465579 | Muratbağı | Muratbagi,Muratbağı | TR | Elazığ | 38.64558 | 39.73378 | 0 | Europe/Istanbul | populated place | ||
323123 | Asarcı | TR | Denizli | 37.33333 | 29.3 | 0 | Europe/Istanbul | populated place | |||
10046449 | Kıyık | Kiyik,Kıyık | TR | Muş | 38.83488 | 41.45654 | 0 | Europe/Istanbul | populated place | ||
10306804 | Bulgur | Bulgur | TR | Tekirdağ | 40.74364 | 27.14078 | 0 | Europe/Istanbul | populated place | ||
313863 | Gözeler | Aynihalil,Aynykhalil’,Aynykhalil’,Gozelen,Gozeler,Gözelen,Gözeler | TR | Şanlıurfa | 37.00013 | 39.02945 | 0 | Europe/Istanbul | populated place | ||
10354332 | Yeşilköy | Yesilkoy,Yeşilköy | TR | Elazığ | 38.79283 | 39.92401 | 0 | Europe/Istanbul | populated place | ||
740933 | Sarpun | Ortakoy,Ortaköy,Sarpun | TR | Kastamonu | 41.70016 | 34.28096 | 0 | Europe/Istanbul | populated place | ||
301721 | Sarıhalil | Sarihalil,Sarıhalil | TR | Ankara | 39.42444 | 32.25306 | 0 | Europe/Istanbul | populated place | ||
750555 | Illıcaboğaz | Bogaz,Boğaz,Illicabogaz,Illıcaboğaz | TR | Balıkesir | 40.09432 | 28.13528 | 0 | Europe/Istanbul | populated place | ||
745957 | Hamamlı | Hamamli,Hamamlı | TR | Sinop | 41.92687 | 34.34295 | 0 | Europe/Istanbul | populated place | ||
322302 | Bahtiyar | TR | Sivas | 39.24052 | 37.99361 | 0 | Europe/Istanbul | populated place | |||
10014800 | Toklar | Toklar | TR | Kütahya | 39.41837 | 29.00268 | 0 | Europe/Istanbul | populated place | ||
749743 | Meyveli | Canpet,Meyvali,Meyveli,Çanpet | TR | Rize Province | 41.2057 | 41.15427 | 0 | Europe/Istanbul | populated place | ||
743263 | Uluağaç | TR | Bartın | 41.66749 | 32.71559 | 0 | Europe/Istanbul | populated place | |||
10014961 | Küçükköy | Kucukkoy,Küçükköy | TR | Giresun | 40.84771 | 38.66919 | 0 | Europe/Istanbul | populated place | ||
6970839 | Öztoprak | Oztoprak,Öztoprak | TR | Ağrı | 39.71892 | 42.76475 | 0 | Europe/Istanbul | populated place | ||
739258 | Sülükgölü | Sulukgolu,Sulukgolu Koyu,Sülükgölü,Sülükgölü Köyü | TR | Çorum | 40.72009 | 34.08052 | 0 | Europe/Istanbul | populated place | ||
745682 | Haznedar | Hazinedar,Haznedar,Haznedar Mahalle | TR | Kars Province | 40.11986 | 43.1417 | 0 | Europe/Istanbul | populated place | ||
313247 | Güzelçay | Guzelcay,Güzelçay | TR | Adıyaman Province | 37.69743 | 38.67552 | 0 | Europe/Istanbul | populated place | ||
7756265 | Yağmurlu Sayobası | Yagmurlu Sayobasi,Yagmursayobasi,Yağmurlu Sayobası,Yağmursayobası | TR | Kırşehir | 39.24018 | 33.91892 | 0 | Europe/Istanbul | populated place | ||
740131 | İçyaka | Icyaka,Sarica,Sarıca,İçyaka | TR | Ordu | 40.72866 | 37.6463 | 0 | Europe/Istanbul | populated place | ||
304180 | Hacımahmut | Hacimahmut,Hacımahmut,Kanakilise,Muhacirkarakilise | TR | Erzurum | 39.80374 | 40.72335 | 0 | Europe/Istanbul | populated place | ||
308754 | Kavalcık | Kavalcik,Kavalcık | TR | Hatay | 36.22824 | 36.61062 | 0 | Europe/Istanbul | populated place | ||
303977 | Havacılar | Havacilar,Havacılar,Nahirkiraci,Nahırkıracı,Sarabi,Şarabi | TR | Diyarbakır Province | 37.99635 | 40.27943 | 0 | Europe/Istanbul | populated place | ||
305736 | Yeşilyurt | Kulunce,Kyulyundzhe,Külünce,Yesilyurt,Yeşilyurt | TR | Şanlıurfa | 37.19045 | 39.07839 | 0 | Europe/Istanbul | populated place | ||
737707 | Yeniceli | Yenice,Yeniceli | TR | Kırıkkale | 40.18333 | 33.86667 | 0 | Europe/Istanbul | populated place | ||
738514 | Üçkese | TR | Düzce | 40.90799 | 31.2985 | 0 | Europe/Istanbul | populated place | |||
746410 | Gümüşpınar | Gumuspinar,Gümüşpınar,Koramaz | TR | Ankara | 40.12084 | 33.45501 | 0 | Europe/Istanbul | populated place | ||
323985 | Alkayaoğlu | TR | Kahramanmaraş | 38.53433 | 37.09005 | 0 | Europe/Istanbul | populated place | |||
741993 | Kutlu | Kutlu,Kutlukoy,Kutluköy,Sinezi | TR | Amasya | 40.81129 | 35.71317 | 0 | Europe/Istanbul | populated place | ||
8142913 | Karadere | TR | Düzce | 40.83796 | 31.07055 | 0 | Europe/Istanbul | populated place | |||
310092 | Karacaören | Karacaoren,Karacaören | TR | Muğla | 36.82026 | 29.00051 | 0 | Europe/Istanbul | populated place | ||
310031 | Karacaviran | TR | 39.93333 | 39.55 | 0 | Europe/Istanbul | populated place | ||||
6984496 | Aşağı Karaboy | Asagi Karaboy,Asagikaraboy,Aşağı Karaboy,Aşağıkaraboy | TR | Bitlis | 38.46737 | 41.96542 | 0 | Europe/Istanbul | populated place | ||
752168 | Alçakdere | Alcakdere,Alçakdere | TR | Gümüşhane Province | 40.61226 | 40.00473 | 0 | Europe/Istanbul | populated place | ||
299247 | Terziler | TR | Isparta | 37.75554 | 31.16113 | 0 | Europe/Istanbul | populated place | |||
304726 | Mazmanlı | Kazmanli,Kazmanlı,Mazmanli,Mazmanlı | TR | Hatay | 36.66393 | 36.5254 | 0 | Europe/Istanbul | populated place | ||
750363 | Bucuk | TR | Ankara | 40.03333 | 32.46667 | 0 | Europe/Istanbul | populated place | |||
8042620 | Saka | TR | Zonguldak | 41.25926 | 31.79439 | 0 | Europe/Istanbul | populated place | |||
7624789 | Bahçe | Bahce,Bahçe | TR | Hatay | 36.16185 | 36.08497 | 0 | Europe/Istanbul | populated place | ||
737914 | Yaya | Yaya,Yayakoy,Yayaköy | TR | Canakkale | 40.02543 | 26.96154 | 0 | Europe/Istanbul | populated place | ||
752348 | Aksu | TR | Samsun | 41.35 | 36.16667 | 0 | Europe/Istanbul | populated place | |||
739797 | Yeşilköy | Yesilkoy,Yeşilköy | TR | Sakarya | 40.97288 | 30.75799 | 0 | Europe/Istanbul | populated place | ||
303188 | Osmaniye | Karahuyuk,Karahüyük,Osmanie,Osmaniye,Османие | TR | Eskişehir | 39.34056 | 30.92306 | 0 | Europe/Istanbul | populated place | ||
740699 | Paşaköy | Pasakoy,Paşaköy | TR | Istanbul | 41.01664 | 29.27859 | 0 | Europe/Istanbul | populated place | ||
7586916 | Yeşilçukur | Yesilcukur,Yeşilçukur | TR | Sivas | 40.18618 | 37.62465 | 0 | Europe/Istanbul | populated place | ||
7552994 | Büyük Çiftlikköyü | Buyuk Ciftlikkoyu,Buyukciftlik,Büyük Çiftlikköyü,Büyükçiftlik | TR | Rize Province | 40.98659 | 40.38512 | 0 | Europe/Istanbul | populated place | ||
318961 | Ekinli | Ceffan,Ekinli | TR | Siirt | 38.00448 | 41.47833 | 0 | Europe/Istanbul | populated place | ||
308520 | Kayırlı | Kayinli,Kayirli,Kayınlı,Kayırlı | TR | Niğde Province | 38.31838 | 34.5101 | 0 | Europe/Istanbul | populated place | ||
307487 | Kısık | Kisik,Kısık | TR | Uşak | 38.61644 | 28.92579 | 0 | Europe/Istanbul | populated place | ||
743354 | Kılıçlı | Kilicli,Kılıçlı | TR | Iğdır | 40.06431 | 43.53433 | 0 | Europe/Istanbul | populated place | ||
751966 | Aralık | Aralik,Aralık | TR | Sakarya | 40.79796 | 30.32993 | 0 | Europe/Istanbul | populated place | ||
746463 | Güllüce | Gulluce,Güllüce | TR | Bursa Province | 40.03243 | 28.31273 | 0 | Europe/Istanbul | populated place | ||
318382 | Çınarönü | Cilin,Cillin,Cinaronu,Cinarozu,Dzhillin,Çınarönü,Çınarözü | TR | Mardin | 37.59507 | 40.68407 | 684 | Europe/Istanbul | populated place | ||
299922 | Tahtalı | Tahtali,Tahtalı | TR | Bitlis | 38.50719 | 42.14046 | 0 | Europe/Istanbul | populated place | ||
10015206 | Işıklı | Isikli,Işıklı | TR | Trabzon | 40.92635 | 39.94879 | 0 | Europe/Istanbul | populated place | ||
8306249 | Ispatan | Ispatan | TR | Hatay | 36.64333 | 36.25903 | 0 | Europe/Istanbul | populated place | ||
7510379 | Avcılar | TR | Ardahan | 41.25134 | 42.82782 | 0 | Europe/Istanbul | populated place | |||
310047 | Karacaşar | TR | Nevşehir Province | 38.69653 | 34.57383 | 0 | Europe/Istanbul | populated place | |||
8195990 | Demirciler | TR | Bolu | 40.80962 | 32.49058 | 0 | Europe/Istanbul | populated place |
FaQ about Turkey
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