How to use
- Drop an
.xlsx,.csvor.tsvfile, or paste cells copied from Excel. This page opens with the Address cleanup · split step already added. - Pick the address column.
- Tick the columns to add: ZIP code, region, district, detail address, address type, and the note in parentheses. New columns are inserted right after the address column.
- Set the options (official region names, space cleanup, moving parenthesized notes), check the result and the step report (
Split 6 addresses), then download.
How an address is split
The address is cut into space-separated tokens and read from the front.
- ZIP code: a 5-digit number at the very start or end (including
06236,(06236),[06236]) is pulled out. - Parenthesized note (optional): a part such as
(역삼빌딩)is moved out of the detail address into its own column. - Region (si/do): if the first token is the official name or an abbreviation of one of the 17 regions, it is the region.
- District (si/gun/gu): if the next token has at least two letters and ends in
시,군or구, it is the district. When a시is followed by a구, as in수원시 영통구, both go into the district column. - Detail address: everything left.
Computed results
Options: official names on, space cleanup on, parenthesis split on.
| Input | ZIP | Region | District | Detail | Type | Note |
|---|---|---|---|---|---|---|
서울 강남구 테헤란로 152 |
서울특별시 | 강남구 | 테헤란로 152 | Road name | ||
경기 수원시 영통구 광교로 107 |
경기도 | 수원시 영통구 | 광교로 107 | Road name | ||
06236 서울특별시 강남구 테헤란로 152 |
06236 | 서울특별시 | 강남구 | 테헤란로 152 | Road name | |
서울시 강남구 역삼동 123-45 (역삼빌딩) |
서울특별시 | 강남구 | 역삼동 123-45 | Lot number | 역삼빌딩 | |
세종 도움6로 11 |
세종특별자치시 | 도움6로 11 | Road name | |||
전북 전주시 완산구 풍남문2길 1 |
전북특별자치도 | 전주시 완산구 | 풍남문2길 1 | Road name | ||
제주도 제주시 첨단로 242 63309 |
63309 | 제주특별자치도 | 제주시 | 첨단로 242 | Road name | |
부산광역시 해운대구 우동 1408-2 |
부산광역시 | 해운대구 | 우동 1408-2 | Lot number |
Sejong has no district level, so its district cell is empty.
Region name table
With official region names on, every abbreviation below becomes the official name on the left. With it off, the first token is kept as written.
| Official name | Recognized abbreviations |
|---|---|
| 서울특별시 (Seoul) | 서울, 서울시 |
| 부산광역시 (Busan) | 부산, 부산시 |
| 대구광역시 (Daegu) | 대구, 대구시 |
| 인천광역시 (Incheon) | 인천, 인천시 |
| 광주광역시 (Gwangju) | 광주, 광주시 |
| 대전광역시 (Daejeon) | 대전, 대전시 |
| 울산광역시 (Ulsan) | 울산, 울산시 |
| 세종특별자치시 (Sejong) | 세종, 세종시 |
| 경기도 (Gyeonggi) | 경기 |
| 강원특별자치도 (Gangwon) | 강원, 강원도 |
| 충청북도 / 충청남도 | 충북 / 충남 |
| 전북특별자치도 (Jeonbuk) | 전북, 전라북도 |
| 전라남도 (Jeonnam) | 전남 |
| 경상북도 / 경상남도 | 경북 / 경남 |
| 제주특별자치도 (Jeju) | 제주, 제주도 |
Road name vs lot number
When the detail address ends in 로 or 길 plus a number (테헤란로 152, 광교로 107, 풍남문2길 1) it is marked Road name. When it has 동, 읍, 면, 리 or 가 plus a lot number (우동 1408-2) it is marked Lot number. Otherwise the type is blank. Old-style addresses such as 강원 춘천시 중앙로3가 12, where a block unit like 3가 follows the 로, are treated as lot numbers rather than road names.
Things to know
- An address that only says
광주시is read as Gwangju Metropolitan City. Gwangju city in Gyeonggi must be written with its region, as in경기 광주시 …, to be read as a district. - If a token that is not a si/gun/gu (such as
테헤란로or역삼동) follows the region directly, the district cell stays empty and everything goes to the detail address. - Space cleanup also tidies leading, trailing and repeated spaces in the original address column, not just the new ones. Turn it off to keep the original untouched; the detail address then keeps its original spacing.
- With the parenthesis option off,
(역삼빌딩)stays at the end of the detail address. - The parser looks at the shape of the text and does not check against a road-address database, so typos and non-existent place names are not caught. Addresses with no recognizable region are counted in the report.
Related tools
- Stack several steps: Excel & CSV Workbench
- Split a column by delimiter: Split Column
- Keep an address only up to the district and mask the rest: Mask Personal Data
- Keep leading zeros in ZIP codes: Keep Leading Zeros
Your file is processed only in your browser and is never sent to a server.