Germany cities list with latitude and longitude in CSV format

Germany
Germany
CSV, SQL, XML, JSON

Last update : 12 December 2023.

Country
Germany
Capitale
Berlin
Number of cities
65005
Download
Click here

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


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
2813387WegebergDEBrandenburg0053.0333312.550Europe/Berlinpopulated place
2952937BankewitzDELower Saxony0053.0325810.806370Europe/Berlinpopulated place
2855788PaalzowDEBrandenburg0052.9220512.652650Europe/Berlinpopulated place
2955783ApfelstettenDEBaden-WurttembergTübingen Region48.377069.490080Europe/Berlinpopulated place
2954789AuDEBavariaUpper Franconia50.1991411.29270Europe/Berlinpopulated place
2827128StiebitzScijecy,Stiebitz,SćijecyDESaxony0051.1748614.393490Europe/Berlinpopulated place
2804654ZeulenrodaDEThuringia0050.6527811.9837713763Europe/Berlinpopulated place
2866896NaundorfNaundorfDESaxony0050.9372313.42290Europe/Berlinpopulated place
2859644OberndorfDEBavariaLower Bavaria48.5526112.639330Europe/Berlinpopulated place
2833291SelbachDESaarland0049.536377.037620Europe/Berlinpopulated place
11608785WeingartenDEBaden-WurttembergFreiburg Region47.996447.811620Europe/Berlinpopulated place
2908903HausenDEBavariaSwabia48.3268110.297450Europe/Berlinpopulated place
2913538GunzenhausenGunzenhausenDEBaden-WurttembergTübingen Region47.977449.383270Europe/Berlinpopulated place
2875233LühmannsdorfLuehmannsdorf,Luhmannsdorf,LühmannsdorfDEMecklenburg-Vorpommern0054.0087113.6356721Europe/Berlinpopulated place
2919224GöllingenDEBavariaSwabia48.7252610.601290Europe/Berlinpopulated place
2886861KöckernDESaxony-Anhalt0051.6069112.19650Europe/Berlinpopulated place
2884495KreidachDEHesseRegierungsbezirk Darmstadt49.561368.787060Europe/Berlinpopulated place
2950997BenolpeBenolpeDENorth Rhine-WestphaliaRegierungsbezirk Arnsberg51.016897.73810Europe/Berlinpopulated place
2827388SteppachDEBavariaUpper Franconia49.7741710.805050Europe/Berlinpopulated place
2919664GniebitzGniebitzDESaxony0051.611912.785120Europe/Berlinpopulated place
2831516SöllingenDEBaden-WurttembergKarlsruhe Region48.986818.539470Europe/Berlinpopulated place
2866581NeippergNeippergDEBaden-WurttembergRegierungsbezirk Stuttgart49.104979.049420Europe/Berlinpopulated place
2819185UnterlangnauDEBaden-WurttembergTübingen Region47.633339.650Europe/Berlinpopulated place
2900906HohnDEBavariaRegierungsbezirk Unterfranken50.2801510.080510Europe/Berlinpopulated place
2892646KarstedtshofDEBrandenburg0053.0998512.465890Europe/Berlinpopulated place
2873624MarienberghausenMarienberghausenDENorth Rhine-WestphaliaRegierungsbezirk Köln50.919127.495530Europe/Berlinpopulated place
2958404AllerheiligenDEBaden-WurttembergTübingen Region47.733729.407530Europe/Berlinpopulated place
2878341LeupoldsteinDEBavariaUpper Franconia49.6961911.391840Europe/Berlinpopulated place
2866471NeschenDERheinland-Pfalz0050.595237.433610Europe/Berlinpopulated place
2845563RohrmünzDEBavariaLower Bavaria48.8864513.002020Europe/Berlinpopulated place
2944250BrenscheidDENorth Rhine-WestphaliaRegierungsbezirk Arnsberg51.167467.792590Europe/Berlinpopulated place
2878814LengshamDEBavariaLower Bavaria48.4108513.02890Europe/Berlinpopulated place
2851683PunreuthDEBavariaUpper Palatinate49.932411.869560Europe/Berlinpopulated place
2922175GebhardshagenDELower Saxony0052.1061910.358560Europe/Berlinpopulated place
2825951StreithainDEHesseRegierungsbezirk Darmstadt50.431489.140790Europe/Berlinpopulated place
2916625GroßenheerseGrossenheerse,GroßenheerseDENorth Rhine-WestphaliaRegierungsbezirk Detmold52.44678.989560Europe/Berlinpopulated place
2901690HohenhörnDESchleswig-Holstein0054.063489.307830Europe/Berlinpopulated place
2835592SchüttingDELower Saxony0053.52848.465520Europe/Berlinpopulated place
2813691WassingDEBavariaLower Bavaria48.5454412.504270Europe/Berlinpopulated place
2846817Riether StiegeDEMecklenburg-Vorpommern0053.6946314.233120Europe/Berlinpopulated place
2817022VogelbrinkDENorth Rhine-WestphaliaRegierungsbezirk Detmold52.365499.007680Europe/Berlinpopulated place
2936155DörentheDoerenthe,Dorenthe,DörentheDENorth Rhine-WestphaliaRegierungsbezirk Münster52.22017.682470Europe/Berlinpopulated place
2950506BerghamDEBavariaLower Bavaria48.4779612.810250Europe/Berlinpopulated place
2955652ArendseeDEBrandenburg0052.7682913.487610Europe/Berlinpopulated place
2930953EllgassenDEBavariaSwabia47.69.90Europe/Berlinpopulated place
2823147ThalbornDEThuringia0051.0921911.219110Europe/Berlinpopulated place
2813733WasserkurlWasserkurlDENorth Rhine-WestphaliaRegierungsbezirk Arnsberg51.559717.627240Europe/Berlinpopulated place
2855482PapitzPapitz,PopojceDEBrandenburg0051.7815314.199830Europe/Berlinpopulated place
2929196EsbeckDELower Saxony0052.1577210.961950Europe/Berlinpopulated place
2834979SchwarzenbergDEBavariaRegierungsbezirk Mittelfranken49.672510.475620Europe/Berlinpopulated place
2863584NiederbolheimNiederbolheimDENorth Rhine-WestphaliaRegierungsbezirk Köln50.829796.631130Europe/Berlinpopulated place
2849933RaumBielatal-Raum,RaumDESaxony0050.853714.026410Europe/Berlinpopulated place
2919747GlüsingenDELower Saxony0053.4098110.0180Europe/Berlinpopulated place
2821393TrefnitzDEBavariaUpper Palatinate49.4796312.280880Europe/Berlinpopulated place
2866053NeucunnewitzDESaxony0051.1780214.717370Europe/Berlinpopulated place
2882093LaasowDEBrandenburg0051.7133714.087480Europe/Berlinpopulated place
2866163NeuboblitzNeuboblitz,Nowe BobolcyDESaxony0051.143614.412630Europe/Berlinpopulated place
2883945KrieleDEBrandenburg0052.6551212.555710Europe/Berlinpopulated place
2829380StaudachDEBavariaLower Bavaria48.5959812.820250Europe/Berlinpopulated place
2847267RiedeggDEBavariaSwabia47.653910.623770Europe/Berlinpopulated place
2927130FermerslebenFermersleben,Magdeburg-FermerslebenDESaxony-Anhalt0052.0921111.654950Europe/Berlinpopulated place
2886171Kolonie HorstmarDENorth Rhine-WestphaliaRegierungsbezirk Arnsberg51.67.550Europe/Berlinpopulated place
2866856NaurathNaurathDERheinland-Pfalz0049.759826.88259219Europe/Berlinpopulated place
2859179OberscheidDERheinland-Pfalz0050.696347.413060Europe/Berlinpopulated place
2913781GülzowDEMecklenburg-Vorpommern0053.8197812.06814978Europe/Berlinpopulated place
2861382OberauDEBaden-WurttembergTübingen Region47.79.783330Europe/Berlinpopulated place
2888467KleinmünsterDEBavariaUpper Bavaria48.6833311.633330Europe/Berlinpopulated place
2847318RiedDEBavariaSwabia48.5231411.073120Europe/Berlinpopulated place
2814063WarnauDESaxony-Anhalt0052.7398812.19096282Europe/Berlinpopulated place
2930271EngelreuthDEBavariaRegierungsbezirk Mittelfranken49.0937111.074050Europe/Berlinpopulated place
2888556Klein LiebitzDEBrandenburg0051.9536614.265340Europe/Berlinpopulated place
2866538NendlnachDEBavariaLower Bavaria48.8155313.3820Europe/Berlinpopulated place
2913808GüldensteinDESchleswig-Holstein0054.2214610.834780Europe/Berlinpopulated place
2871096MilowMilowDEMecklenburg-Vorpommern0053.1915511.54144349Europe/Berlinpopulated place
2858984OberspitzenbachDEBaden-WurttembergFreiburg Region48.175987.98860Europe/Berlinpopulated place
2850117RatzenriedRatzenriedDEBaden-WurttembergTübingen Region47.7219.900640Europe/Berlinpopulated place
2816033VorseeDEMecklenburg-Vorpommern0053.6721214.195840Europe/Berlinpopulated place
2853487PlackersdorfDEBavariaUpper Bavaria48.3231612.623910Europe/Berlinpopulated place
2817232VillauVillauDENorth Rhine-WestphaliaDüsseldorf District51.099536.671570Europe/Berlinpopulated place
2813621WattsfeldDESchleswig-Holstein0054.759.950Europe/Berlinpopulated place
2925323FrauenrenthDEBavariaUpper Palatinate49.8851812.409570Europe/Berlinpopulated place
2955834AnzingDEBavariaUpper Bavaria48.3014612.200310Europe/Berlinpopulated place
2864891NeuhofDEMecklenburg-Vorpommern0054.3290413.424780Europe/Berlinpopulated place
2862542Nienser DeichstrichDELower Saxony0053.68.333330Europe/Berlinpopulated place
2943632BruchdorfDELower Saxony0053.2333310.850Europe/Berlinpopulated place
2847194RiederingDEBavariaUpper Bavaria48.0755311.869010Europe/Berlinpopulated place
2807333WittendorfWittendorfDEBaden-WurttembergKarlsruhe Region48.420978.497410Europe/Berlinpopulated place
2858794OberthannDEBavariaUpper Bavaria48.5051611.580840Europe/Berlinpopulated place
2949018BietenhausenDEBaden-WurttembergTübingen Region48.409218.86580Europe/Berlinpopulated place
2812068WeislitzDEBavariaUpper Palatinate49.4120912.426570Europe/Berlinpopulated place
2932157EichholzDENorth Rhine-WestphaliaRegierungsbezirk Detmold51.922148.900210Europe/Berlinpopulated place
2836669SchönfeldDEBavariaUpper Bavaria48.8967811.048640Europe/Berlinpopulated place
2938089DerkumDENorth Rhine-WestphaliaRegierungsbezirk Köln50.70986.814850Europe/Berlinpopulated place
2807576WippstettenDEBavariaLower Bavaria48.5151312.376270Europe/Berlinpopulated place
2871202MierscheidMierscheidDENorth Rhine-WestphaliaRegierungsbezirk Köln50.748567.449870Europe/Berlinpopulated place
2915559Groß HalternDELower Saxony0052.303678.175030Europe/Berlinpopulated place
2872942MatheshörlebachMatheshorlebach,MatheshörlebachDEBaden-WurttembergRegierungsbezirk Stuttgart49.114039.826530Europe/Berlinpopulated place
2828804SteinbachDEThuringia0050.3561911.213780Europe/Berlinpopulated place
2933792EchteEchteDELower Saxony0051.7840710.062920Europe/Berlinpopulated place
2928414EulsbachDEHesseRegierungsbezirk Darmstadt49.677218.764860Europe/Berlinpopulated place

FaQ about Germany

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.