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

Japan
Japan
Excel, CSV, SQL, XML, JSON

Last update : 23 March 2026.

Country
Japan
Capital
Tokyo
Number of cities
31356
Download
Click here

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

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 Japan is Tokyo.


Geoname_IDCityAlternate_NameCountry_Code RegionSub_regionLatitudeLongitude ElevationPopulationTimezoneFcode_Name
1861142 Iyogawa Ishigawa,Iyogawa JP Tokushima Miyoshi Shi 33.95 133.75 0 Asia/Tokyo populated place
2112841 Hagino Hagino,qiu ye,萩野 JP Yamagata Shinjō Shi 38.81667 140.36667 0 Asia/Tokyo populated place
11027574 Kamiochiai Kamiochiai,kamiochiai,shang luo he,かみおちあい,カミオチアイ,上落合 JP Saitama Saitama-shi 35.89406 139.62524 0 Asia/Tokyo populated place
8601720 Naze-nakagachi Naze-nakagachi,ming lai zhong sheng,名瀬仲勝 JP Kagoshima Amami Shi 28.38944 129.52858 0 Asia/Tokyo populated place
1861446 Iseji Iseji,Naise,yi shi lu,伊勢路 JP Mie Watarai-gun 34.33333 136.63333 0 Asia/Tokyo populated place
8428558 Sunakozawa Sunakozawa,sha xiao ze,sunakozawa,すなこざわ,スナコザワ,砂小沢 JP Akita Kazuno-gun 40.368 140.74753 0 Asia/Tokyo populated place
8395487 Mizuhami Mizuhami,mizuhami,shui can,みずはみ,ミズハミ,水喰 JP Aomori Kamikita-gun 40.82862 141.27326 0 Asia/Tokyo populated place
1864827 Banbachō Babacho,Babachō,Bamba-cho,Bamba-chō,Banbacho,Banbachō,Sugiyamacho,Sugiyamachō,ma chang ding,馬場町 JP Ōsaka Osaka-shi 34.68213 135.52239 0 Asia/Tokyo populated place
11191662 Gunchiku-jūbanchō Gunchiku-jubancho,Gunchiku-jūbanchō,gunchikujuubanchou,jun zhu shi fan ding,ぐんちくじゅうばんちょう,グンチクジュウバンチョウ,郡築十番町 JP Kumamoto Yatsushiro Shi 32.5464 130.57828 0 Asia/Tokyo populated place
2111909 Mirumaemachi Higashi-mirumae,Mirumaemachi JP Iwate Morioka-shi 39.63333 141.18333 0 Asia/Tokyo populated place
8183953 Ōgai Ogai,da bei,oogai,Ōgai,おおがい,オオガイ,大貝 JP Miyagi Miyagi Gun 38.36505 141.02332 0 Asia/Tokyo populated place
11060714 Namiki Namiki,bing mu,namiki,なみき,ナミキ,並木 JP Kanagawa Yokohama Shi 35.36415 139.63919 0 Asia/Tokyo populated place
11029726 Magamoto Magamoto,magamoto,qu ben,まがもと,マガモト,曲本 JP Saitama Saitama-shi 35.83638 139.63634 0 Asia/Tokyo populated place
8506081 Tominaga Tominaga,fu yong,tominaga,とみなが,トミナガ,富永 JP Aomori Aomori Shi 40.82073 140.71783 0 Asia/Tokyo populated place
8527970 Etsumori Etsumori,etsumori,hui jin sen,えつもり,エツモリ,恵津森 JP Iwate Kunohe-gun 40.18453 141.41127 0 Asia/Tokyo populated place
2129639 Kashiwagimachi Kashiwagi,Kashiwagimachi,bai mu ding,kashiwagimachi,かしわぎまち,カシワギマチ,柏木町 JP Aomori Hirakawa Shi 40.58049 140.56911 0 Asia/Tokyo populated place
9819607 Hosono Hosono,xi ye,細野 JP Iwate Hachimantai Shi 40.03148 140.97196 0 Asia/Tokyo populated place
1848243 Yorii Yorii,ji ju,寄居 JP Saitama Ōsato-gun 36.11567 139.19429 32851 Asia/Tokyo populated place
1852667 Seto Seto JP Nagasaki 32.93333 129.63333 0 Asia/Tokyo populated place
9629445 Kitashiodani Kitashiodani,bei yan gu,北塩谷 JP Nara Yoshino-gun 34.34565 135.95505 0 Asia/Tokyo populated place
6822134 Hamura Hamura,Hamura-chhi,Hamura-chhī,Khamura,ha mu ra,hamula si,hamwra,hamwra twkyw,yu cun,yu cun shi,Хамура,Ҳамура,Համուրա,هامورا,هامورا، توکیو,ฮะมุระ,羽村,羽村市,하무라 시 JP Tokyo Nishitama-gun 35.79072 139.33889 0 Asia/Tokyo populated place
1852240 Shimo-nii JP Nagano Matsumoto Shi 36.22475 137.92219 0 Asia/Tokyo populated place
10317566 Yokoshiro-minamimachi Yokoshiro-minamimachi,heng dai nan ding,横代南町 JP Fukuoka Kitakyushu-shi 33.82772 130.89204 0 Asia/Tokyo populated place
1926078 Nakatama Nakadama,zhong yu,中玉 JP Ehime Minamiuwa-gun 32.92286 132.62339 0 Asia/Tokyo populated place
1860388 Kami-wakago Kami-wakogo,Kami-wakōgo,Wakogo JP Fukui Ōno-shi 35.89878 136.53002 0 Asia/Tokyo populated place
10467405 Nakazato Nakazato,zhong li,中里 JP Shizuoka Fuji Shi 35.16228 138.73391 0 Asia/Tokyo populated place
11404947 Nakai Nakai,nakai,zhong zhu,なかい,ナカイ,中猪 JP Kumamoto Kuma-gun 32.27594 131.00613 0 Asia/Tokyo populated place
9635308 Hino Hino,ri ye,日野 JP Kyoto Kyōto-shi 34.93601 135.81656 0 Asia/Tokyo populated place
8552692 Origanai Origanai,juke nei,origanai,おりがない,オリガナイ,居ヶ内 JP Aomori Sannohe Gun 40.37019 141.1404 0 Asia/Tokyo populated place
11072703 Miyagi JP Okinawa Urasoe Shi 26.25372 127.69894 0 Asia/Tokyo populated place
1854035 Onnagawa Onnagawa,nu chuan,女川 JP Akita Oga-shi 39.86667 139.81667 0 Asia/Tokyo populated place
8599793 Kamitsushimachō-tomigaura Kamitsushimacho-tomigaura,Kamitsushimachō-tomigaura,shang dui ma ding fu pu,上対馬町富浦 JP Nagasaki Tsushima Shi 34.63197 129.47927 0 Asia/Tokyo populated place
1852370 Shimoakisato Akisato,Shimo-akisato,Shimoakisato,xia qiu li,下秋里 JP Hyōgo Sayō-gun 34.96351 134.31867 0 Asia/Tokyo populated place
2112188 Makinosaki Kobuchi-hanto,Kobuchi-hantō,Magino-saki,Makino-saki,Makinosaki,makinosaki,muno qi,まきのさき,マキノサキ,牧ノ崎 JP Miyagi Ishinomaki Shi 38.31657 141.46249 0 Asia/Tokyo populated place
1852209 Shimoōzuchō Shimo-otsu,Shimo-ozu,Shimo-ōtsu,Shimo-ōzu,Shimoozucho,Shimoōzuchō,xia da jin ding,下大津町 JP Nagasaki Gotō Shi 32.68333 128.85 0 Asia/Tokyo populated place
11761168 Minamirokujō Minamirokujo,Minamirokujō,minamirokujou,nan liu tiao,みなみろくじょう,ミナミロクジョウ,南六条 JP Hokkaido Shibetsu-gun 43.6527 145.13218 0 Asia/Tokyo populated place
11114234 Shakayatsu Shakayatsu,shakayatsu,shi jia gu,しゃかやつ,シャカヤツ,釈迦谷 JP Chiba Isumi Shi 35.23368 140.37455 0 Asia/Tokyo populated place
9277775 Noma-ōhara Noma-ohara,Noma-ōhara,ye jian da yuan,野間大原 JP Ōsaka Toyono Gun 34.94593 135.46861 0 Asia/Tokyo populated place
8477067 Tomioka Tomioka,fu gang,tomioka,とみおか,トミオカ,富岡 JP Aomori Tsugaru Shi 40.79636 140.38041 0 Asia/Tokyo populated place
8662199 Kawachimachi-nakanomi Kawachimachi-nakanomi,he nei ding zhong zhi hai,河内町中直海 JP Ishikawa Hakusan Shi 36.38801 136.63735 0 Asia/Tokyo populated place
11473878 Katamusari Katamusari,katamusari,pian wu qu,かたむさり,カタムサリ,片無去 JP Hokkaido Akkeshi-gun 43.10761 144.70458 0 Asia/Tokyo populated place
1860706 Kakizaki JP Niigata Jōetsu Shi 37.28333 138.4 0 Asia/Tokyo populated place
11446620 Wakamatsuchō Wakamatsucho,Wakamatsuchō,ruo song ting,wakamatsuchou,わかまつちょう,ワカマツチョウ,若松町 JP Hokkaido Kushiro Shi 42.99333 144.38357 0 Asia/Tokyo populated place
1851331 Tabaru Kujuno,Tabaru JP Oita Taketa-shi 32.88333 131.31667 0 Asia/Tokyo populated place
8543120 Izumi Izumi,he quan,izumi,いずみ,イズミ,和泉 JP Aomori Minamitsugaru Gun 40.64694 140.52682 0 Asia/Tokyo populated place
8183792 Mugita Mugita,mai tian,mugita,むぎた,ムギタ,麦田 JP Miyagi Miyagi Gun 38.38945 141.04084 0 Asia/Tokyo populated place
2128233 Setarai Setarai,lai duo lai,setarai,せたらい,セタライ,瀬多来 JP Hokkaido Tokachi-gun 42.9597 143.58873 0 Asia/Tokyo populated place
9290083 Kamiakotani Kamiakotani,shang a gu gu,上阿古谷 JP Hyōgo Kawanabe-gun 34.93919 135.38182 0 Asia/Tokyo populated place
8315967 Senshū-kitanomaru Senshu-kitanomaru,Senshū-kitanomaru,qian qiu beino wan,senshuukitanomaru,せんしゅうきたのまる,センシュウキタノマル,千秋北の丸 JP Akita Akita Shi 39.72587 140.12523 0 Asia/Tokyo populated place
11171628 Hamaogi Hamaogi,bang di,hamaogi,はまおぎ,ハマオギ,浜荻 JP Chiba Kamogawa-shi 35.12277 140.14182 0 Asia/Tokyo populated place
8507073 Tokuge Tokuge,de xia,tokuge,とくげ,トクゲ,徳下 JP Aomori Minamitsugaru Gun 40.66865 140.55358 0 Asia/Tokyo populated place
11189185 Takakura gao cang,高倉 JP Saitama Iruma-shi 35.83744 139.38051 0 Asia/Tokyo populated place
9187722 Hanageishimachi Hanageishimachi,bi mao shi ding,鼻毛石町 JP Gunma Maebashi Shi 36.44141 139.17721 0 Asia/Tokyo populated place
9891861 Miyazaki Miyazaki,gong qi,宮崎 JP Fukuoka Ōmuta Shi 33.083 130.47649 0 Asia/Tokyo populated place
8476981 Tanaka Tanaka,tanaka,tian zhong,たなか,タナカ,田中 JP Aomori Goshogawara Shi 40.8089 140.485 0 Asia/Tokyo populated place
10413272 Midorichō Midoricho,Midorichō,lu ding,緑町 JP Kanagawa Hadano-shi 35.37619 139.21081 0 Asia/Tokyo populated place
10353111 Takakura Takakura,gao cang,高倉 JP Fukuoka Iizuka Shi 33.60722 130.76151 0 Asia/Tokyo populated place
9096479 Asahioka Asahioka,xu gang,旭岡 JP Hokkaido Yūfutsu-gun 42.6091 142.07252 0 Asia/Tokyo populated place
8572451 Hasunuma Hasunuma,hasunuma,lian zhao,はすぬま,ハスヌマ,蓮沼 JP Saitama Saitama-shi 35.92763 139.66387 0 Asia/Tokyo populated place
11079752 Kushi Kushi,jiu zhi,kushi,くし,クシ,久枝 JP Chiba Minamibōsō Shi 35.09616 139.84231 0 Asia/Tokyo populated place
10988905 Matsunami Matsunami,song bing,松並 JP Ibaraki Moriya-shi 35.96102 139.99436 0 Asia/Tokyo populated place
1858911 Komatsu Komatsu,xiao song,小松 JP Yamaguchi Ōshima-gun 33.93333 132.2 0 Asia/Tokyo populated place
10430192 Midorigaoka Midorigaoka,luke qiu,緑ヶ丘 JP Kanagawa Atsugi Shi 35.45267 139.3414 0 Asia/Tokyo populated place
1863598 Gohyakkoku Gohyakkoko,Gohyakkoku,wu bai shi,五百石 JP Toyama Nakaniikawa Gun 36.66411 137.31665 0 Asia/Tokyo populated place
10317604 Tsuda-minamimachi Tsuda-minamimachi,jin tian nan ding,津田南町 JP Fukuoka Kitakyushu-shi 33.82404 130.91658 0 Asia/Tokyo populated place
8506075 Nishiōno Nishiono,Nishiōno,nishioono,xi da ye,にしおおの,ニシオオノ,西大野 JP Aomori Aomori Shi 40.80154 140.72414 0 Asia/Tokyo populated place
8315659 Sotoasahikawa-yatsuyanagi Sotoasahikawa-yatsuyanagi,sotoasahikawayatsuyanagi,wai xu chuan ba liu,そとあさひかわやつやなぎ,ソトアサヒカワヤツヤナギ,外旭川八柳 JP Akita Akita Shi 39.74589 140.09811 0 Asia/Tokyo populated place
8182488 Shimizusawa Shimizusawa,qing shui ze,shimizusawa,しみずさわ,シミズサワ,清水沢 JP Miyagi Higashimatshushima Shi 38.44639 141.19191 0 Asia/Tokyo populated place
6417150 Higai JP Ehime Imabari-shi 34.275 132.995 0 Asia/Tokyo populated place
11334039 Izumimachi Izumimachi,izumimachi,quan ting,いずみまち,イズミマチ,泉町 JP Kumamoto Yamaga Shi 33.01617 130.68563 0 Asia/Tokyo populated place
8552718 Takamatsu Takamatsu,gao song,takamatsu,たかまつ,タカマツ,高松 JP Aomori Sannohe Gun 40.37065 141.17039 0 Asia/Tokyo populated place
11246016 Amakusamachi-ōemukō Amakusamachi-oemuko,Amakusamachi-ōemukō,amakusamachiooemukou,tian cao ding da jiang xiang,あまくさまちおおえむこう,アマクサマチオオエムコウ,天草町大江向 JP Kumamoto Amakusa Shi 32.26875 129.9868 0 Asia/Tokyo populated place
8663733 Jabami Jabami,she can,蛇喰 JP Toyama Nanto Shi 36.53516 136.93508 0 Asia/Tokyo populated place
1863134 Harimochi JP Kagoshima Isa Shi 31.96667 130.58333 0 Asia/Tokyo populated place
9633285 Gakuen-naka Gakuen-naka,xue yuan zhong,学園中 JP Nara Nara-shi 34.69613 135.74823 0 Asia/Tokyo populated place
8441454 Ōsawanai Osawanai,da ze nei,oosawanai,Ōsawanai,おおさわない,オオサワナイ,大沢内 JP Aomori Kitatsugaru Gun 40.93931 140.43904 0 Asia/Tokyo populated place
8438344 Taishidō Taishido,Taishidō,da shi tang,taishidou,たいしどう,タイシドウ,大師堂 JP Iwate Hanamaki Shi 39.42357 141.07726 0 Asia/Tokyo populated place
10419882 Okazaki Okazaki,gang qi,岡崎 JP Kanagawa Hiratsuka Shi 35.37497 139.30623 0 Asia/Tokyo populated place
8529111 Yanagisawa Yanagisawa,liu ze,yanagisawa,やなぎさわ,ヤナギサワ,柳沢 JP Iwate Ninohe Shi 40.30973 141.26913 0 Asia/Tokyo populated place
6417270 Enoura JP Hiroshima Onomichi-shi 34.36333 133.19333 0 Asia/Tokyo populated place
8563547 Ippaimori Ippaimori,ippaimori,yi bei sen,いっぱいもり,イッパイモリ,一盃森 JP Aomori Hachinohe Shi 40.50111 141.4727 0 Asia/Tokyo populated place
10266457 Shin’yamazaki Shin’yamazaki,Shin’yamazaki,xin shan qi,新山崎 JP Fukuoka Kuraten-gun 33.70906 130.70027 0 Asia/Tokyo populated place
8661317 Mikunichō-jingaoka Mikunicho-jingaoka,Mikunichō-jingaoka,san guo ding zhenke gang,三国町陣ヶ岡 JP Fukui Sakai-shi 36.2349 136.14186 0 Asia/Tokyo populated place
1848918 Wakinomachi Wakino,Wakinomachi,xie ye ding,脇野町 JP Niigata Nagaoka Shi 37.49958 138.78736 0 Asia/Tokyo populated place
8204907 Sakanamachi Sakanamachi,sakanamachi,yu ding,さかなまち,サカナマチ,魚町 JP Miyagi Kesennuma Shi 38.90717 141.57624 0 Asia/Tokyo populated place
8183281 Takadera Takadera,gao si,takadera,たかでら,タカデラ,高寺 JP Miyagi Miyagi Gun 38.415 141.07193 0 Asia/Tokyo populated place
1852268 Shimo-kuranaga JP Miyazaki Miyazaki-shi 31.93333 131.35 0 Asia/Tokyo populated place
1850808 Takibe JP Yamaguchi Shimonoseki Shi 34.28333 130.95 0 Asia/Tokyo populated place
1859896 Kasuga Kasuga,chun ri,春日 JP Nagano Saku Shi 36.21667 138.35 0 Asia/Tokyo populated place
9637709 Hō’ōji Ho’oji,Hō’ōji,feng huang si,鳳凰寺 JP Mie Iga-shi 34.76612 136.22552 0 Asia/Tokyo populated place
1907249 Teradanawa Teradanawa,si tian ying,寺田縄 JP Kanagawa Hiratsuka Shi 35.35932 139.31623 0 Asia/Tokyo populated place
9893765 Takashimach-satomen Takashimach-satomen,ying dao ding li mian,鷹島町里免 JP Nagasaki Matsuura Shi 33.44255 129.75345 0 Asia/Tokyo populated place
1852055 Shinokawa Shinokawa,xiao chuan,篠川 JP Kagoshima Ōshima-gun 28.22708 129.2947 0 Asia/Tokyo populated place
1849959 Torisawa Tomihama,Torisawa,Torizawa JP Yamanashi Ōtsuki-shi 35.6 139 0 Asia/Tokyo populated place
8463329 Nakayama Nakayama,nakayama,zhong shan,なかやま,ナカヤマ,中山 JP Aomori Shimokita-gun 41.5266 140.91633 0 Asia/Tokyo populated place
10905269 Nekozane Nekozane,mao shi,猫実 JP Chiba Urayasu-shi 35.66035 139.89919 0 Asia/Tokyo populated place
8742108 Onadani Onadani,nu gu,女谷 JP Niigata Kashiwazaki Shi 37.24778 138.54897 0 Asia/Tokyo populated place
11559476 Nishikimachi Nishikimachi,jin ting,nishikimachi,にしきまち,ニシキマチ,錦町 JP Hokkaido Nakagawa-gun 42.90585 143.35437 0 Asia/Tokyo populated place
1851567 Sōtarō Sotaro,Sōtarō JP Miyazaki Nobeoka-shi 32.76667 131.7 0 Asia/Tokyo populated place
11449163 Akanchō-higashishitakara Akancho-higashishitakara,Akanchō-higashishitakara,a han ting dong she xin,akanchouhigashishitakara,あかんちょうひがししたから,アカンチョウヒガシシタカラ,阿寒町東舌辛 JP Hokkaido Kushiro Shi 43.11367 144.15097 0 Asia/Tokyo populated place

