Germany Cities with Latitude & Longitude – Download in Excel, CSV, SQL, JSON, XML

Germany
Germany
Excel, CSV, SQL, XML, JSON

Last update : 23 March 2026.

Country
Germany
Capital
Berlin
Number of cities
65005
Download
Click here

Here you’ll find a curated sample of 100 key cities from Germany, each with essential data points such as latitude, longitude, administrative region, and other relevant attributes. This preview is extracted from our full dataset, which includes a total of 65005 geographic locations across Germany.

Whether you’re working on mapping, analytics, or app development, the data is available for both personal and commercial use. All entries can be downloaded in five formats: Excel (.xlsx), CSV, SQL, JSON, and XML.

Capital Highlight: The official capital city of Germany is Berlin.


Geoname_IDCityAlternate_NameCountry_Code RegionSub_regionLatitudeLongitude ElevationPopulationTimezoneFcode_Name
2867688 Münchenreuth DE Bavaria Upper Franconia 50.41384 11.92121 0 Europe/Berlin populated place
2959291 Agnesenhof DE Saxony-Anhalt 00 52.6 11.61667 0 Europe/Berlin populated place
2879670 Leetza Leetza DE Saxony-Anhalt 00 51.88734 12.81832 388 Europe/Berlin populated place
2922317 Gatterstädt DE Saxony-Anhalt 00 51.40297 11.54519 0 Europe/Berlin populated place
2939833 Cösitz DE Saxony-Anhalt 00 51.64934 12.06453 306 Europe/Berlin populated place
2855979 Ottfingen Ottfingen DE North Rhine-Westphalia Regierungsbezirk Arnsberg 50.94977 7.84879 0 Europe/Berlin populated place
2910467 Harkemissen DE North Rhine-Westphalia Regierungsbezirk Detmold 52.12511 8.91369 0 Europe/Berlin populated place
2845913 Rodlera DE Saxony 00 50.55323 12.20545 0 Europe/Berlin populated place
2918570 Götzberg DE Schleswig-Holstein 00 53.79308 10.04187 0 Europe/Berlin populated place
2809490 Wielen DE Schleswig-Holstein 00 54.19373 10.33221 0 Europe/Berlin populated place
2897386 Hungerberg Hungerberg DE North Rhine-Westphalia Regierungsbezirk Köln 51.13258 7.43528 0 Europe/Berlin populated place
2904623 Hilsen Hilsen,Hilzen DE Baden-Wurttemberg Freiburg Region 48.5359 8.08528 0 Europe/Berlin populated place
2882199 Kutterling DE Bavaria Upper Bavaria 47.76241 12.029 0 Europe/Berlin populated place
2959322 Aftholderberg Aftholderberg DE Baden-Wurttemberg Tübingen Region 47.89859 9.24335 0 Europe/Berlin populated place
2867870 Mukrena Mukrena DE Saxony-Anhalt 00 51.70269 11.68435 0 Europe/Berlin populated place
2843985 Rothensehma DE Saxony 00 50.52421 13.01709 0 Europe/Berlin populated place
2901806 Hohenelse DE Brandenburg 00 53.12366 12.88236 0 Europe/Berlin populated place
2910145 Harth Harth DE North Rhine-Westphalia Regierungsbezirk Detmold 51.50404 8.57937 0 Europe/Berlin populated place
2850399 Ranzing DE Bavaria Lower Bavaria 48.65754 13.36125 0 Europe/Berlin populated place
2833983 Seebarnhammer DE Bavaria Upper Palatinate 49.35 12.46667 0 Europe/Berlin populated place
2888655 Kleinkitzighofen DE Bavaria Swabia 48.08589 10.76737 0 Europe/Berlin populated place
2867208 Nadorst DE Lower Saxony 00 53.16764 8.22892 0 Europe/Berlin populated place
2958884 Aiglsdorf DE Bavaria Upper Bavaria 48.52367 11.7824 0 Europe/Berlin populated place
2915455 Groß Jasedow Gross Jasedow,Groß Jasedow DE Mecklenburg-Vorpommern 00 53.93415 13.60557 0 Europe/Berlin populated place
2808335 Wimpasing DE Bavaria Upper Bavaria 48.32061 12.46688 0 Europe/Berlin populated place
2855125 Pechreuth DE Bavaria Upper Franconia 50.31773 11.65643 0 Europe/Berlin populated place
2813231 Wehren DE North Rhine-Westphalia Regierungsbezirk Detmold 51.90833 8.99883 0 Europe/Berlin populated place
2875003 Lüskow DE Mecklenburg-Vorpommern 00 53.81815 13.64907 0 Europe/Berlin populated place
2936869 Dinspel DE Rheinland-Pfalz 00 50.64301 7.43389 0 Europe/Berlin populated place
2943002 Brunzendorf DE Bavaria Regierungsbezirk Mittelfranken 49.3682 10.1395 0 Europe/Berlin populated place
2851974 Pritzerbe DE Brandenburg 00 52.49633 12.45696 0 Europe/Berlin populated place
2839065 Schirndorf DE Bavaria Upper Palatinate 49.17898 11.99089 0 Europe/Berlin populated place
2914359 Grundend DE North Rhine-Westphalia Düsseldorf District 51.30083 6.60359 0 Europe/Berlin populated place
2935075 Dreißigacker Dreissigacker,Dreißigacker DE Thuringia 00 50.55925 10.38759 0 Europe/Berlin populated place
2859971 Oberlangfurth DE Bavaria Lower Bavaria 48.83333 13.2 0 Europe/Berlin populated place
2831383 Sommerhof DE Bavaria Regierungsbezirk Unterfranken 50.01869 9.65558 0 Europe/Berlin populated place
2944709 Breitenbach DE Saxony 00 50.86846 12.52173 0 Europe/Berlin populated place
2951314 Beinum DE Lower Saxony 00 52.07434 10.41401 0 Europe/Berlin populated place
2832488 Siegenhofen DE Bavaria Swabia 48.96293 10.60641 0 Europe/Berlin populated place
2889674 Kleinbreitenbronn DE Bavaria Regierungsbezirk Mittelfranken 49.21598 10.66844 0 Europe/Berlin populated place
2864127 Neusorge Neusorge DE Saxony 00 51.38103 14.93174 0 Europe/Berlin populated place
2852158 Pretzsch Pretzsch DE Saxony-Anhalt 00 51.09439 11.94631 167 Europe/Berlin populated place
2881055 Langenhain DE Hesse Regierungsbezirk Darmstadt 50.3669 8.63913 0 Europe/Berlin populated place
2913929 Gstetten DE Bavaria Upper Palatinate 49.20973 12.51287 0 Europe/Berlin populated place
2851865 Proß DE Bavaria Upper Franconia 50.06829 11.37697 0 Europe/Berlin populated place
2871354 Michelbach DE Hesse Regierungsbezirk Gießen 50.50392 9.15948 0 Europe/Berlin populated place
2888015 Kleinwenden Grosslohra-Kleinwenden,Großlohra-Kleinwenden,Kleinwenden DE Thuringia 00 51.41611 10.65902 1043 Europe/Berlin populated place
2807965 Winkeln DE North Rhine-Westphalia Regierungsbezirk Arnsberg 51.27522 7.60006 0 Europe/Berlin populated place
2807090 Wohlbach DE Saxony 00 50.35398 12.3109 0 Europe/Berlin populated place
2815560 Wadewitz Borna-Wadewitz,Wadewitz DE Saxony 00 51.31119 13.1945 0 Europe/Berlin populated place
2836549 Schönhorst Schonhorst,Schönhorst DE Schleswig-Holstein 00 54.22644 10.10601 0 Europe/Berlin populated place
2953574 Baekern Backern,Baekern,Bakern,Bäckern,Bäkern DE Brandenburg 00 53.10299 11.44619 0 Europe/Berlin populated place
2933747 Eck DE Bavaria Upper Bavaria 48.43264 12.00833 0 Europe/Berlin populated place
2870635 Mittelmarterhof DE Bavaria Regierungsbezirk Mittelfranken 48.93987 11.00521 0 Europe/Berlin populated place
2887663 Klinkum Klinkum DE North Rhine-Westphalia Regierungsbezirk Köln 51.13609 6.25156 0 Europe/Berlin populated place
2909558 Haslach DE Bavaria Swabia 47.54683 9.84911 0 Europe/Berlin populated place
2872025 Meltendorf DE Saxony-Anhalt 00 51.85454 12.87878 0 Europe/Berlin populated place
2806687 Wolfsberg DE Saxony 00 50.64954 13.11938 0 Europe/Berlin populated place
2902462 Hof Mappen Hof Mappen,Mappen Hof DE Hesse Regierungsbezirk Darmstadt 50.06806 8.00693 0 Europe/Berlin populated place
2869455 Moosbronn Moosbronn DE Baden-Wurttemberg Karlsruhe Region 48.83656 8.38836 0 Europe/Berlin populated place
2887198 Knesing DE Bavaria Upper Bavaria 47.94469 12.54647 0 Europe/Berlin populated place
2805515 Wüstenhain DE Saxony 00 51.00933 12.57857 0 Europe/Berlin populated place
2890182 Kittersburg DE Baden-Wurttemberg Freiburg Region 48.50137 7.83801 0 Europe/Berlin populated place
2869092 Moschwig DE Saxony-Anhalt 00 51.73333 12.73333 0 Europe/Berlin populated place
2808543 Willingen DE Lower Saxony 00 52.96508 9.79568 0 Europe/Berlin populated place
2818757 Unterschnaittenbach DE Bavaria Upper Palatinate 49.55 12.01667 0 Europe/Berlin populated place
2858562 Oberwesel Obervezel,Obervezel’,Oberwesel,awbrfyzl,awbrwzl,obavueseru,Обервезел,Обервезель,أوبرفيزل,اوبروزل,オーバーヴェセル DE Rheinland-Pfalz 00 50.10777 7.72522 3128 Europe/Berlin populated place
2917837 Grebswarden DE Lower Saxony 00 53.52377 8.51008 0 Europe/Berlin populated place
2804004 Zittenfelden DE Bavaria Regierungsbezirk Unterfranken 49.60223 9.24789 0 Europe/Berlin populated place
2844578 Rot DE Baden-Wurttemberg Regierungsbezirk Stuttgart 49.04023 10.1339 0 Europe/Berlin populated place
2955058 Aspertsham DE Bavaria Upper Bavaria 48.33053 12.41117 0 Europe/Berlin populated place
2936347 Döllnitz DE Bavaria Upper Palatinate 49.50122 12.1262 0 Europe/Berlin populated place
2891991 Kayna Kayna DE Saxony-Anhalt 00 50.99414 12.2371 1532 Europe/Berlin populated place
2867643 Münchshecke DE North Rhine-Westphalia Regierungsbezirk Köln 50.79768 7.26804 0 Europe/Berlin populated place
2835170 Schwarzach bei Kulmbach DE Bavaria Upper Franconia 50.10936 11.35933 0 Europe/Berlin populated place
3205809 Dickebülten DE North Rhine-Westphalia Regierungsbezirk Münster 51.891 7.10487 0 Europe/Berlin populated place
2926637 Fischbach DE Bavaria Upper Palatinate 49.17254 11.98367 0 Europe/Berlin populated place
2837705 Schmitten Schmitten DE Hesse Regierungsbezirk Gießen 50.57479 9.10498 0 Europe/Berlin populated place
2943749 Broock Broock DE Mecklenburg-Vorpommern 00 53.83674 13.23333 0 Europe/Berlin populated place
2811720 Weißig Weissig,Weißig,Wysoka DE Saxony 00 51.34932 14.1211 0 Europe/Berlin populated place
2925246 Freckhausen DE North Rhine-Westphalia Regierungsbezirk Köln 50.97027 7.60254 0 Europe/Berlin populated place
2817207 Vilseck Fil’zek,Filzek,Vilseck,fei er sai ke,fylsk,Филзек,Фильзек,Фільзек,Ֆիլզեկ,فیلسک,菲尔塞克 DE Bavaria Upper Palatinate 49.6148 11.80261 6560 Europe/Berlin populated place
2829891 Stadel DE Baden-Wurttemberg Regierungsbezirk Stuttgart 49.11667 9.86667 0 Europe/Berlin populated place
2814247 Wank DE Bavaria Swabia 47.61521 10.52127 0 Europe/Berlin populated place
2826537 Stolpe DE Mecklenburg-Vorpommern 00 53.86851 13.98948 0 Europe/Berlin populated place
2896601 Ilbeshausen DE Hesse Regierungsbezirk Gießen 50.52202 9.32999 0 Europe/Berlin populated place
2879109 Leisnig Lajsnig,Leisnig,Leisniga,Lesnik,Lěsnik,lai si ni xi,layznyg,layznygh,Лайсниг,Лайсніг,Лајсниг,لايزنيغ,لایزنیگ,莱斯尼希 DE Saxony 00 51.15743 12.9279 6968 Europe/Berlin populated place
6930498 Anger DE Bavaria Upper Bavaria 48.01502 12.06434 0 Europe/Berlin populated place
2826044 Streetz DE Lower Saxony 00 53.10948 11.06031 0 Europe/Berlin populated place
2850847 Rahrbach DE North Rhine-Westphalia Regierungsbezirk Arnsberg 51.03742 7.97808 0 Europe/Berlin populated place
2853768 Pietsham DE Bavaria Upper Bavaria 48.26012 12.32495 0 Europe/Berlin populated place
2928829 Eßbaum DE Bavaria Upper Bavaria 47.76466 12.19723 0 Europe/Berlin populated place
2934809 Drüpt DE North Rhine-Westphalia Düsseldorf District 51.58628 6.53875 0 Europe/Berlin populated place
2957695 Altenfelden DE Bavaria Regierungsbezirk Mittelfranken 49.26265 11.21773 0 Europe/Berlin populated place
2821926 Tölzkirchen DE Bavaria Upper Bavaria 48.51738 11.82752 0 Europe/Berlin populated place
2863413 Niedergeroldshausen DE Bavaria Upper Bavaria 48.56667 11.61667 0 Europe/Berlin populated place
2896340 Im Hördenbruch DE North Rhine-Westphalia Regierungsbezirk Arnsberg 51.33333 7.43333 0 Europe/Berlin populated place
2898653 Horst DE Lower Saxony 00 52.6948 8.86477 0 Europe/Berlin populated place
2941855 Bujendorf DE Schleswig-Holstein 00 54.10542 10.71361 0 Europe/Berlin populated place
2956242 Andelshofen DE Baden-Wurttemberg Tübingen Region 47.77992 9.18783 0 Europe/Berlin populated place

