Skip to product information
Japan Postal Codes, Streets & Address Database - CSV, Excel, SQL, XML

Japan Postal Codes, Streets & Address Database - CSV, Excel, SQL, XML

$29.00 USD
Select data level
Japan flag
Japan · All 47 prefectures

A structured, ready-to-use database of 120,046 postal codes and 1,885 cities across all 47 prefectures of Japan - instantly downloadable in CSV, Excel, SQL and XML.

Country data
120,046
Postal codes
1,885
Cities
47
Prefectures
Did you know?

The most common street name in Japan is Main street, appearing 124,084 times across the dataset.

Sample data preview

Switch tabs to preview each file.

↓ Download regions sample

Country CodeCountryRegionRegion2Region3Region4
JPJapanIwate PrefectureWayashiki Michinoue
JPJapanTottori prefectureYoshiya
JPJapanNiigata PrefectureAikawa Oritohama Town

↓ Download locations sample

CC Country Region City Postal
JPJapanIshikawa PrefectureSuzu City927 - 1317
JPJapanHokkaidoObihiro City080 - 0823
JPJapanChiba prefectureNoda City278 - 0017

↓ Download streets sample

CC Country Region City Postal Street Lat Lng Elevation (m) Geocoding Level Accuracy Radius (m)
JPJapanHokkaidoHidaka Town, Saru District055 - 0002Main street42.5316147142.041782511POSTAL_CODE5000
JPJapanShiga PrefectureNagahama City529 - 0354Main street35.4443490136.212449093POSTAL_CODE5000
JPJapanShimane PrefectureMatsue690 - 0860Main street34.2413916135.13054798CITY1000

↓ Download addresses sample

Country CodeCountryRegionCityPostal CodeStreetNumberLatitudeLongitudeElevation (m)
JPJapanTokyoMinato105 - 6120Main street35.2206546139.871966917
JPJapanChiba prefectureKimitsu City292 - 1144Main street35.2944100140.0132592233
JPJapanTokyoChiyoda Ward100 - 6335Main street35.1922943136.973171624

Formats & delivery

Available in SQL, Excel, CSV, GIS, SQLite, MySQL, PostgreSQL, SQL Server, KML, GeoJSON, Shapefile, Oracle, Access. Delivered by email within minutes of purchase. One complimentary refresh within 30 days.

Updated on September 28, 2026 · View sample data

Check delivery and refund policy here

You may also like