Exploring Japan Through Geographic Precision: Cities, Coordinates, and the Power of Structured Data

A Land of Layers and Lattices

Japan is not just a country; it is a matrix of mountains, megacities, islands, and intricate administrative subdivisions. To view it from the eyes of a geographer is to engage with a masterpiece in motion—where the historical footprint of Edo meets the neon skyline of Shibuya, and where the topology of nature converses endlessly with the structures of society.

But to truly understand Japan, we must descend from the sweeping views and approach its towns and cities with analytical clarity. Every municipality, from remote fishing villages in Hokkaido to industrial ports in Kyushu, holds a geographic identity deeply tied to its prefecture and region. This is why building a robust dataset of Japan's cities—categorized by region, department, and geographic coordinates—is essential for any data-driven exploration of the archipelago.

The Prefectural Framework: Japan’s Spatial Backbone

Japan’s 47 prefectures serve as more than administrative divisions; they are cultural and economic ecosystems. Cities like Kyoto, Fukuoka, and Sapporo don’t exist in isolation—they function within prefectural frameworks that shape everything from local governance to disaster preparedness.

In our dataset, every Japanese city is assigned to its corresponding prefecture and broader region (e.g., Kansai, Tōhoku), preserving this vital spatial structure. This alignment ensures that geographic studies, market segmentation, and infrastructure planning remain contextually sound and administratively accurate.

