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

Indonesia
Indonesia
Excel, CSV, SQL, XML, JSON

Last update : 24 March 2026.

Country
Indonesia
Capital
Jakarta
Number of cities
243039
Download

Here you’ll find a curated sample of 100 key cities from Indonesia, 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 243039 geographic locations across Indonesia.

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 Indonesia is Jakarta.


Geoname_IDCityAlternate_NameCountry_Code RegionSub_regionLatitudeLongitude ElevationPopulationTimezoneFcode_Name
6257297 Nalan ID Central Java Kabupaten Semarang -7.39972 110.49194 0 Asia/Jakarta populated place
6262974 Sukodono ID Central Java Kabupaten Sragen -7.43611 110.83889 0 Asia/Jakarta populated place
6791471 Tembelang Wetan Tembelang Wetan ID Central Java Kabupaten Pekalongan -7.0477 109.6596 0 Asia/Jakarta populated place
7088294 Karombang Karombang ID West Sulawesi Kabupaten Polewali Mandar -3.2123 119.1403 0 Asia/Makassar populated place
6774370 Pasirpari Pasirpari ID West Java Kabupaten Garut -7.24 107.8004 0 Asia/Jakarta populated place
1935491 Sawahan ID Central Java Kabupaten Karanganyar -7.57083 110.90306 0 Asia/Jakarta populated place
8529430 Peguil Peguil,Pugul ID Bangka–Belitung Islands Kabupaten Bangka -1.74501 105.9524 0 Asia/Jakarta populated place
6966841 Kautu Kautu ID Central Sulawesi Kabupaten Banggai Kepulauan -1.2814 123.3253 0 Asia/Makassar populated place
6560528 Puntukngluwah Puntukngluwah ID Central Java Kabupaten Karanganyar -7.71722 111.03056 0 Asia/Jakarta populated place
6370515 Gumelar Kidul Gumelar Kidul ID Central Java Kabupaten Banyumas -7.61667 109.39 0 Asia/Jakarta populated place
6915939 Wiramosoko Wiramosoko ID Southeast Sulawesi Kabupaten Konawe -3.9196 122.105 0 Asia/Makassar populated place
6605755 Sukabandung Sukabandung ID West Java -6.30306 106.45389 0 Asia/Jakarta populated place
6200706 Bendo ID Central Java Kabupaten Temanggung -7.32278 110.19 0 Asia/Jakarta populated place
8434363 Jongger Jongger ID East Nusa Tenggara Kabupaten Sikka -8.299 121.7298 0 Asia/Makassar populated place
6390662 Sambiasa Sambiasa ID Central Java Kabupaten Purbalingga -7.32278 109.305 0 Asia/Jakarta populated place
8018022 Leuwiseeng Leuwiseeng ID West Java Kabupaten Tasikmalaya -7.3432 108.0961 0 Asia/Jakarta populated place
7781155 Panggilingan Panggilingan ID Banten Kabupaten Pandeglang -6.3134 105.9627 0 Asia/Jakarta populated place
6597668 Kaumpandak Satu Kaumpandak 1,Kaumpandak Satu ID West Java Kabupaten Bogor -6.52222 106.80417 0 Asia/Jakarta populated place
7058581 Lawi Lawi ID East Nusa Tenggara Kabupaten Manggarai Barat -8.5455 120.3512 0 Asia/Makassar populated place
1962191 Cikupa Cikuda,Cikupa,Tjikuda ID West Java Kabupaten Bandung Barat -6.99389 107.28 0 Asia/Jakarta populated place
7609182 Tamendale Tamendale ID South Sulawesi Kabupaten Enrekang -3.489 119.863 0 Asia/Makassar populated place
6840828 Sorok Sorok ID East Java Kabupaten Pamekasan -7.224 113.4941 0 Asia/Jakarta populated place
1938346 Nunhala ID East Nusa Tenggara Kabupaten Timor Tengah Utara -9.37167 124.75389 0 Asia/Makassar populated place
6782213 Deket Deket ID East Java Kabupaten Lamongan -7.1992 112.2764 0 Asia/Jakarta populated place
7666494 Korongrejo Korongrejo ID Lampung Kabupaten Pesawaran -5.33894 105.08352 0 Asia/Jakarta populated place
6405299 Susuhan Susuhan ID East Java Kabupaten Pacitan -8.0475 111.16028 0 Asia/Jakarta populated place
6755543 Beringinindah Beringinindah ID North Sulawesi Kota Manado 1.4857 124.8642 0 Asia/Makassar populated place
6386937 Ngepoh Ngepoh ID East Java Kabupaten Pacitan -8.10444 111.04722 0 Asia/Jakarta populated place
6591750 Cikereti Cikereti ID West Java Kabupaten Bandung Barat -6.91167 107.36917 0 Asia/Jakarta populated place
6791487 Genjah Genjah ID Central Java Kabupaten Pekalongan -7.068 109.689 0 Asia/Jakarta populated place
6837922 Jlopo Jlopo ID East Java Kabupaten Mojokerto -7.5627 112.5791 0 Asia/Jakarta populated place
7589091 Tassalilu Tassalilu ID South Sulawesi Kabupaten Pinrang -3.9781 119.6102 0 Asia/Makassar populated place
6411229 Cangkring Cangkring ID Central Java Kabupaten Grobogan -7.12944 110.93667 0 Asia/Jakarta populated place
6838649 Sumur Sumur ID East Java Kabupaten Probolinggo -7.8719 113.1831 0 Asia/Jakarta populated place
6585050 Cipulus Cipulus ID West Java Kabupaten Bandung Barat -6.80111 107.41944 0 Asia/Jakarta populated place
6751759 Saukang Saukang ID South Sulawesi Kabupaten Sinjai -5.2315 120.0863 0 Asia/Makassar populated place
6983667 Tatarandang Tatarandang ID Central Sulawesi Kabupaten Banggai Kepulauan -1.5372 122.8887 0 Asia/Makassar populated place
6565741 Krajan Krajan ID Central Java Kabupaten Purworejo -7.66444 109.83528 0 Asia/Jakarta populated place
2011178 Sejaran ID Yogyakarta Kabupaten Kulon Progo -7.82833 110.15222 0 Asia/Jakarta populated place
8021065 Cinyuncung Cinyuncung ID West Java Kabupaten Tasikmalaya -7.7363 108.2268 0 Asia/Jakarta populated place
1972812 Gunung Gunung,Gunungbantal ID Central Java Kabupaten Semarang -7.23389 110.62056 0 Asia/Jakarta populated place
6726486 Sirait Sirait ID North Sumatra Kabupaten Toba Samosir 2.4639 99.1409 0 Asia/Jakarta populated place
6603839 Cikupa Cikupa ID West Java Kabupaten Sukabumi -6.79361 106.72583 0 Asia/Jakarta populated place
6590105 Pasiroray Pasiroray ID West Java Kabupaten Cianjur -6.67111 107.20694 0 Asia/Jakarta populated place
8527664 Jumako Jumako ID Highland Papua Kabupaten Pegunungan Bintang -4.80466 140.58706 0 Asia/Jayapura populated place
6753311 Sukaupih Sukaupih ID Banten Kabupaten Pandeglang -6.2647 106.1311 0 Asia/Jakarta populated place
6778530 Jajangan Jajangan ID East Java Kabupaten Probolinggo -7.94 113.1304 0 Asia/Jakarta populated place
1934868 Duwetan ID Central Java Kabupaten Karanganyar -7.66056 110.97722 0 Asia/Jakarta populated place
6812386 Wijahan Wijahan ID Central Java Kabupaten Brebes -6.9897 108.9846 0 Asia/Jakarta populated place
8018321 Cijati Cijati,Tjidjati ID West Java Kabupaten Garut -7.0479 108.0488 0 Asia/Jakarta populated place
6996606 Mosolo Mosolo ID Southeast Sulawesi Kabupaten Konawe Kepulauan -4.2108 123.1633 0 Asia/Makassar populated place
8046193 Cikareo Cikareo ID West Java Kota Tasikmalaya -7.3393 108.2599 0 Asia/Jakarta populated place
6881747 Tanggel Tanggel ID Central Java Kabupaten Pati -6.7959 111.1128 0 Asia/Jakarta populated place
7035231 Rejoketon Rejoketon ID East Java Kabupaten Blitar -8.0286 112.2807 0 Asia/Jakarta populated place
6702388 Kampung Manggis Kampung Manggis,Manggis 1 ID North Sumatra Kabupaten Serdang Bedagai 3.3521 99.2548 0 Asia/Jakarta populated place
8363248 Umbulan Picada Umbulan Picada ID Lampung Kabupaten Way Kanan -4.40037 104.94476 0 Asia/Jakarta populated place
8420929 Yatama Yatama ID East Nusa Tenggara Kabupaten Alor -8.2761 124.6318 0 Asia/Makassar populated place
6567989 Cipeuris Dua Cipeuris Dua,Cipeuris II ID West Java Kabupaten Subang -6.60639 107.77417 0 Asia/Jakarta populated place
1636403 Manggung Kidul Manggung,Manggung Kidul ID Central Java Kabupaten Boyolali -7.49861 110.77889 0 Asia/Jakarta populated place
6882504 Ngembes Ngembes ID East Java Kabupaten Lamongan -7.236 112.1735 0 Asia/Jakarta populated place
1625642 Tafaga Tafaga ID North Maluku Kota Ternate 0.44355 127.43231 0 Asia/Jayapura populated place
1641660 Kampunggunung Kampoenggoenoeng,Kampoenggoenoeng 2,Kampoenggoenoeng 3,Kampoenggoenoeng 4,Kampunggunung,Kampunggunung Dua ID Banten Kota Tangerang Selatan -6.3086 106.7696 0 Asia/Jakarta populated place
7376166 Banjar Dasong Banjar Dasong ID Bali Kabupaten Gianyar -8.4225 115.2574 0 Asia/Makassar populated place
7036525 Gundik Gundik ID East Java Kabupaten Lamongan -7.0417 112.4202 0 Asia/Jakarta populated place
6743345 Tombolo Tombolo ID South Sulawesi Kabupaten Bantaeng -5.51401 120.03543 0 Asia/Makassar populated place
6255659 Sidorejotati ID Central Java Kabupaten Wonogiri -7.97444 110.90944 0 Asia/Jakarta populated place
6889748 Kedungperahu Kedungperahu ID Central Java Kabupaten Blora -6.9259 111.1474 0 Asia/Jakarta populated place
6724551 Balai Jaring Balai Jaring,Balaidjaring ID Riau Kabupaten Kampar 0.3818 101.0849 0 Asia/Jakarta populated place
7035876 Rawagi Rawagi ID East Java Kabupaten Bojonegoro -7.1401 111.6129 0 Asia/Jakarta populated place
6865438 Simo Simo ID East Java Kabupaten Tuban -7.13072 111.93146 0 Asia/Jakarta populated place
1934085 Gabangan ID Central Java Kabupaten Sukoharjo -7.635 110.78444 0 Asia/Jakarta populated place
6408597 Baca Baca ID East Java Kabupaten Ngawi -7.51833 111.15861 0 Asia/Jakarta populated place
8314900 Watubawang Watubawang ID East Java Kabupaten Trenggalek -8.2039 111.5671 0 Asia/Jakarta populated place
7053899 Tempurejo Tempurejo ID East Java Kabupaten Banyuwangi -8.4585 114.1851 0 Asia/Jakarta populated place
6836040 Segodorejo Segodorejo ID East Java Kabupaten Jombang -7.5248 112.3303 0 Asia/Jakarta populated place
6725857 Parsibahulan Parsibahulan ID North Sumatra Kabupaten Simalungun 3.0465 98.7292 0 Asia/Jakarta populated place
6585167 Ciseureuh Ciseureuh ID West Java Kabupaten Bandung Barat -6.83778 107.44278 0 Asia/Jakarta populated place
8060970 Seren Timur Seren Timur ID Central Java Kabupaten Rembang -6.7572 111.3365 0 Asia/Jakarta populated place
8076325 Pakiringan Kulon Pakiringan Kulon ID Central Java Kabupaten Cilacap -7.2556 108.82 0 Asia/Jakarta populated place
7863426 Umbulalirahman Umbulalirahman ID Lampung Kabupaten Lampung Tengah -5.09538 104.64879 0 Asia/Jakarta populated place
7564250 Galang Galang ID East Nusa Tenggara Kabupaten Manggarai Barat -8.649 120.0284 0 Asia/Makassar populated place
6388547 Kalitapen Kalitapen ID Central Java Kabupaten Banyumas -7.46278 109.10694 0 Asia/Jakarta populated place
12197153 Watgalih Utara ID Central Java Kabupaten Pemalang -6.91848 109.41633 0 Asia/Jakarta populated place
6388814 Kalimanggis Selatan Kalimanggis Selatan ID Central Java Kabupaten Banyumas -7.40611 109.13861 0 Asia/Jakarta populated place
2011908 Setran ID Yogyakarta Kabupaten Sleman -7.76639 110.23278 0 Asia/Jakarta populated place
6583451 Cisalak Cisalak ID West Java Kabupaten Bandung Barat -6.84056 107.50028 0 Asia/Jakarta populated place
6701332 Kutabatu Kutabatu ID North Sumatra Kabupaten Deli Serdang 3.3897 98.5457 0 Asia/Jakarta populated place
1935198 Gondangselamat ID Central Java Kabupaten Sragen -7.51111 110.97222 0 Asia/Jakarta populated place
7743629 Baru Siambaton Baru Siambaton ID North Sumatra Kabupaten Simalungun 2.83 98.787 0 Asia/Jakarta populated place
1970135 Gilih Gili-barat,Gilih ID East Java Kabupaten Bangkalan -7.1488 112.7013 0 Asia/Jakarta populated place
7409590 Patek Patek ID East Java Kabupaten Situbondo -7.7037 114.0856 0 Asia/Jakarta populated place
7085962 Buwuh Buwuh ID West Nusa Tenggara Kabupaten Lombok Tengah -8.7035 116.3257 0 Asia/Makassar populated place
6780771 Pule Pule ID East Java Kabupaten Trenggalek -7.975 111.7062 0 Asia/Jakarta populated place
6404838 Jlamprang Jlamprang ID East Java Kabupaten Pacitan -8.12417 110.91194 0 Asia/Jakarta populated place
7385705 Asa Asa ID South Sulawesi Kabupaten Tana Toraja -3.037 119.8257 0 Asia/Makassar populated place
1990353 Samoja ID West Java -6.21667 106.30778 0 Asia/Jakarta populated place
7545185 Solong Solong ID East Java Kabupaten Banyuwangi -8.1839 114.3807 0 Asia/Jakarta populated place
6827837 Jambean Kidul Jambean Kidul ID Central Java Kabupaten Jepara -6.5766 110.7057 0 Asia/Jakarta populated place
1965698 Sagalaherang Sagalaherang,Sagataherang ID West Java Kabupaten Bandung -7.01972 107.72917 0 Asia/Jakarta populated place
8391567 Nekmates Nekmates ID East Nusa Tenggara Kabupaten Kupang -10.32907 123.71736 0 Asia/Makassar populated place

