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 | Kyoto | Koyamanishi Motomachi | ||
| JP | Japan | Aomori Prefecture | Korekawa | ||
| JP | Japan | Fukushima Prefecture | Field stand |
Locations File
| Country Code | Country | Region | City | Postal Code |
|---|---|---|---|---|
| JP | Japan | Kagoshima prefecture | Amami City | 894 - 0023 |
| JP | Japan | Hokkaido | Otobe-cho, Nishi-gun | 043 - 0103 |
| JP | Japan | Kanagawa Prefecture | Hadano City | 257 - 0051 |
Streets File
| Country Code | Country | Region | City | Postal Code | Street | Latitude | Longitude | Elevation (m) | Geocoding Level | Accuracy Radius (m) |
|---|---|---|---|---|---|---|---|---|---|---|
| JP | Japan | Niigata Prefecture | Gosen City | 959 - 1848 | Main street | 34.8366434 | 134.6902419 | 15 | CITY | 1000 |
| JP | Japan | Saga Prefecture | Saga City | 840 - 0046 | Main street | 33.2635416 | 130.3007965 | 8 | CITY | 1000 |
| JP | Japan | Saga Prefecture | Saga City | 840 - 0822 | Main street | 33.2635416 | 130.3007965 | 8 | CITY | 1000 |
Addresses File
| Country Code | Country | Region | City | Postal Code | Street | Number | Latitude | Longitude | Elevation (m) |
|---|---|---|---|---|---|---|---|---|---|
| JP | Japan | Shimane Prefecture | Matsue | 690 - 0868 | Main street | 34.2413916 | 135.1305479 | 8 | |
| JP | Japan | Miyagi Prefecture | Kami-cho, Kami-gun | 981 - 4319 | Main street | 35.6476464 | 134.6412076 | 15 | |
| JP | Japan | Tokyo | North District | 114 - 0016 | Main street | 35.7503311 | 139.7487673 | 7 |
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 October 13, 2026 | View sample data
Share
