Addresses (one per line)
Split result
Paste Japanese addresses above (one per line) to split them into prefecture, city/ward, town & block, and building.
Split a list of Japanese addresses into prefecture (都道府県), city/ward (市区町村), town & block (町名・番地) and building (建物名) columns. Paste your addresses one per line and every row is parsed at once using a built-in list of all 47 prefectures and a set of splitting rules, so you can check the result in a table and copy or save it as TSV (tab-separated, ready to paste into Excel) or CSV. There's no need to build LEFT/MID formulas or fix each row with 'text to columns'. Prefectures are matched reliably against the full 47-prefecture list; the city/ward step handles cities whose name contains the 市 character (四日市市, 廿日市市, 野々市市), the wards of designated cities (横浜市港北区, さいたま市大宮区) and county-plus-town forms (西多摩郡瑞穂町) as well as it can. The remaining town & block and building name are separated using whitespace and common building words (ビル, マンション, 号室 and the like) as hints — building detection is best-effort, so you can adjust the output if needed. Options let you normalize full-width digits and hyphens in the block to half-width and turn the building column on or off, and these settings are remembered next time (the addresses you paste are not stored). It's handy for mail-merge and envelope printing, tidying up customer data, or grouping by area. Nothing you paste is sent to a server — everything runs in your browser.
How to use
- Paste the addresses you want to split, one per line.
- Optionally turn on normalize (half-width digits/hyphens) and the building column, pick TSV or CSV, and check the table.
- Click "Copy" or "Download" and use the TSV (paste straight into Excel) or CSV.
FAQ
Do I need Excel functions or 'text to columns'?
No. Paste addresses one per line and they're split into prefecture, city/ward, town & block (and building) columns at once. You don't have to build LEFT/MID/FIND formulas or fix each row with 'text to columns' — copy the result as TSV and paste it straight into Excel cells, or save it as CSV.
Are tricky municipalities like 四日市市 or 横浜市港北区 handled?
As far as possible, yes. Prefectures are matched against the full 47-prefecture list; the city/ward step handles cities whose name contains 市 (四日市市, 廿日市市, 野々市市), the wards of designated cities (横浜市港北区, さいたま市大宮区) and county-plus-town forms (西多摩郡瑞穂町). A few unusual addresses may still split wrong, so check the table and adjust if needed.
How are the block and building name separated?
The town & block and building name are separated using whitespace in the address and common building words (ビル, マンション, アパート, 号室 and so on) as hints. Building names vary a lot, so this is best-effort: you can turn the building column off, and you can normalize full-width digits and hyphens in the block to half-width.
Is what I paste uploaded?
No. All splitting happens in your browser; nothing is sent to a server or stored. Only your settings — normalize on/off, building column on/off and the copy format — are kept. You can safely process address lists that contain personal data.