How to use
- Drop an
.xlsx,.csvor.tsvfile, or paste cells copied from Excel. This page opens with the Phone number format step already added. - Pick the columns that hold phone numbers. You can choose several at once (mobile, home, fax). With no column selected, nothing changes.
- 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.
- 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) becomes010-1234-5678. - Numbers starting with
+82,0082or82-are read as domestic numbers.+82 10-1234-5678becomes010-1234-5678. Numbers from other countries are left alone. - Extensions are kept at the end. A number ending in
내선 123,ext. 123,x123or#123has only its number part normalized; the extension is appended as내선 123orext. 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 checkonly 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.
Related tools
- Stack several steps: Excel & CSV Workbench
- Clean numbers in a contacts file (VCF): VCF Contacts Converter
- Hide the numbers instead: Mask Personal Data
- Remove repeated numbers: Remove Duplicate Rows
Your file is processed only in your browser and is never sent to a server.