Germany: A Cartographic Symphony at the Heart of Europe

The Geographical Genius of a Nation

Germany is not just a country—it's a carefully layered masterpiece of geography and human design. From the wind-swept coasts of Schleswig-Holstein to the craggy peaks of Bavaria, every corner of the nation seems to hold a story written in land, elevation, and settlement. For geographers like myself, Germany is an atlas come to life, a living example of how natural landscapes and administrative precision can coexist in harmony.

But appreciating Germany’s spatial logic isn’t just an exercise in admiration. It demands structure. It demands detail. It demands data.

Navigating the Bundesländer: Germany’s Regional Backbone

Germany’s administrative structure is one of the most sophisticated in Europe. With 16 federal states (Bundesländer), each subdivided into districts (Kreise) and municipalities (Gemeinden), the country is a goldmine for geographic data modeling. Understanding the relationship between a city and its region is vital—whether you’re studying migration patterns, designing transport networks, or planning public services.

That’s why I’ve meticulously compiled a comprehensive city database for Germany, linking each locality to its respective region and district. This isn’t just about names—it’s about connecting dots in a nation where every dot counts.

Pinpointing Germany, One Coordinate at a Time

Precision is the pulse of modern geography. And in Germany, with its dense urban networks and critical infrastructure, latitude and longitude data become indispensable. Whether you're tracing the Rhine’s industrial arc or mapping renewable energy grids across Saxony-Anhalt, knowing exactly where each city lies is essential for accurate, actionable insights.

