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

Germany
Germany
Excel, CSV, SQL, XML, JSON

Last update : 05 December 2025.

Country
Germany
Capital
Berlin
Number of cities
65005
Download
Click here

Below is a list of 100 prominent cities in Germany. Each row includes a city's latitude, longitude, region and other variables of interest. This is a subset of all 65005 places in Germany that you'll find in our World Cities Database. You're free to use the data below for personal or commercial applications. The data below can be downloaded in Excel (.xlsx), .csv, .json, .xml and .sql formats. Notable Cities: The capital of Germany is Berlin.


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
2866029NeudeckDEThuringia50.6409411.767020Europe/Berlinpopulated place
2874929LüthkeshofDEBrandenburg52.9433613.308390Europe/Berlinpopulated place
2882200KütterheideDENorth Rhine-WestphaliaDüsseldorf District51.293916.59260Europe/Berlinpopulated place
2823872TaubenpreskelnDEThuringia50.8380112.094840Europe/Berlinpopulated place
2811163WengDEBavariaUpper Bavaria48.3630411.583020Europe/Berlinpopulated place
2906186HerbsenDEHesseRegierungsbezirk Kassel51.430479.055820Europe/Berlinpopulated place
2881687LampertshofenDEBavariaUpper Bavaria48.6289411.227340Europe/Berlinpopulated place
2918207GraichaGraichaDEThuringia50.9256512.284070Europe/Berlinpopulated place
2869653MoorhusenMoorhusenDELower Saxony53.522477.358630Europe/Berlinpopulated place
2867055NasenbergDESaxony51.2636113.166870Europe/Berlinpopulated place
2873581MarienhafeMarienhafe,Marienkhafe,Marinkhafe,Mariënhafe,ma lin ha fei,Мариенхафе,Маринхафе,马林哈费DELower Saxony53.522747.273062032Europe/Berlinpopulated place
2895900InvalidendankDEBrandenburg52.4666713.733330Europe/Berlinpopulated place
2946889BohnradeDESchleswig-Holstein53.900510.629520Europe/Berlinpopulated place
2894017KaiserodaDEThuringia50.8209710.180580Europe/Berlinpopulated place
2871323MichelfeldDEBavariaUpper Palatinate49.7050511.583040Europe/Berlinpopulated place
2959681AchimAchem,Akhim,Uphusen,a xi mu,ahimu,akhym,Ахим,آخيم,آخیم,アヒム,阿希姆DELower Saxony53.014169.026330013Europe/Berlinpopulated place
2916837GrossduggendorfDEBavariaUpper Palatinate49.1166711.933330Europe/Berlinpopulated place
2886078KölsaDESaxony51.470612.231080Europe/Berlinpopulated place
2878678LeopoldsdorfDEBavariaLower Bavaria48.5812613.605970Europe/Berlinpopulated place
2909328HaßlauDESaxony51.0924513.18102300Europe/Berlinpopulated place
2832411SiehenfeldeDELower Saxony52.804388.14770Europe/Berlinpopulated place
2865173NeuhausDEBavariaUpper Bavaria47.7031811.878620Europe/Berlinpopulated place
2839696SchererDEBavariaUpper Bavaria48.0380512.351490Europe/Berlinpopulated place
2933800EchingDEBavariaUpper Bavaria48.2825111.853050Europe/Berlinpopulated place
3204998ErdebornErdebornDESaxony-Anhalt51.4755411.634871117Europe/Berlinpopulated place
2849326RehhofDEThuringia50.9510.40Europe/Berlinpopulated place
2928541EubaEubaDESaxony50.8390613.023990Europe/Berlinpopulated place
2835512SchwabenheimSchwabenheimDERheinland-Pfalz49.928798.095252555Europe/Berlinpopulated place
2914459GrünbachDERheinland-Pfalz49.635477.393170Europe/Berlinpopulated place
2936565DobraDEBrandenburg51.5156713.445450Europe/Berlinpopulated place
2882250KüsserowKusserow,Kusserow Dorf,Küsserow,Küsserow DorfDEMecklenburg-Vorpommern53.864112.695580Europe/Berlinpopulated place
2953545Bad BerleburgBad Berleburg,Bad-Berleburg,Berleberg,Berleburg,ba te bei lei bao,bad brlbwrg,bad brlhbwrgh,Бад Берлебург,Бад-Берлебург,باد برلبورگ,باد برلهبورغ,巴特贝勒堡DENorth Rhine-WestphaliaRegierungsbezirk Arnsberg51.052248.3922720757Europe/Berlinpopulated place
2820412UgenhofUgahof,UgenhofDEBaden-WurttembergRegierungsbezirk Stuttgart48.6335810.104320Europe/Berlinpopulated place
2895087JedlingJealingDEBavariaUpper Bavaria47.8125811.884590Europe/Berlinpopulated place
2847312RiedRiedDEBavariaSwabia48.8304310.866830Europe/Berlinpopulated place
2822868ThemarTemar,Themar,te ma er,tmar,Темар,تمار,特马尔DEThuringia50.5046510.615363083Europe/Berlinpopulated place
2953077BalkhausenBalkhausenDEHesseRegierungsbezirk Darmstadt49.734558.659030Europe/Berlinpopulated place
2828198SteinenfeldDEBaden-WurttembergTübingen Region48.355629.788170Europe/Berlinpopulated place
2836192SchrampeSchrampeDESaxony-Anhalt52.892211.44206311Europe/Berlinpopulated place
2856251OstlandDELower Saxony53.603616.724920Europe/Berlinpopulated place
11608994LaupendahlDENorth Rhine-WestphaliaDüsseldorf District51.348526.949070Europe/Berlinpopulated place
2953319Bad WeilbachBad WeilbachDEHesseRegierungsbezirk Darmstadt50.034248.428660Europe/Berlinpopulated place
2808396WilzhofenDEBavariaUpper Bavaria47.8784711.182570Europe/Berlinpopulated place
2859202ObersandingObersandingDEBavariaUpper Palatinate48.8876412.161940Europe/Berlinpopulated place
2877817LiepenDEMecklenburg-Vorpommern53.6330412.430340Europe/Berlinpopulated place
2845815RohdenDELower Saxony52.192989.244310Europe/Berlinpopulated place
2854569PettenhofBettenhofDEBavariaUpper Palatinate49.2230911.938660Europe/Berlinpopulated place
2947433BobstadtDEBaden-WurttembergRegierungsbezirk Stuttgart49.467259.6740Europe/Berlinpopulated place
2861341OberbachhamDEBavariaLower Bavaria48.4806612.115510Europe/Berlinpopulated place
2885677KonstanzerDEBavariaSwabia47.5569510.108190Europe/Berlinpopulated place
2907425HeimbergDERheinland-Pfalz49.75557.502860Europe/Berlinpopulated place
2806379WollmeringDEBavariaLower Bavaria48.6920813.278620Europe/Berlinpopulated place
2846182RöckwitzRockwitz,RöckwitzDEMecklenburg-Vorpommern53.7070313.10247329Europe/Berlinpopulated place
2888810KleinhabersdorfDEBavariaRegierungsbezirk Mittelfranken49.3688810.678620Europe/Berlinpopulated place
2893380KammerforstDEBavariaRegierungsbezirk Unterfranken49.8506210.425520Europe/Berlinpopulated place
2807017WöhningenDELower Saxony52.8994310.92710Europe/Berlinpopulated place
2811224Wendisch KirchhofDESaxony-Anhalt52.7952512.213490Europe/Berlinpopulated place
2930036EnnestDENorth Rhine-WestphaliaRegierungsbezirk Arnsberg51.145667.913450Europe/Berlinpopulated place
2944241BrententannDEBaden-WurttembergTübingen Region47.79.766670Europe/Berlinpopulated place
2959742AccumAccumDELower Saxony53.544188.01160Europe/Berlinpopulated place
2828209SteinenbergDEBaden-WurttembergTübingen Region47.94039.748860Europe/Berlinpopulated place
2912703HäfnerhaslachDEBaden-WurttembergRegierungsbezirk Stuttgart49.026228.918740Europe/Berlinpopulated place
2814688WallbachWallbachDEBaden-WurttembergFreiburg Region47.565897.914170Europe/Berlinpopulated place
2863105NiedermörmterDENorth Rhine-WestphaliaDüsseldorf District51.745096.386290Europe/Berlinpopulated place
2926132FlorenDENorth Rhine-WestphaliaRegierungsbezirk Köln50.671476.648250Europe/Berlinpopulated place
2856875OsseckDEBavariaUpper Franconia50.3061811.878030Europe/Berlinpopulated place
11594387Mariental-HorstDELower Saxony52.2892910.99680Europe/Berlinpopulated place
2835258SchwaneySchwaneyDENorth Rhine-WestphaliaRegierungsbezirk Detmold51.715618.934010Europe/Berlinpopulated place
2876300LohenDEBavariaUpper Bavaria47.8997112.226920Europe/Berlinpopulated place
2806827WolfertshofenDEBavariaSwabia47.642129.928140Europe/Berlinpopulated place
2958214AlmsickDENorth Rhine-WestphaliaRegierungsbezirk Münster52.005196.938870Europe/Berlinpopulated place
2913999GschlachtenbretzingenDEBaden-WurttembergRegierungsbezirk Stuttgart49.088179.754040Europe/Berlinpopulated place
2899049HörgassingDEBavariaUpper Bavaria47.974812.695370Europe/Berlinpopulated place
2825959StreitbühlDEBavariaUpper Palatinate49.6031811.70740Europe/Berlinpopulated place
2816806VoglriedDEBavariaUpper Bavaria48.5180211.456610Europe/Berlinpopulated place
2911109HammerleithenDESaxony50.3333312.116670Europe/Berlinpopulated place
2840740SchaffelkingenDEBaden-WurttembergTübingen Region48.373049.911510Europe/Berlinpopulated place
2883008KuglthalDEBavariaUpper Bavaria48.0296712.720490Europe/Berlinpopulated place
2920569GiesekenhagenGiesekenhagenDEMecklenburg-Vorpommern53.996713.641870Europe/Berlinpopulated place
2931327EizersdorfDEBavariaLower Bavaria48.7816413.283130Europe/Berlinpopulated place
2912224HahnenmoorDELower Saxony52.667727.738920Europe/Berlinpopulated place
2948858BindeBindeDESaxony-Anhalt52.8545411.38487364Europe/Berlinpopulated place
2958626AlbrechtsDEBavariaSwabia47.8123710.446170Europe/Berlinpopulated place
2858249OchtmerslebenOchtensIae,OchtensIä,Ochtensleben,Ochtmersleben,Ochtmersleven [a. 1175],Okhtmersleben,Othmerslove [a. 1207],ОхтмерслебенDESaxony-Anhalt52.1578211.40896118592Europe/Berlinpopulated place
2853979PfordtDEHesseRegierungsbezirk Gießen50.657439.597830Europe/Berlinpopulated place
2867106NannenbachDEBaden-WurttembergTübingen Region47.78819.971010Europe/Berlinpopulated place
2911760HaintchenDEHesseRegierungsbezirk Gießen50.361158.317150Europe/Berlinpopulated place
2890586KirchenChiricheim,Kirchen,Kirchen an der Sieg,Kirkhen,ji xing,kiruhyen,kyrshn,Кирхен,كيرشن,کیرشن,キルヒェン,基兴DERheinland-Pfalz50.808497.886349342Europe/Berlinpopulated place
12060246NonnenwaldDEBavariaUpper Bavaria47.7733111.376920Europe/Berlinpopulated place
2913319GuttenbergDEBavariaUpper Palatinate49.8499811.981770Europe/Berlinpopulated place
2891525KerpenKerpen,КерпенDERheinland-Pfalz50.309676.72978463Europe/Berlinpopulated place
2899889HolzerodeDELower Saxony51.5952810.065320Europe/Berlinpopulated place
2833186SellienDELower Saxony53.0641210.863850Europe/Berlinpopulated place
2899137HopscheiderbergDENorth Rhine-WestphaliaDüsseldorf District51.364047.115840Europe/Berlinpopulated place
2949278BiebelhausenDERheinland-Pfalz49.635856.569920Europe/Berlinpopulated place
2919475GöhrenDEMecklenburg-Vorpommern53.4236413.564130Europe/Berlinpopulated place
2901641HohenlauftHohenlauftDESaxony51.0705713.150710Europe/Berlinpopulated place
2910278HarsewinkelGarzevinkel’,Harsewinkel,Haswinkil,Hoswinkil,Kharsevinkel,Kharzevinkel’,ha er sai wen ke er,harzhfynkl,Гарзевінкель,Харзевинкель,Харсевинкел,هارزهفينكل,هارزه‌وینکل,哈尔塞温克尔DENorth Rhine-WestphaliaRegierungsbezirk Detmold51.962248.2276624207Europe/Berlinpopulated place
2817122VitteVitteDEMecklenburg-Vorpommern54.5653413.107490Europe/Berlinpopulated place
2899149HöpperichDESaxony50.9963813.174170Europe/Berlinpopulated place

