vendor-unknown
Japan Postal Code & Address Database - Excel, CSV, SQL Download
Japan Postal Code & Address Database - Excel, CSV, SQL Download
Couldn't load pickup availability
Japan Postal Code & Address Database - All 47 Prefectures
Access a complete postal code database for Japan with linked cities, streets, and address-level samples. Ready for geocoding, delivery routing, validation, and analytics.
✔ Instant download • ✔ Ready-to-use • ✔ No subscription required
Key Data Coverage
- 120,046 postal codes
- 1,885 cities
- Most common street: Main street (124,084 occurrences)
- 47 prefectures
Available Files
You can purchase one or more of the following datasets depending on your needs:
- Prefectures file - administrative prefectures and subdivisions
- Locations file - cities and postal codes
- Streets file - street-level data with geocoordinates
- Addresses file - address-level records with house numbers (where available)
Each file is available as a sample preview before purchase.
Sample Files Preview
Explore sample data from each dataset below. You can download the full sample file or preview a few rows directly.
Prefectures File
| Country Code | Country | Region | Region2 | Region3 | Region4 |
|---|---|---|---|---|---|
| JP | Japan | Ehime Prefecture | Mitsu | ||
| JP | Japan | Miyagi Prefecture | Ichihasama Yamazaki | ||
| JP | Japan | Saitama | Kamihinozawa |
Locations File
| Country Code | Country | Region | City | Postal Code |
|---|---|---|---|---|
| JP | Japan | Kyoto | Kameoka City | 621 - 0012 |
| JP | Japan | Niigata Prefecture | Uonuma City | 946 - 0007 |
| JP | Japan | Kyoto | Shimogyo Ward, Kyoto City | 600 - 8359 |
Streets File
| Country Code | Country | Region | City | Postal Code | Street | Latitude | Longitude | Elevation (m) | Geocoding Level | Accuracy Radius (m) |
|---|---|---|---|---|---|---|---|---|---|---|
| JP | Japan | Yamagata Prefecture | Sakegawa Village, Mogami District | 999 - 5201 | Main street | 38.8172692 | 140.2369981 | 60 | POSTAL_CODE | 5000 |
| JP | Japan | Akita | Daisen City | 019 - 2331 | Main street | 34.6717171 | 135.4302014 | 5 | CITY | 1000 |
| JP | Japan | Osaka | Minoo City | 562 - 0005 | Main street | 34.8281486 | 135.4584047 | 86 | POSTAL_CODE | 5000 |
Addresses File
| Country Code | Country | Region | City | Postal Code | Street | Number | Latitude | Longitude | Elevation (m) |
|---|---|---|---|---|---|---|---|---|---|
| JP | Japan | Gifu Prefecture | Gujo City | 501 - 5116 | Main street | 35.8893929 | 136.8873762 | 445 | |
| JP | Japan | Aomori Prefecture | Noheji-cho, Kamikita-gun | 039 - 3152 | Main street | 40.8579340 | 141.1193280 | 16 | |
| JP | Japan | Fukushima Prefecture | Koori Town, Date District | 969 - 1641 | Main street | 37.8638697 | 140.5228131 | 96 |
Sample data for preview purposes only.
What You Can Do With This Data
- Geocode postal codes for mapping and location services
- Validate and standardize customer addresses
- Optimize delivery and logistics routes using postal-code areas
- Perform market and catchment-area analysis by postal code
Format & Delivery
Files are available in CSV, Excel (XLSX), and SQL formats.
After purchase, you will receive a download link by email. The files are delivered in a compressed ZIP archive.
Updates & Support
Your purchase includes one free data update within one month upon request.
Secure Payment
Payments are secure and can be made via credit card, PayPal, or bank transfer. Buy Now
Updated on September 22, 2026 | View sample data
Share
