Address Normalizer
Auto-fill addresses from postal codes and standardize notation.
Postal Code Search
* Hyphen is optional
Search Result
🔒 All processing except postal code search is done in browser.
Address Normalization
* You can enter multiple addresses separated by line breaks
Normalized Result
🔒 All processing is done in browser. No data sent to servers.
What You Can Do
The Address Normalizer & Postal Code Search tool tidies the notation of many address lines at once and looks up addresses by Japanese postal code. Use it for preparing address data in customer lists or Excel and making a mailing list consistent. It converts digits to full-width, removes spaces and adds/removes the prefecture; it does not check whether an address exists or is correct.
- ✅ Postal Code Search: Auto-fill prefecture, city, and town from postal code
- ✅ Batch Normalization: Process multiple addresses at once, standardize inconsistent notations
- ✅ Browser-based normalization: Your address data is not sent to servers (postal code search sends only the postal code to an external API, zipcloud)
- ✅ Choose from: digits to full-width, space removal, add prefecture (12 city/ward names only) or remove prefecture
- ✅ Batch normalization of multiple addresses
- ✅ Completely free with no registration required
Use Cases
- Unify address notation in customer database
- Quickly input addresses from postal codes
- Cleanse address data in Excel or spreadsheets
- Fix inconsistent addresses from web forms
- Prepare mailing lists for direct mail campaigns
Technical Knowledge
How Postal Code Search Works (zipcloud)
Postal code search sends the postal code to an external lookup API, "zipcloud", and receives the address. zipcloud is a service built on the postal code data published by Japan Post. Points to know before using the result:
- Data updates: The address shown depends on zipcloud's data. Municipal mergers and changes to town areas may take time to appear.
- Postal code format: Japanese postal codes have 7 digits (e.g., 100-0001). You can search with or without the hyphen, and with full-width digits.
- Multiple town areas: One postal code can cover several town areas. This tool shows only the first one and displays a notice below the result in that case.
- What is sent: Only the postal code you enter. Addresses in the normalization tab are not sent.
💡 Newly created lot numbers or buildings and recently changed town areas may be missing from the result or shown in an old form. If in doubt, check with Japan Post's postal code search.
Address Notation Variations and What This Tool Can Tidy
Japanese addresses can be written in different ways for the same place. Here are common variations and how far this tool tidies them:
- Kanji and Arabic Numerals:
- Example: "千代田一丁目1番1号" vs "千代田1-1-1"
- This tool does not convert these (no kanji ⇔ Arabic numerals, and no rewriting between chōme/banchi/gō and hyphens).
- Full-width and Half-width Mix:
- Example: "千代田1−1" vs "千代田1-1" (mix of full-width and half-width digits)
- An option converts half-width digits to full-width. There is no full-width → half-width direction, and hyphen types (- − ー etc.) are not unified.
- Spaces, Line Breaks, and Line Break Codes:
- Notation variation: "Tokyo-to Chiyoda-ku" (two spaces), "Tokyo-to Chiyoda-ku" (full-width space)
- An option removes all half-width and full-width spaces (there is no option to collapse them to one; the space between a building name and room number is removed too).
- Prefecture Notation:
- Notation variation: Missing prefecture ("Chiyoda-ku Chiyoda 1-1"), duplicate prefecture ("Tokyo-to Tokyo-to Chiyoda-ku")
- "Add prefecture" only adds one when the line starts with Sapporo-shi, Sendai-shi, Chiyoda-ku, Chuo-ku, Minato-ku, Shinjuku-ku, Yokohama-shi, Nagoya-shi, Kyoto-shi, Osaka-shi, Kobe-shi or Fukuoka-shi (Chuo-ku and Minato-ku are treated as Tokyo). "Remove prefecture" removes one prefecture name at the start of the line.
- ヶ / ケ / が and Old or Variant Characters:
- Example: "霞が関" vs "霞ヶ関" vs "霞ケ関"
- Note: This tool does not convert these. Postal code search results are shown in zipcloud's notation.
📌 In customer databases and delivery addresses, these variations lead to missed duplicates and mismatches. This tool tidies only part of them (full-width digits, spaces and prefectures), so check the remaining variations by eye.
Use Cases for Address Normalization (Data Cleansing, CRM Integration)
Address normalization is not just a data formatting tool, but an important process that significantly impacts overall business processes. Here are specific use cases:
- Customer Database Unification:
- Customer data aggregated from multiple sales channels or stores often has the same customer's address registered in different notations.
- Example: "Taro" is registered via Sales A as "Tokyo-to Chiyoda-ku Chiyoda 1-chome 1-banchi" and via Sales B as "Tokyo-to Chiyoda-ku Chiyoda 1-1"
- Unifying full-width/half-width digits and spaces makes such duplicates easier to spot (the difference between chōme/banchi and hyphens is not unified by this tool).
- CRM/SFA System Integration:
- In CRM systems like Salesforce and HubSpot, normalized address data significantly improves map display and delivery optimization algorithm accuracy.
- Combined with postal code search functionality, human errors during input can be reduced.
- E-commerce Delivery Address Management:
- In online shopping, repeat customers commonly enter the same address in different formats. Discrepancies arise when checking "billing address" and "shipping address" for identity.
- Address normalization improves delivery efficiency and reduces delivery errors (misdelivery, non-delivery).
- Excel/Spreadsheet Data Cleansing:
- Customer data and sales reports accumulated over multiple years in text-based formats contain numerous notation variations.
- Batch normalizing with this tool before importing into CRM or DWH (Data Warehouse) improves data quality and analysis accuracy.
- Direct Mail Preparation:
- Checking addresses with the postal code search and unifying digits and spaces in a mailing list makes the pre-mailing check easier.
- This tool cannot check whether an address exists or is correct, so confirm addresses another way to avoid undeliverable mail.
- Statistical and Marketing Analysis:
- When performing regional customer analysis or sales analysis, if addresses are not normalized, customers in the same region may be counted multiple times, reducing analysis accuracy.
- Address normalization → postal code conversion → latitude/longitude conversion enables advanced geographic analysis.
⚠️ Privacy: Address normalization is completed in your browser, and the addresses you enter are not sent to servers (postal code search sends only the postal code to an external API, zipcloud). You can safely use it with data containing personal information.
What is the Address Normalizer?
This address normalizer and postal code search tool is a free utility for mechanically tidying the notation of Japanese addresses and looking up addresses by postal code. It converts digits to full-width, removes spaces, and adds or removes the prefecture. Address formatting runs in your browser; only the postal code search sends the postal code to an external lookup API (zipcloud).
Batch format full-width/half-width characters and prefecture names. Convenient for data cleansing.
Who is this for?
Office workers standardizing customer address formats, engineers cleansing database address data, and developers normalizing form-submitted addresses.
FAQ
No. The normalization tab only tidies the text you enter according to the options you choose; it does not compare it with an address dictionary or postal code data. Non-existent block numbers or typos stay as they are. To look up an address from a postal code, use the "Postal Code Search" tab.
No. It only turns half-width digits (0-9) into full-width digits (0-9). It does not convert full-width back to half-width, convert between kanji and Arabic numerals, rewrite "1丁目2番3号" as "1-2-3", unify hyphen types (- − ー etc.), or change the width of letters or katakana.
Yes. It removes every half-width and full-width space and tab, so "ABC Bldg 101" becomes "ABCBldg101". To keep separating spaces, run it with this option turned off (there is no option to collapse repeated spaces into one).
No. It only adds one when the line starts with one of 12 city/ward names: Sapporo-shi, Sendai-shi, Chiyoda-ku, Chuo-ku, Minato-ku, Shinjuku-ku, Yokohama-shi, Nagoya-shi, Kyoto-shi, Osaka-shi, Kobe-shi or Fukuoka-shi. Chuo-ku and Minato-ku are treated as Tokyo, so a line that starts with a ward of the same name in Osaka, Nagoya or elsewhere also gets Tokyo. Nothing is added for other municipalities, so check the result. "Remove prefecture" removes only one prefecture name at the start of the line.
Only the 7-digit postal code you enter is sent from your browser to an external lookup API (zipcloud), which returns the address. Addresses in the normalization tab are not sent. When one postal code has several town areas, only the first is shown and a notice appears below the result. Codes with full-width digits or a hyphen can also be searched.
Each line is treated as one address and processed from top to bottom without changing the order. Spaces at both ends of a line are removed and blank lines are dropped from the result, so the number of lines can decrease. If you need to match the result to the original line by line, paste the data without blank lines.
Anything you wish this tool did better? A few words are plenty.