**Exploring Germany: A Geographer's Perspective**

Introduction**

As a geographer delving into the geographical intricacies of Germany, obtaining data on its cities, regions, and geographical coordinates unveils a rich tapestry of cultural diversity, historical significance, and spatial dynamics. In this article, we embark on a journey to explore the diverse landscapes, urban centers, and regional variations that define the geographical essence of Germany.

Mapping the Regions and Administrative Divisions**

Germany, a country located in the heart of Europe, is divided into 16 federal states, each with its own unique landscapes, cultural heritage, and administrative structures. From the coastal plains of Schleswig-Holstein to the mountainous terrain of Bavaria, the regional divisions of Germany reflect its geographical diversity and historical legacy.

Exploring Urban Centers and Rural Communities**

Urban centers such as Berlin, Hamburg, and Munich stand as vibrant hubs of culture, commerce, and innovation, attracting millions of residents and visitors alike with their dynamic energy and cosmopolitan flair. Meanwhile, rural communities scattered across the countryside offer tranquil retreats, picturesque landscapes, and a glimpse into traditional German life. Navigating the urban-rural continuum of Germany provides invaluable insights into its socio-economic dynamics and spatial organization.

Acquiring Geographical Coordinates**

Obtaining accurate geographical coordinates for the cities and towns of Germany is essential for spatial analysis, cartographic mapping, and urban planning initiatives. By acquiring latitude and longitude data for each locality, geographers contribute to a deeper understanding of spatial patterns, population distribution, and infrastructure development across the country. From the bustling streets of Frankfurt to the medieval charm of Rothenburg ob der Tauber, precise geospatial information enhances our knowledge of Germany's diverse geography.

