1. Home
  2. Spreadsheets & Data
  3. Phone Number Formatter

Phone Number Formatter

Normalize mixed Korean phone numbers to one format, such as 010-1234-5678.

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

Runs in your browser · No upload
Open a file and pick the phone columns to see them unified right away. Numbers that cannot be read can be left, marked or cleared.

Operations

Normalize mobile, area-code and service numbers to one format and restore the leading 0 Excel dropped.
Columns with phone numbers
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 Phone number format step already added.
  2. Pick the columns that hold phone numbers. You can choose several at once (mobile, home, fax). With no column selected, nothing changes.
  3. Choose the output format and what to do with values that cannot be read as a number: leave them, add a “Needs check” column next to them, or clear them.
  4. Review the highlighted cells and the step report (Formatted 6 numbers, 2 numbers not recognized), then download as xlsx, csv or json.

Output formats

Format Mobile Seoul (02)
Hyphen 010-1234-5678 02-1234-5678
Digits only 01012345678 0212345678
Dots 010.1234.5678 02.1234.5678
Spaces 010 1234 5678 02 1234 5678
International +82 10-1234-5678 +82 2-1234-5678

The international format drops the leading 0 of a domestic number and adds +82. Service numbers such as 1588-1234 have no leading 0, so they become +82 1588-1234.

Which numbers are recognized

Type Length Example
Mobile 010, 011, 016, 017, 018, 019 10-11 digits 010-1234-5678
Seoul 02 9-10 digits 02-123-4567, 02-1234-5678
Area codes 031-033, 041-044, 051-055, 061-064 10-11 digits 031-123-4567
Service numbers 15xx, 16xx, 18xx 8 digits 1588-1234
Internet phone 070, safety numbers 050x, toll-free 080 10-12 digits 070-1234-5678, 0505-1234-5678

Anything outside these ranges (wrong length, or a foreign number such as +1 415 …) counts as not recognized. The table below was produced by running the tool.

Input Hyphen Digits only International
010-1234-5678 010-1234-5678 01012345678 +82 10-1234-5678
010 1234 5678 010-1234-5678 01012345678 +82 10-1234-5678
+82 10-1234-5678 010-1234-5678 01012345678 +82 10-1234-5678
1012345678 010-1234-5678 01012345678 +82 10-1234-5678
0212345678 02-1234-5678 0212345678 +82 2-1234-5678
031-123-4567 031-123-4567 0311234567 +82 31-123-4567
15881234 1588-1234 15881234 +82 1588-1234
070-1234-5678 070-1234-5678 07012345678 +82 70-1234-5678
02-123-4567 내선 123 02-123-4567 내선 123 021234567 내선 123 +82 2-123-4567 내선 123
010-1234-5678 (집) not recognized not recognized not recognized

Leading 0, +82 and extensions

  • The 0 that Excel dropped comes back. A number stored as the numeric cell 1012345678 (10 digits starting with 1) becomes 010-1234-5678.
  • Numbers starting with +82, 0082 or 82- are read as domestic numbers. +82 10-1234-5678 becomes 010-1234-5678. Numbers from other countries are left alone.
  • Extensions are kept at the end. A number ending in 내선 123, ext. 123, x123 or #123 has only its number part normalized; the extension is appended as 내선 123 or ext. 123.
  • Values with letters mixed in are not treated as numbers. A note such as (집) (“home”) or 본사 (“head office”) makes the value ambiguous, so it counts as not recognized. To strip the note first, stack Find & Replace in Excel before this step.
  • Numbers already in the right format are not changed, so they are not counted as “formatted” in the report.

Handling numbers that are not recognized

  • Leave: the original value stays. The report shows only the count.
  • Add a “Needs check” column: creates a column right next to the one you picked and writes Needs check only on the problem rows. With several columns you get one per column, such as 전화 Needs check. Filter on that column to fix the rows by hand.
  • Clear: wipes the bad value. This cannot be undone, so keep the original file.

Digits-only format and leading zeros

The digits-only format produces text such as 01012345678. Saving as xlsx stores the column as text cells, so the 0 survives. Opening a CSV in Excel again, however, makes Excel read the column as numbers and drop the 0. If you must hand off a CSV, use the hyphen format, or the ="01012345678" option in Keep Leading Zeros.

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.