Indonesia: Charting the Archipelago with Precision and Passion

An Archipelago of Infinite Stories

Indonesia is not merely a country—it is a breathtaking expanse of over 17,000 islands scattered like emeralds across the equator. From Sumatra to Papua, Java to Sulawesi, each island offers a unique geographical narrative that demands documentation, understanding, and admiration. For a geographer, Indonesia represents both a challenge and a calling: how can one capture the complexity of such a vast and fragmented territory without losing sight of the local depth?

This is where my curated dataset becomes essential—a powerful resource designed to organize and present city-level information across the Indonesian archipelago. Every city is catalogued with its corresponding province and regency, and accompanied by its precise latitude and longitude. But more than just a static repository, this database is a living tool, available in various formats—most notably Excel (.xlsx), recently added in response to growing demand.

Decoding Indonesia Through Its Administrative Layers

Indonesia’s administrative structure is a layered reflection of its diversity. It comprises 38 provinces, which further divide into regencies (kabupaten) and cities (kota). These subdivisions are more than bureaucratic segments—they are the framework upon which Indonesia’s social, cultural, and economic life is built.

My dataset respects and reflects this structure in full. Each city entry is matched with its regional and departmental affiliations, allowing researchers and analysts to work with data that is both granular and structured. Whether you are studying regional development, migration trends, or climate vulnerability, such context is indispensable.