Preserving Cultural Heritage and Natural Landscapes**

Preserving Germany's rich cultural heritage and natural landscapes is essential for ensuring sustainable development and environmental stewardship. The country is home to numerous UNESCO World Heritage sites, including the historic centers of Dresden and Bamberg, as well as the natural wonders of the Wadden Sea and the Black Forest. Through heritage conservation, landscape management, and sustainable tourism practices, geographers play a crucial role in safeguarding Germany's cultural legacy and ecological diversity for future generations.

Conclusion**

In conclusion, delving into the geographical nuances of Germany unveils a mosaic of landscapes, urban centers, and cultural heritage that define its unique identity. By obtaining data on its regions, cities, and geographical coordinates, we gain valuable insights into the spatial dynamics and cultural richness of the country. Let us continue to explore, analyze, and celebrate the geographical diversity of Germany, fostering understanding, connectivity, and sustainability for all its inhabitants.

download world databases cities Germany

Download data files for Germany's cities in Excel (.xlsx), CSV, SQL, XML and JSON formats

Exploring Germany’s Geography: A Geographer’s Insight into Cities, Regions, and Data

Germany, located at the heart of Europe, boasts a rich geographical diversity that has shaped its history, culture, and economy. From the towering Alps in the south to the flat plains of the North German Plain, and from its extensive rivers like the Rhine and Elbe to its Baltic and North Sea coastlines, Germany’s varied landscape is a key factor in its urban development and regional distinctions. As a geographer, understanding how Germany’s cities, regions, and natural features are interrelated provides crucial insights into the country’s development, environmental challenges, and infrastructure needs. The integration of geographic data, such as city coordinates and regional divisions, further enhances our understanding of this dynamic nation.

