1. Home
  2. Spreadsheets & Data
  3. Address Cleaner & Splitter

Address Cleaner & Splitter

Tidy Korean addresses and split them into region, district and detail columns.

For every format and option in one place, use Excel & CSV Workbench →

Runs in your browser · No upload
Pick the address column and tick the columns to add. Region abbreviations become official names, and ZIP codes and parenthesized notes can be pulled out.

Operations

Split addresses into region, district and detail, and unify names such as 서울시 to 서울특별시.
Columns to add
Files are processed in your browser and never sent to a server.

How to use

  1. Drop an .xlsx, .csv or .tsv file, or paste cells copied from Excel. This page opens with the Address cleanup · split step already added.
  2. Pick the address column.
  3. 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.
  4. 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.

  1. ZIP code: a 5-digit number at the very start or end (including 06236, (06236), [06236]) is pulled out.
  2. Parenthesized note (optional): a part such as (역삼빌딩) is moved out of the detail address into its own column.
  3. Region (si/do): if the first token is the official name or an abbreviation of one of the 17 regions, it is the region.
  4. 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.
  5. 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.

Your file is processed only in your browser and is never sent to a server.

Can't find the tool you need?

Tell us what you want to do. We build the most requested tools first.