Latitudes and Longitudes: Locating the Essence of Place

Precision is sacred in geographic science. That’s why every city in our Japan dataset is tagged with its unique latitude and longitude. This enables a vast range of spatial analysis, whether for climate modeling, transportation logistics, or demographic heatmaps. These coordinates serve as a digital fingerprint for each place—allowing researchers and analysts to locate, map, and model cities across all layers of software and analytical frameworks.

The Rise of Excel: Democratizing Access to Geographic Intelligence

While our data is available in various formats, including CSV, JSON, SQL, and XML, the recent inclusion of **Excel (xlsx)** has revolutionized how this information is accessed and applied. Excel brings the data into the hands of city planners, academic researchers, entrepreneurs, and civil engineers without the barrier of technical expertise.

It allows users to slice and filter the dataset by prefecture, population center, or even regional classification. Built-in sorting functions and pivot tools make Excel ideal for exploratory analysis, visual mapping, and scenario planning. This isn’t just about accessibility—it’s about making high-quality geographic data truly usable by all.

Multi-Format Versatility for the Analytical Ecosystem

Though Excel is the highlight, our dataset is engineered for interoperability. Formats include:

* **CSV**, for quick import into virtually any tool

* **SQL**, for direct injection into relational databases

* **JSON**, ideal for modern web platforms and data APIs