Geographical Structure of Germany: Cities, Regions, and Administrative Divisions

Germany is divided into 16 federal states, known as "Bundesländer," each with its own distinct administrative and political functions. These states include Bavaria, Berlin, Brandenburg, Bremen, Hamburg, Hesse, Lower Saxony, Mecklenburg-Vorpommern, North Rhine-Westphalia, Rhineland-Palatinate, Saarland, Saxony, Saxony-Anhalt, Schleswig-Holstein, and Thuringia. Each state is further subdivided into districts or municipalities, which collectively contribute to the complex governance and organization of the country.

The capital city, Berlin, is located in the northeastern part of the country, nestled between the states of Brandenburg and Mecklenburg-Vorpommern. As both the political and cultural heart of Germany, Berlin holds immense significance. Other major cities, such as Munich, Hamburg, and Frankfurt, contribute significantly to Germany's economy, infrastructure, and cultural identity. Munich, in Bavaria, is renowned for its cultural heritage and economic power, particularly in sectors like technology, finance, and automotive industries, while Hamburg, a port city on the Elbe River, serves as one of Europe’s largest international trade hubs.

The geographical distribution of these cities and regions is heavily influenced by the natural environment. For instance, the fertile plains of the North German Plain have encouraged dense settlement and agricultural activities, while the mountainous terrain of Bavaria has fostered smaller, well-connected towns and cities that are known for their high quality of life.