The dataset I’ve built provides exact coordinates for every recognized city in Germany. No more guesswork—just clean, geolocated data ready for integration into your GIS software, research models, or location-based services.

Excel: The Power Format for Territorial Intelligence

While the dataset is available in multiple formats—CSV, SQL, JSON, and XML—it’s the Excel (.xlsx) version that truly unlocks its practical value. With Excel, spatial data becomes interactive. You can group cities by region, sort by administrative code, filter by elevation proximity, or even link the data to real-time dashboards.

Urban planners, business analysts, and academic researchers can manipulate the data instantly—creating pivot tables, custom visualizations, and actionable maps directly from their Excel environment. No additional coding. Just immediate clarity.

From Data to Decision-Making: Why This Matters

Germany’s influence extends beyond its borders. Its cities are nodes in the global economy, its regions are leaders in policy innovation, and its infrastructure sets benchmarks worldwide. Having access to accurate, well-structured city data—complete with coordinates and administrative context—empowers everyone from logistics firms to think tanks to operate with precision and confidence.

My goal in offering this dataset is simple: to bridge the gap between curiosity and capability. Whether you're conducting demographic studies or building localized apps, you deserve data that is complete, clean, and easy to use.

Conclusion: Understanding Germany, One Cell at a Time

Germany is a canvas painted in layers—cultural, historical, environmental, and spatial. To truly understand it, we need more than maps. We need data that captures its administrative architecture and physical presence.

With this newly refined database—now available in Excel format alongside CSV, SQL, JSON, and XML—every German city becomes more than a name on a page. It becomes a precise, contextualized data point, ready to support the decisions and discoveries of those who seek to navigate Germany with clarity and depth.

Download Germany cities in Excel SQL CSV JSON XML

Access detailed latitude and longitude data for cities in Germany, now available in Excel (.xlsx) — plus CSV, SQL, XML, and JSON formats

List of countries :

download-cities-data.org