* **XML**, ensuring structured data compatibility with legacy systems

This ensures that your workflow—whether spreadsheet-based or code-driven—remains uninterrupted and fully empowered by consistent, clean data.

Urban Complexity in a Nation of Contrast

From the megaregions of Kanto and Kansai to the serene cities of Shikoku, Japan’s urban spectrum reflects economic dynamism, cultural diversity, and environmental adaptation. But such complexity requires structure—something our dataset provides. With every city mapped to its rightful regional and departmental context, decision-making becomes clearer, smarter, and grounded in geographic reality.

Whether you're launching an app that maps public services, designing climate resilience plans, or studying migration trends across Japan’s shrinking rural cities, having structured access to location data is non-negotiable.

Conclusion: Mapping Japan Beyond the Map

To map Japan is not to trace outlines—it is to understand relationships. Between cities and regions. Between coordinates and culture. Between raw data and real-world insight.

Our comprehensive database, now enriched with the Excel format, offers the most practical way to explore these relationships. It is more than just a collection of city names—it is a geographic key to one of the most complex and captivating nations on Earth.

With it, Japan unfolds not just on the screen, but in the spreadsheet—ready to be analyzed, understood, and appreciated.

Download Japan cities in Excel SQL CSV JSON XML

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

List of countries :

download-cities-data.org