Latitude, Longitude, and the Power of Geospatial Clarity

Without accurate geographic coordinates, our understanding of Indonesia would remain two-dimensional. In a nation defined by coastlines, volcanoes, and rainforests, location is everything. The inclusion of latitude and longitude for each city ensures a geospatial framework that supports visualization, mapping, and even AI-driven modeling.

But this geospatial detail is only as powerful as the format in which it’s presented.

Excel: Unlocking Accessibility and Functionality

While the dataset is available in CSV, SQL, JSON, and XML formats, the introduction of Excel (.xlsx) marks a pivotal improvement in usability. Excel offers a balance of simplicity and power—it is accessible to those outside the realm of hardcore data science, yet flexible enough for advanced sorting, filtering, and pivot analysis.

Each Excel file in this collection is meticulously structured: city names, provinces, regencies, and GPS coordinates, all aligned in clean columns. Analysts can immediately begin working with the data—no conversions, no formatting hurdles, just instant clarity. Whether you’re running a feasibility study for infrastructure development in Kalimantan or tracing urban expansion in Bali, Excel is the ideal launchpad.

Formats for Every Environment

In addition to Excel, the dataset is packaged in machine-readable formats like JSON and XML, ideal for developers building applications or visual dashboards. SQL is available for integration into geographic databases, while CSV serves as a universal option for light data work or quick analysis. Consistency across these formats guarantees that no matter your workflow, the data is dependable, complete, and ready to deploy.

A Strategic Asset for the Future of Indonesia

Indonesia’s trajectory is one of rapid urbanization, shifting coastlines, and rising economic ambitions. Understanding where cities are—and how they relate to administrative zones—is critical to planning everything from logistics routes to disaster relief systems. This is why data matters more than ever.

My database is not just a geographic tool—it’s an invitation to approach Indonesia with the precision it deserves. It helps researchers connect the macro patterns with micro realities, policy-makers to act with clarity, and entrepreneurs to discover overlooked growth centers.

Conclusion: Where Passion Meets Precision

To chart Indonesia is to embrace complexity with discipline and wonder. With this new data offering—now including Excel format alongside CSV, SQL, JSON, and XML—I offer not just a dataset, but a foundation for deeper understanding. Indonesia’s geography is not static. It’s a living, breathing entity. And with the right tools, we can finally map it in a way that does justice to its richness.

Download Indonesia cities in Excel SQL CSV JSON XML

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

List of countries :

download-cities-data.org