Latitude and Longitude: Mapping Germany’s Cities

Latitude and longitude are essential tools for accurately mapping the cities of Germany, helping geographers understand their position relative to one another and the natural environment. These coordinates enable the identification of regional trends, such as urbanization patterns, transportation routes, and environmental impact.

For example, Berlin's latitude and longitude data reflect its importance as the capital, strategically positioned in the northeastern part of Germany, making it a central hub for politics, education, and culture. Cities like Munich and Frankfurt, situated in southern and western Germany respectively, are positioned closer to the economic and industrial heart of Europe, giving them a central role in finance, trade, and manufacturing.

Access to precise latitude and longitude data of each city allows researchers and planners to analyze the effects of geographic positioning on regional development, infrastructure planning, and environmental sustainability. For instance, understanding how cities are distributed along rivers, such as the Rhine or Elbe, reveals their historical significance as trade and industrial centers, which continue to influence Germany’s economic structure today.

Accessing Germany’s Geographic Data in Multiple Formats

To better understand the geography of Germany, it is essential to have access to data in formats that allow for detailed analysis and visualization. Geographic data, including city coordinates, regional divisions, and demographic information, can be obtained in formats such as CSV, SQL, JSON, and XML. Each format provides distinct advantages depending on the user’s needs, from academic research to urban planning and beyond.

CSV (Comma Separated Values) is one of the most straightforward and widely-used formats for organizing data in tabular form. By importing city and region data into spreadsheet software, users can filter, sort, and perform basic analyses on geographical information, such as comparing population sizes or exploring regional economic disparities. SQL (Structured Query Language), on the other hand, is highly effective for working with larger datasets stored in relational databases. SQL allows users to query geographic data, identify spatial patterns, and perform advanced analyses on regional trends across Germany.

For developers and GIS (Geographic Information Systems) professionals, JSON (JavaScript Object Notation) and XML (Extensible Markup Language) are crucial formats for integrating geographic data into web applications, dynamic maps, and real-time data visualizations. These formats provide flexibility for creating interactive tools that can display Germany’s cities, their spatial relationships, and regional attributes in an intuitive, user-friendly way. Whether for developing a geographic map or analyzing the flow of goods along transportation networks, JSON and XML enable powerful spatial analysis applications.

Having access to Germany’s geographic data in these diverse formats ensures that users can tailor their analysis to their specific needs. Whether working on a high-level demographic study, urban planning project, or environmental analysis, these formats facilitate the use of geographic data across a wide range of disciplines.

The Importance of Geographic Data for Understanding Germany

The geography of Germany plays a vital role in shaping the country's urbanization, infrastructure, and resource management. Understanding the distribution of cities, regions, and the physical environment is essential for addressing current challenges, such as climate change, population growth, and sustainable development.

Geographic data, such as city coordinates and regional boundaries, provides critical insights into the distribution of Germany’s population, economic hubs, and natural resources. By mapping this data, geographers and planners can analyze the accessibility of key services, identify trends in population movement, and assess the impact of environmental factors such as climate change or industrialization on different regions of the country.

Moreover, the availability of geographic data in formats such as CSV, SQL, JSON, and XML enhances its accessibility and applicability for various sectors, from government planning and policy-making to private-sector business development. These formats allow for detailed spatial modeling, helping users to understand how Germany’s geography influences its development and guide sustainable practices that balance economic growth with environmental preservation.

In conclusion, geographic data plays an indispensable role in understanding how Germany’s cities, regions, and natural features interact. By obtaining detailed data on Germany’s cities, regions, and coordinates, geographers, urban planners, and policymakers can make informed decisions that foster sustainable growth, efficient infrastructure planning, and the preservation of natural resources. The ability to work with this data in CSV, SQL, JSON, and XML formats empowers users to explore Germany’s geography in greater depth, leading to better planning and development strategies for the future.

List of countries :

worldcitiesdatabase.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.